Data Engineer

Data Engineer

Urbandale, IA

About Us

Integrity is an omnichannel insurtech company innovating insurance with a singular purpose: making insurance simpler and more human, so everyone can plan for the good days ahead! With billions in funding from HGGC, Harvest Partner, SilverLake, we leverage techniques that include predictive modeling, custom dynamic dashboards, next- best-action and behavior triggers, as well as other cutting-edge methods like natural language processing (NLP) to inform decision-making and streamline processes. 

Integrity has experienced significant growth in the past three years, increasing earnings more than 800%. We are an employee owned company, and are also incredibly proud of our women in leadership, from our C-Suite executives to our managing partners and more (women also make up 63% of our workforce!) We recognize the importance of having equal representation throughout our organization — and that starts at the top!

Job Summary

The Data Engineer I has development and support responsibility for our business-critical data. In addition, this position is responsible for implementing the established data architecture, relying on experience and good judgement to design solutions that expand our solid foundation. Work directly with our Database Architect and Engineer to design and build an innovative analytics solution that will drive our business. Work with data analysts and teams to ensure high quality in data and to ensure delivery of successful product(s). Use industry leading tools to develop and manage our next generation Data Warehouse.

Primary Responsibilities:

• Perform ETL (Extract, Transform, Load) and develop data pipelines that integrate data sets from source systems and third-party data structures into a consumable and accessible format for analysis and reporting with a mind toward accuracy, scalability, and high performance.

• Support the Data Warehouse by responding to process failures, data anomalies and performance events by taking appropriate measures to reduce system downtime and eliminate recurrence of problems.

• Adhere to data security requirements and solutions: ensure that data (both on-premises and in the cloud) is treated as a protected asset.

• Performs thorough testing of data pipelines and data models to ensure data is accurate and pipelines are resilient and self-healing.

• Modify existing reports and/or develop new reports by analyzing databases, data sources and data structures, delivering critical reporting to customers both internally and externally.

• Other duties as assigned.

Primary Skills & Requirements:

• 2-4 years professional experience developing and supporting high performing ETL processes, including data quality and testing processes required.

• 2-4 years professional experience designing and developing enterprise data solutions and integrations, data warehouse, data modeling (star schema, etc) required.

• Knowledge of database management and data warehousing required.

• Strong proficiency in SQL, Azure Data Factory, and other Azure technologies preferred.

• Knowledge in data standard formats including but not limited to Acord, DTCC, DST, DAZL, etc. a preferred.

• Knowledge in Business Intelligence tool PowerBI, Tableau, or equivalent a preferred.

• Familiarity in supporting Wealth platforms including Black Diamond, Pershing, Charles Schwab, Salentica, Nexus a preferred.

• Bachelor’s Degree in analytics, statistics, mathematics, engineering, computer science, information systems, or equivalent combination of education and experience.

Benefits Available

• Medical/Dental/Vision Insurance

• 401(k) Retirement Plan

• Paid Holidays

• PTO

• Community Service PTO

• FSA/HSA

• Life Insurance

• Short-Term and Long-Term Disability

About Integrity

Integrity is one of the nation’s leading independent distributors of life, health and wealth insurance products. With a strong insurtech focus, we embrace a broad and innovative approach to serving agents and clients alike. Integrity is driven by a singular purpose: to help people protect their life, health and wealth so they can prepare for the good days ahead.

Integrity offers you the opportunit