Data Engineer

Holmes Murphy Insurance•West Des Moines, IA

33d

About The Position

We are looking to add a Data Engineer to join our Information Technology team in West Des Moines, IA. Offering a forward-thinking, innovative, and vibrant company culture, along with the opportunity to share your unique potential, there really is no place like Holmes!

Requirements

Education: Bachelor’s degree in computer science, data science, technology, information systems or engineering preferred.
Experience: 3-5 years of professional experience in data, analytics, or platform engineering or related work-related experience strongly preferred.
Skills: 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; Salesforce experience is a plus.
Knowledge of source control, cloud data storage, and platforms such as Snowflake or Azure preferred.
Technical Competencies: Possesses strong business and technology knowledge to understand business needs, make informed decisions, and deliver effective technology solutions, including related processes and procedures.
Demonstrates excellent problem-solving skills to efficiently identify issues, determine root causes, and propose and implement effective solutions or improvements.

Nice To Haves

Familiarity with APIs or RPA for third-party data collection; Salesforce experience is a plus.
Knowledge of source control, cloud data storage, and platforms such as Snowflake or Azure preferred.

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.

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?!
Grow Your Career – In our growing and dynamic organization, we encourage talent mobility, whether that be career progression, expanding skillsets, or even transferring to another Holmes Murphy office!
Learn... On Us – We believe in building the best experts in the industry, supported through a variety of benefits like continuing education and tuition reimbursement.
Share in Our Success – Our philosophy is to share in our collective success. One of the many ways we accomplish that is through our 401(k)-profit share, which is distributed to all employees regardless of their own contributions!
Take Time to Recharge – We offer generous time off, including a Health Matters Day, Celebrate Day (for your birthday!), Diversity Day, Volunteer Time Off, and paid parental leave. And yes, we encourage you to take time away!