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
Company H1B Sponsorship