Lead DW/BI Engineer LOC : Chicago IL

100,000 - 200,000

Job Description:

Responsibilities:

  • Lead development of architectural standards and frameworks for data warehouses considering performance, efficiency, data integrity, scalability and maintainability
  • Develop expertise in mobile marketing and ? proprietary data sets and lead data engineering and modeling efforts to enable insights using agile SDLC practices
  • Design and implement high-performance, resilient, secure and scalable dimensional models, data pipelines and reporting interfaces
  • Provide strong domain-based experience with toolsets and methods to help get the most from current and next-generation data technologies and industry best practices
  • Perform effort estimation for various data warehouse activities and effectively drive data projects to completion
  • Develop rapid prototypes and proofs of concept to help assess strategic opportunities and future BI capabilities
  • Lead the effort to build an efficient multi-tenant self-service BI platform

Requirements & Qualifications:

  • Bachelor's or masterĂ¢??s degree in Computer Science or related discipline or equivalent work experience
  • 7+ years relevant experience designing and delivering DW/BI and analytics solutions
  • Expert level knowledge in designing entire data warehousing/business intelligence architecture end-to-end; including data integration architecture, database schema designs, dimensional data modeling, query performance optimization and reporting/visualization
  • Experience writing complex SQL queries and stored procedures with fluency in one or more programming languages such as Java or Python
  • Awareness of continuous integration and automated testing for data warehouse processes
  • Expert level knowledge in tuning and scaling data management and engineering processes in a high-volume data warehouse environment
  • Expert level knowledge in ETL frameworks and best practices
  • Experience in running large-scale data warehouses on big data technologies such as Amazon Redshift, PostgreSQL clusters or Snowflake using Pentaho/Talend is a plus
  • Good communication and documentation skills
  • Client service attitude with ability to persuade and educate when appropriate
  • Ability to multitask and prioritize work
  • Ability to adapt to changing environments, tools and technologies


Share Profile