Data Engineer
West Monroe1 month ago
Chicago, IL, USA +5 moreEntry Level / Mid Level
H1B sponsor
Base Salary
$88k - $120k/yr
Responsibilities
- Gather and document requirements while supporting projects delivered through an agile delivery model.
- Develop data ingestion pipelines and configure enrichments such as lookups, type conversions, calculations, and concatenations.
- Add data quality rules, connect new data sources, map multiple sources into a single output, and troubleshoot pipeline errors.
- Create outputs that support reporting, dashboarding, and semantic modeling.
- Test data pipelines for accuracy and identify and resolve issues.
- Work with clients to gather technical requirements and develop solutions.
- Coordinate with data source application owners to understand underlying data and ensure integration and data integrity.
- Build client relationships through written and verbal communication.
Requirements
- 1–4 years of hands-on professional development experience.
- Experience writing complex SQL queries for data manipulation strategies.
- Experience with Spark, Databricks, Kafka, Kinesis, Hadoop, and/or Lambda.
- Exposure to ETL tools such as Azure Data Factory, AWS Glue, Informatica, Talend, and IBM DataStage.
- Exposure to database platforms such as Snowflake, Redshift, Azure Synapse, or Oracle.
- Exposure to data visualization tools including Tableau, Power BI, and Looker.
- Experience in technical testing, issue identification, and resolution.
- Strong verbal and written communication skills.
- Ability to travel 30–50% to client sites.
Benefits
- Hybrid work arrangement with two days per week in the office.
- Medical, dental, vision, and basic life insurance coverage for employees and families.
- 401(k) plan and eligibility to purchase shares through the employee stock ownership program.
- Eligibility for annual bonuses.
- Unlimited flexible time off and ten paid holidays per calendar year.
- Ten weeks of paid parental leave available upon hire date.
Tech Stack
Categories
Data Engineering
About West Monroe
West Monroe is a Chicago-based business and technology consulting firm that helps enterprises and private equity sponsors improve operations and build digital capabilities. It sells project-based consulting across industries such as financial services, healthcare, energy, and software, including M&A advisory, customer experience, product and data strategy, and cybersecurity. Founded in 2002 and privately held under M/C Partners, it operates from multiple U.S. hubs.