Date Warehouse Developer

Location US-IL-Chicago
Job ID
Information Systems
Position Type


The Data Warehouse Developer will work as a member of the Enterprise Information Management and Analytics team, reporting to the Manager, Enterprise Information Management and Analytics. This individual will work with the latest on-premise and cloud-based Microsoft BI/DW solutions. This position is hands-on (does development) and the individual will enhance the capabilities of the data warehouse environments.


  • Architect, design, build, implement, and maintain solutions to meet business needs for the data warehouse and data mart environments using the Microsoft BI/DW stack.
  • Works with the DW Lead, DW Manager and the Business Analysts to design and architect a Data warehouse solution including ETL, Data Modeling and Report development.
  • Acts as the technical subject matter expert for the Microsoft data warehouse and ETL landscape within the organization.
  • Stays current on the technology, tools, and approaches in the BI/DW/cloud space, especially around the Azure platform.
  • Solves complex problems and develops proofs of concept to validate ideas or technologies.
  • Works on multiple initiatives simultaneously.
  • Creates and owns best practice standards and templates.
  • Helps support the system and troubleshoots system related issues.
  • Maintain ETL and supporting data objects for our growing Enterprise DW infrastructure.
  • Assist the Database Architecture team to carry out monitoring, tuning, and database performance analysis.


Formal Education & Certification

  • College diploma, university degree or similar education in computer science, information systems, or computer engineering.


Knowledge & Experience

  • 8+ years of experience in Information Technology.
  • 5+ years of experience architecting, designing, and developing BI/Data Warehouse solutions using the Microsoft BI/DW stack (e.g. SQL Server, SSIS, SSAS tabular, SSRS Power BI, Azure).
  • 5+ years of experience working with SQL, SQL stored procedures, and relational/multidimensional databases environments.
  • 5+ years of experience working with BI tool architectures, functions, and features.
  • Experience with cloud (preferably Azure) development and services like SQL PaaS, or Data factory.
  • Demonstrated ability to write SQL/TSQL queries to retrieve/modify data.
  • Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations.
  • Ability to work in an Agile environment.
  • Object oriented programming experience (e.g. using Java, J2EE, NET, etc.).
  • Experience with visualization tools such as Tableau, PowerBI, PowerPivot, and other reporting and analytical tools.
  • Prior experience in working with an offsite and offshore team.


Personal Attributes

  • Strong written and oral communication skills.
  • Strong presentation and interpersonal skills.
  • Ability to present ideas in user-friendly language.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.