Data Engineer III

About GAINSCO

Founded in 1978, GAINSCO offers property and casualty insurance with an emphasis on non-standard personal auto policies. It serves drivers nationwide by providing minimum-limits personal auto coverage, making insurance more accessible to a broader market. In 2020, State Farm Mutual Automobile Insurance Company acquired GAINSCO, Inc. and its subsidiaries, making a significant milestone that strengthened GAINSCO’s ability to grow and expand its reach in the personal auto industry market while continuing to build on its decades of specialized expertise.

Join a team that is dedicated to supporting your professional growth and long-term success.

Who We Are

At GAINSCO, we are a team driven by passion, creativity, and a commitment to excellence. We celebrate achievements, encourage innovative thinking, and recognize the unique strengths each person brings. Our people truly set us apart.

If you’re seeking a company where your contributions are valued, your efforts have a visible impact, and your dedication is recognized, take the next step in your career with us.

As a Data Engineer III, you’ll play a senior technical role designing, building, and optimizing scalable data pipelines and platforms that power analytics, reporting, and data-driven decision-making across the organization. You’ll lead complex engineering efforts, raise the bar on quality and reliability, mentor junior engineers, and partner closely with cross-functional stakeholders to translate business needs into robust data solutions.

What does a DATA ENGINEER do?

• Build and optimize scalable ETL/ELT data pipelines using Azure Data Factory, Azure Data Lake, Synapse, and/or Snowflake.
• Develop and maintain SQL Server databases, stored procedures, views, and performance-tuned queries at large scale.
• Implement data quality checks, validation rules, reconciliation, and error-handling frameworks to ensure trusted data delivery.
• Troubleshoot production issues, perform root-cause analysis, and proactively monitor pipeline performance and reliability.
• Build ingestion frameworks for structured/unstructured data, including real-time streaming via Kafka/Event Hub (as needed).
• Partner with BI teams to deliver governed datasets and models that support Power BI reporting and self-service analytics.
• Follow CI/CD, change management, version control (Git), and release practices using Azure DevOps.
• Contribute to solution design, mentor junior engineers, and help drive best practices across data engineering standards.

What is required?

Education:

• Bachelor’s degree in Computer Science or a related field required.

Certifications:

• Azure/AWS certifications or data engineering certifications preferred.

Experience:    

• Minimum of 8 years of experience in data engineering, ETL development, or related roles.
• Advanced SQL skills and strong experience with Microsoft SQL Server at very large scale (up to petabyte-class environments).
• Hands-on experience with Azure Data Factory, Azure Data Lake, Synapse Analytics, and Databricks.
• Strong programming skills in Python or Scala for transformation and automation.
• Experience supporting production workloads, troubleshooting issues, and optimizing systems.
• Working knowledge of Power BI datasets and reporting fundamentals.
• Practical experience with CI/CD, version control, and DevOps workflows (Git, Azure DevOps, GitHub Actions), including pipelines from ingestion to reporting.
• Familiarity with data governance, security, and compliance practices.

Skills and Abilities:

• Real-time streaming experience with Kafka or Azure Event Hub.
• Infrastructure as Code experience (e.g., Terraform).
• Containerization experience (Docker/Kubernetes).
• Exposure to data science workflows or ML model integration.
• Experience with BI tools beyond Power BI (e.g., Tableau, Looker, Qlik).
• Strong analytical mindset and ability to troubleshoot complex data issues.
• Collaborative, adaptable, and comfortable working across cross-functional teams.
• Ownership mindset—delivers high-quality solutions with accountability
• Continuous learner—keeps up with cloud/data engineering best practices
• Strong communication skills—can explain technical concepts to non-technical audiences.

What else do you need to know?

• Hybrid.

• Excellent benefits package medical & dental, vision insurance, life insurance, short-term and long-term disability insurance.
• Parental Leave Policy.
• 401K + Company Match.
• PTO Plan + Paid Company determined Holidays.

**Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g. H-1B visa) for this opportunity**

All offers are contingent upon a successful background investigation (including employment, education, criminal and DMV verification- when applicable) and a pre-employment drug test with results satisfactory to GAINSCO.

GAINSCO is an Equal Employment Opportunity Employer

Provides non-standard personal auto insurance and claims services.