Apply on Employer Site

Holmes Murphy · 1 day ago

Data Engineer

West Des Moines, IA

Full-time

Onsite

Mid Level

3+ years exp

Holmes Murphy is a forward-thinking, innovative, and vibrant company seeking to add a Data Engineer to their Information Technology team. The role involves designing and implementing complex data pipelines, optimizing performance, and providing mentorship to junior engineers.

Employee BenefitsFinancial ServicesInsuranceProperty InsuranceRisk Management

Growth Opportunities

Responsibilities

Design and Implement Complex Pipelines: Design, build, and optimize ETL/ELT workflows from multiple sources, enhancing performance and reliability. Azure Data Factory, Alteryx, Fabric, dbt, SQL, and other tools

Advanced Data Transformations: Implement transformations, aggregations, and custom logic to meet business requirements

Data Modeling and Storage Optimization: Contribute to data modeling efforts, recommending storage solutions and structures that support analytical requirements

Pipeline Monitoring and Optimization: Proactively monitor pipelines, perform root cause analysis for performance issues, and implement improvements

Mentorship and Guidance: Provide guidance to junior engineers on best practices in data extraction, transformation, and loading

Qualification

ETL/ELT dataflowsAzure Data FactoryData modelingAlteryxSQLSnowflakeProblem-solvingMentorshipCommunication

Required

Bachelor's degree in computer science, data science, technology, information systems or engineering

3-5 years of professional experience in data, analytics, or platform engineering or related work-related experience

Experience building ETL/ELT dataflows using tools like dbt, Alteryx, Azure Data Factory, or Microsoft Fabric

Skilled in working with diverse data sources (structured and unstructured), including delimited, fixed width, databases, and blob storage

Familiarity with APIs or RPA for third-party data collection

Knowledge of source control, cloud data storage, and platforms such as Snowflake or Azure

Possesses strong business and technology knowledge to understand business needs, make informed decisions, and deliver effective technology solutions

Demonstrates excellent problem-solving skills to efficiently identify issues, determine root causes, and propose and implement effective solutions or improvements

Benefits

Paid Parental Leave and supportive New Parent Benefits — We know being a working parent is hard, and we want to support our employees in this journey!

Company paid continuing Education & Tuition Reimbursement — We support those who want to develop and grow.

401k Profit Sharing — Each year, Holmes Murphy makes a lump sum contribution to every full-time employee’s 401k. This means, even if you’re not in a position to set money aside for the future at any point in time, Holmes Murphy will do it on your behalf! We are forward-thinking and want to be sure your future is cared for.

Generous time off practices in addition to paid holidays — Yes, we actually encourage employees to use their time off, and they do. After all, you can’t be at your best for our clients if you’re not at your best for yourself first.

Supportive of community efforts with paid Volunteer time off and employee matching gifts to charities that are important to you — Through our Holmes Murphy Foundation, we offer several vehicles where you can make an impact and care for those around you.

DE&I programs — Holmes Murphy is committed to celebrating every employee’s unique diversity, equity, and inclusion (DE&I) experience with us. Not only do we offer all employees a paid Diversity Day time off option, but we also have a Chief Diversity Officer on hand, as well as a DE&I project team, committee, and interest group. You will have the opportunity to take part in those if you wish!

Consistent merit increase and promotion opportunities — Annually, employees are reviewed for merit increases and promotion opportunities because we believe growth is important — not only with your financial wellbeing, but also your career wellbeing.

Discretionary bonus opportunity — Yes, there is an annual opportunity to make more money. Who doesn’t love that?!