Data Engineer, ICS

Holmes Murphy is one of the nation’s largest privately held insurance brokerage companies. 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 fast-paced work environment and vibrant company culture, and the opportunity to share your unique potential, there really is no place like Holmes! We are looking to add a Data Engineer to join our Innovative Captive Strategies team in Waukee, IA or Remote. Ideal candidates will have an innovative mindset, strong interpersonal skills, and a love of learning.

This role will support Innovative Captive Strategies division and overall company vision, mission and strategy by executing tactical plans to build and mature the data strategy for ICS.


Work closely with ICS Leaders and Business Partners to:

  • Execute tactical plans to build and mature the data strategy.
  • Builds, tests, and maintains ETL flows to support data movement into and out of the claim management system and supports ICS data in the enterprise data lake.
  • Create, maintain, and optimize queries, views, stored procedures, and functions which support data movement.
  • Provides operational support for the scheduled jobs including monitoring, performance tuning and debugging of data movement flows utilizing automation whenever possible.
  • Works with the ICS data analysts and business stakeholders to ensure the quality and accuracy of the data. Assist with data cleansing through bulk changes or development of a data strategy to address any data quality findings.

Knowledge, Skills, and Abilities:

  • Experience building scalable and robust ETL dataflows which maximize configuration and reusability to support data transformation, data movement, data structures and metadata. 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. Salesforce experience preferred.
  • Experience with cloud data storage, Azure preferred.
  • Familiarity with data governance practices and data quality.
  • Knowledge of Insurance Industry preferred.
  • Ability to thrive in a fast-paced, ambiguous, highly collaborative environment.
  • Eagerness to learn independently.
  • Ability to challenge the status quo.
  • Excellent organizational skills and the ability to manage multiple tasks/projects simultaneously.
  • Communication skills required. Must be able to effectively communicate strategies and designs to all levels of the company.
  • Capable of exercising discretion in confidential matters and use independent judgment.
  • Ability to work with various personalities and in urgent scenarios.
  • Ability to maintain a professionalism.
  • Must be knowledgeable of and comply with our HIPAA regulations.


Education:        Associates or Bachelor’s degree in a science, technology or engineering, or math related, or equivalent work experience.

Experience:    At least four years of work-related experience.


  • Responsible Time Off
  • Tuition Reimbursement after 1 year of employment
  • Fitness Reimbursement
  • Generous Parental Leave for all
  • New Parent Benefits
  • 401k Profit Sharing
  • Flexible/remote work arrangements

Holmes Murphy & Associates is an Equal Opportunity Employer.