Data Engineer

westmonroe4

Chicago (IL)

Hybrid

USD 98,000 - 142,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

West Monroe is seeking a Data Engineer to join our Data Engineering & Analytics team. You will collaborate with clients to address complex needs and work with highly skilled engineers and architects on enterprise data projects and large-scale implementations.

The role involves agile delivery, data ingestion, quality rules, data mapping, and reporting/semantic modeling for BI tools like Tableau and Power BI. Travel 30–50% and a hybrid in-office schedule are expected.

Qualifications

  • 1–4 years of hands-on professional development experience.
  • Strong SQL querying experience.
  • Experience with Spark, Databricks, Kafka, Kinesis, Hadoop, and/or Lambda.
  • Exposure to ETL tools (Azure Data Factory, AWS Glue, Informatica, Talend, IBM DataStage, etc.) and/or database platforms (Snowflake, Redshift, Azure Synapse, or Oracle).
  • Exposure to data visualization tools (Tableau, Power BI, Looker).
  • Strong verbal and written communication skills.
  • Ability to travel 30–50% to client sites.
  • Hybrid role – 2 days a week in office.

Responsibilities

  • Support projects using an agile delivery model with requirements gathering and documentation.
  • Develop data ingestion pipelines and perform technical testing.
  • Add configurations for data enrichments and lookups.
  • Implement data quality rules and connect to new data sources.
  • Map multiple sources into a single output and troubleshoot pipelines.
  • Create outputs for reporting, dashboards, and semantic modeling (Tableau, Power BI).
  • Test data pipelines to ensure accuracy.
  • Collaborate with clients to gather requirements and develop solutions.
  • Coordinate with data source owners to ensure data integrity.
  • Build strong client relationships through clear written and verbal communication.

Skills

SQL queries
Communication
Travel readiness
Hybrid role

Tools

Spark
Databricks
Kafka
Kinesis
Hadoop
Lambda
ETL tools
Snowflake
Redshift
Azure Synapse
Oracle
Tableau
Power BI
Looker

Job description

Are you ready to make an impact?

West Monroe is seeking a talented Data Engineer to join our Data Engineering & Analytics team. In this role, you will collaborate with our clients to address their most complex needs, working alongside a team of highly skilled engineers and architects. You will also be involved in strategic enterprise data projects and large-scale implementations.

Responsibilities:

Support projects leveraging an agile delivery model through requirements gathering and documentation, data ingestion pipeline development, and technical testing.

  • Add configurations for data enrichments such as lookups, type conversions, calculations, and concatenations
  • Add data quality rules
  • Connect to new data sources
  • Map multiple sources into a single output
  • Interpret error messages to troubleshoot data pipelines
  • Create outputs that facilitate reporting, dashboarding, and semantic modeling for tools such as Tableau and Power BI
  • Test data pipelines to ensure accuracy
  • Work closely with our clients as part of the development team to gather technical requirements and develop solutions
  • Coordinate activities with data source application owners to understand the underlying data, ensure integration and data integrity
  • Build relationships with clients through written and verbal communication
Qualifications:
  • 1 - 4 years of hands-on professional development experience
  • Experience writing complex SQL queries related to data manipulation strategies
  • Experience with Spark, Databricks, Kafka, Kinesis, Hadoop, and/or Lambda
  • Exposure using ETL tools (Azure Data Factory, AWS Glue, Informatica, Talend, IBM DataStage, etc.), and/or database platforms (Snowflake, Redshift, Azure Synapse, or Oracle)
  • Exposure to data visualization tools (Tableau, Power BI, Looker)
  • Experience in technical testing, issue identification and resolution
  • Strong verbal and written communication skills
  • Ability to travel 30 to 50% to client sites
  • Hybrid role - 2 days a week in office

