Senior Data Engineering Consultant, Data Senior Data Engineering Consultant, Data …

West Monroe Partners
in Chicago, IL, United States
Permanent, Full time
Be the first to apply
West Monroe Partners
in Chicago, IL, United States
Permanent, Full time
Be the first to apply
Senior Data Engineering Consultant, Data

Data Engineering Senior Consultant - BI, Data Viz, ETL, etc.

311 West Monroe Street, 14th Floor
Chicago, Illinois, 60606
United States

At West Monroe, our people are our business.

We pride ourselves on bringing a different mindset to consulting—and that takes a different approach: highly collaborative, flexible, and tenacious.

Our people-first culture is core to our identity. It’s something we care about, and something we strive to enrich and preserve. No hierarchies. No siloes. No egos. Just smart ideas, unique perspectives, and the drive to make an impact for our clients. 

We also know that the best outcomes for both our people and our clients result from including diverse perspectives at the table. That’s why inclusion & diversity is one of our core values. 

Every day our clients rely on us to help them tackle their greatest challenges, by strategically deploying technology through a business-focused and industry-specific lens. We bring together both the right knowledge and the right approach, so that they can capitalize on opportunities and deliver real results. That takes the right team. And that’s where you come in.

Ready to thrive in the next step on your career journey?

Core Responsibilities:  

  • Work closely with our clients as part of a development team to evaluate requirements and develop business intelligence and data warehousing solutions·  
  • Design and develop data warehouse database schemas·  
  • Design and develop extract, transform, and load (ETL) mappings, procedures, and schedules·  
  • Coordinate activities with data source application owners to ensure integration and data integrity
  • Design and develop reports, dashboards, KPIs, and data extracts 


  • Minimum 4+ years of hands on professional development experience  
  • Strong technical experience in ETL tools (Informatica, IBM DataStage, Snowflake, or Microsoft Integration Services), database platforms (Oracle or SQL Server), and reporting tools (SSRS or other)
  • Experience performing complex data migration to and from disparate data systems/platforms as well as to/from the cloud (AWS, Azure, GCP, etc.)
  • Experience with the Microsoft SQL Server platform is required
  • Experience with Data Visualization tools including PowerBI, Tableau, Looker, etc.
  • Good knowledge of standard concepts, best practices, and procedures within a data warehousing and Business Intelligence (BI) environment  
  • Excellent organizational and communication skills to work in a fast-paced environment and manage and prioritize multiple tasks simultaneously  
  • Desire to work across our core industries including but not limited to Financial Services, Energy & Utilities, Consumer & Industrial Products, and Healthcare & Life Sciences
  • Ability to work well in a team of 2 – 5 consultants

Ready to get started? Join our team and make an impact. 

To learn more about inclusion and diversity at West Monroe, visit  

West Monroe Partners is an Equal Employment Opportunity Employer 
We believe in treating each employee and applicant for employment fairly and with dignity. We base our employment decisions on merit, experience, and potential, without regard to race, color, national origin, sex, sexual orientation, gender identity, marital status, age, religion, disability, veteran status, or any other characteristic prohibited by federal, state or local law.

More Jobs Like This
See more jobs