Lead Data Engineer

Join a dynamic and fast-paced environment where technology drives innovation in the insurance industry. As an omnichannel Insurtech company, we believe work should be meaningful, impactful, and enjoyable. You’ll be working on one of the most exciting data and technology opportunities in the country—comparable to what’s happening at Google or Microsoft—while helping to change lives, including your own.

We are seeking an experienced and highly motivated Lead Data Engineer to lead and support the development of large-scale, complex data implementations. You will collaborate closely with the Data Engineering teams to build, enhance, and maintain a scalable data ecosystem. The ideal candidate will have experience managing distributed teams (onsite, remote, and international), and a commitment to continuous improvement and innovation.

Responsibilities

• Lead the analysis, design, and implementation of data solutions within the Enterprise Data Warehouse (EDW).
• Collaborate with business and technical stakeholders to gather requirements and prepare technical documentation.
• Design, build, and maintain ETL pipelines using Azure Data Factory, Logic Apps, and other modern data tools.
• Conduct Data mapping, Data Collection, Data profiling and Data storage plans to support project/product needs.
• Write efficient T-SQL, DDL/DML scripts, and develop stored procedures, functions, and complex Snowflake procedures.
• Manage the development and maintenance of robust Snowflake and SQL scripts for data extraction and transformation.
• Ensure high-quality, scalable data integration solutions across platforms and business functions.
• Define and execute test strategies, scenarios, and test data for all development deliverables.
• Partner with business users to optimize processes, improve existing systems, and troubleshoot data and integration issues.
• Support release management through all environments (Dev, QA, Production) and address any QA defects.

Position Requirements (Knowledge, Skills, and Abilities)

• Skilled in advanced SQL, including query optimization and stored procedure development.
• Knowledge of enterprise data warehousing, data modeling, and analytics best practices.
• Experienced in leading data engineering team with 5+ years of experience in technical project management within the EDW/BI space.
• Experienced in Master Data Management (MDM) and Snowflake
• Good working knowledge of Microsoft Azure services, including Azure Data Factory (ADF), and Logic Apps
• Experienced in ETL tools such as Talend, Nexla, Stitch, or Mito.
• Knowledge of data orchestration and scheduling tools such as Apache Airflow.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent communication and interpersonal abilities.
• Self-starter with a high level of initiative and drive.

Education

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field is required.
• 10+ years of experience in data engineering or a related field.
• Experience successfully leading project-based team.

Licensing and/or Certification

• Certification in Azure, Snowflake and any ETL tools are preferred.
• Certification on any AI tool and solutions are preferred.

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 opportunity to start a career in a family-like environment that is rewarding and cutting edge. Why? Because we put our people first! At Integrity, you can start a new career path at company you’ll love, and we’ll love you back. We’re proud of the work we do and the culture we’ve built, where we celebrate your hard work and support you daily. Joining us means being part of a hyper-growth company with tons of professional opportunities for you to accelerate your career. Integrity offers our people a competitive compensation package, including benefits that make work more fun and give you and your family peace of mind. 

Headquartered in Dallas, Texas, Integrity is committed to meeting Americans wherever they are — in person, over the phone or online. Integrity’s employees support hundreds of thousands of independent agents who serve the needs of millions of clients nationwide. For more information, visit Integrity.com.

Integrity, LLC is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, national origin, disability, veteran status, or any other characteristic protected by federal, state, or local law. In addition, Integrity, LLC will provide reasonable accommodations for qualified individuals with disabilities.