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