Based on pay transparency guidelines, the salary range for this role can vary based on your proximity to one of our West Monroe offices (see table below). Information on our competitive total rewards package, including our bonus structure and benefits is here . Individual salaries are determined by evaluating a variety of factors including geography, experience, skills, education, and internal equity.

  • Employees (and their families) are covered by medical, dental, vision, and basic life insurance.
  • Employees are able to enroll in our company's 401k plan, purchase shares from our employee stock ownership program and be eligible to receive annual bonuses.
  • Employees will also receive unlimited flexible time off and ten paid holidays throughout the calendar year.
  • Eligibility for ten weeks of paid parental leave will also be available upon hire date.
Salary by Location:
  • Seattle or Washington, D.C.: $92,800 - $109,200 USD
  • Los Angeles: $97,200 - $114,400 USD
  • New York City or San Francisco: $101,700 - $119,600 USD
  • A location not listed above: $88,400 - $104,000 USD

Other consultancies talk at you. At West Monroe, we work with you.

We're a global business and technology consulting firm passionate about creating measurable value for our clients, delivering real-world solutions.

The combination of business and technology is not new, but how we bring them together is unique. We're fluent in both. We know that technology alone is not the answer, but how we apply it is. We rely on data to constantly adapt and solve new challenges. Actions that work today with outcomes that generate value for years to come.

At West Monroe, we zero in on the heart of the opportunity, getting to results faster and preparing people for what's next.

You'll feel the difference in how we work. We show up personally. We're right there in the room with you, co-creating through the challenges. With West Monroe, collaboration isn't a lofty promise, but a daily action. We work together with you to turn vision into clear action with lasting impact.

West Monroe 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. To learn more about diversity, equity and inclusion at West Monroe, visit www.westmonroe.com/inclusion . If you require a reasonable accommodation to participate in our recruiting process, please inquire by sending an email to recruiting@westmonroe.com .

Please review our current policy regarding use of generative artificial intelligence during the application process . Additionally, West Monroe uses the BrightHire platform to record live interviews so our team can capture notes more accura

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

West Monroe • Los Angeles (CA)

Hybrid
USD 132,000 - 155,000
Health insurance
401k savings plan
Bonuses
+3
Director, Data Engineering & AI
Director, Data Engineering & AI

West Monroe (Campus) • Los Angeles (CA)

Hybrid
USD 200,000 - 250,000
Unlimited flexible time off
Ten paid holidays
401k plan
+2
Senior Architect, Data Engineering
Senior Architect, Data Engineering

West Monroe • Los Angeles (CA)

On-site
USD 205,000 - 234,000
Medical Insurance
Dental Insurance
Vision Insurance
+7
Data Architect, Google Cloud Platform (GCP)
Data Architect, Google Cloud Platform (GCP)

West Monroe • Los Angeles (CA)

Hybrid
USD 167,000 - 197,000
Senior Architect, Databricks
Senior Architect, Databricks

West Monroe • Los Angeles (CA)

Hybrid
USD 205,000 - 234,000
Experienced Consultant, Consumer & Industrial Products
Experienced Consultant, Consumer & Industrial Products

West Monroe • New York (NY)

Hybrid
USD 98,000 - 120,000
2027 Data & Analytics Consultant
2027 Data & Analytics Consultant

West Monroe • San Francisco (CA)

Hybrid
USD 70,000 - 95,000
Hybrid work model
Learning through competency teams
Senior Architect, Databricks
Senior Architect, Databricks

westmonroe4 • Chicago (IL)

Hybrid
USD 184,000 - 213,000
Medical, dental, vision, and basiclife
401k plan with company matching
Employee stock ownership program
+3
2027 Data & Analytics Consultant
2027 Data & Analytics Consultant

West Monroe • Chicago (IL)

Hybrid
USD 60,000 - 80,000
Hybrid work model
Learning & development opportunities
2027 Data & Analytics Consultant
2027 Data & Analytics Consultant

West Monroe • Los Angeles (CA)

Hybrid
USD 65,000 - 90,000