Data Engineer

West Monroe is a global business and technology consulting firm passionate about creating measurable value for clients. They are seeking a talented Data Engineer to join their Data Engineering & Analytics team, where the role involves collaborating with clients on complex data projects and developing data ingestion pipelines. Responsibilities Support projects leveraging an agile delivery model through requirements gathering and documentation, data ingestion pipeline development, and technical testing Contribute to project delivery in the following ways: 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 Skills 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 Benefits 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. Employees can purchase shares from our employee stock ownership program. Employees are eligible to receive annual bonuses. Employees will also receive unlimited flexible time off. Employees will receive ten paid holidays throughout the calendar year. Eligibility for ten weeks of paid parental leave will also be available upon hire date. Company Overview West Monroe offers digital transformation, analytics, cloud, cyber security, business advisory, and management consulting services. It was founded in 2002, and is headquartered in Chicago, Illinois, USA, with a workforce of 1001-5000 employees. Its website is Company H1B Sponsorship West Monroe has a track record of offering H1B sponsorships, with 4 in 2025, 2 in 2024, 2 in 2023, 10 in 2022, 7 in 2021. Please note that this does not guarantee sponsorship for this specific role.