Data Engineer

Holmes Murphy is one of the nation’s largest privately held insurance brokerages. It is our mission to promote health, protect wealth, and deliver peace of mind to our clients. We pride ourselves on being a place where employees love what they do, and who they do it with! In fact, we live by our purpose statement of “Caring for your unique potential is our SOUL purpose!”

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! We truly believe every employee within our company contributes their own unique talents for the greater good, and we thrive on knowing our environment supports and cares for everyone’s individual strengths.

We are looking to add a Data Engineer to join our Information Technology team in Waukee, IA. Candidates thrive in our environment when they harness their collaborative mindset, strong interpersonal communication skills, and a love of learning.

This role will support the company’s vision, mission, and strategy by executing tactical plans to build, maintain, and modernize the between systems integrations and data movements required for business continuity, data warehousing, and reporting.

Here’s just a bit of what you’d do:

Works closely with the Enterprise Solutions Architect and Integrations Manager to:

• Build, test, and maintain ETL/ELT flows and SQL queries to support data movement into and out the data warehouse/marts.
• Build, test, and maintain ETL/ELT flows that support data movement between enterprise systems.
• Potentially create, maintain, and optimize SQL queries, views, stored procedures, and functions that support data movement.
• Provide operational support for the scheduled jobs including monitoring, performance tuning, and debugging of data movement flows utilizing automation whenever possible, ensuring continuity and execution of the jobs.
• Works with data analysts and business stakeholders to ensure the quality and accuracy of the data. Assist with data cleansing through bulk changes or insertion of findings into a data quality and stewardship framework.
• Work with the Enterprise Solutions Architect on strategy and architecture of the modernization of legacy integrations and ETL flows. Assist in the building, testing, and conversion to the modern architecture.
• Work with the Enterprise Solutions Architect on development of the data mart architecture for model management and mart delivery to data consumers.

 You’d also need to be equipped with the knowledge, skills, and abilities to do the job, including, but not limited to:

• Experience building ETL dataflows. Alteryx or Azure Data Factory preferred.
• Hands-on experience with a variety of data sources, structured and unstructured, such as delimited, fixed width, database, blob, etc.
• Experience with APIs and/or RPA for the collection of third-party data preferred. Salesforce and Azure experience a plus.
• Experience with cloud data storage, Azure preferred.
• Experience with/knowledge of modern data tools and technologies such as Snowflake, Azure Synapse, Databricks, dbt, Census, FiveTran, etc. a plus.
• Knowledge of Insurance Industry preferred but not required.
• Excellent organizational skills and the ability to manage multiple tasks/projects simultaneously.
• Communication skills required. Must be able to effectively communicate within the Enterprise IT and integrations team.
• Capable of exercising discretion in confidential matters and use independent judgment.
• Must be knowledgeable of and comply with our Client Privacy Policy, HIPAA regulations and E&O procedures and policies.

And let’s not forget the qualifications for the position:

• Education: Associate’s or Bachelor’s degree in a science, technology or engineering, or math-related, or equivalent work experience.
• Experience: 3+ years of work-related experience.

Benefits:  In addition to core benefits like health, dental and vision, also enjoy benefits such as:

• 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.
• Flexible work arrangements and schedules — We truly want to know what works for you as we look to support your unique and full potential.
• 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?!

Holmes Murphy & Associates is an Equal Opportunity Employer.