
Data Engineer III
GAINSCO Auto Insurance® · Richardson, TX, United States · Hybrid
- Insurance
- 501–1,000 employees
- Richardson, Texas
- First seen
- 18 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
In its favour
- Posted today
- Still listed on the employer's own board
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 III do?
- Build and optimize scalable ETL/ELT data pipelines using Azure Data Factory, Azure Data Lake, Synapse, and/or Snowflake.
- Set up, manage, maintain, and troubleshoot Snowflake, dbt, Airflow, and other modern data stack technologies to keep pipelines reliable and performant.
- Implement data quality checks, validation rules, reconciliation, and error-handling frameworks to ensure trusted data delivery.
- Optimize Snowflake performance and cost through warehouse sizing, query profiling, clustering and caching strategies, and resource monitors.
- Troubleshoot production issues, perform root-cause analysis, and proactively monitor pipeline performance and reliability.
- Build and manage data integration flows using Snowflake Openflow to ingest data from databases, SaaS applications, files, and streaming sources into Snowflake.
- 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.
- Apply data governance and security in Snowflake using Snowflake Horizon, including role-based access control, masking and row access policies, object tagging, data classification, lineage, and data quality monitoring.
- 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
- Snowflake, dbt 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 Snowflake, dbt, airflow, 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
Skills
- ETL
- ELT
- Azure Data Factory
- Azure
- Synapse
- Snowflake
- dbt
- Airflow
- Kafka
- Power BI
- Git
- Azure DevOps
- AWS
- SQL
- SQL Server
- Databricks
- Python
- Scala
- GitHub Actions
- Terraform
- Docker
- Kubernetes
- Machine Learning
- Tableau
- Looker
More jobs at GAINSCO Auto Insurance®
Similar roles
- Laser Field Service TechnicianMC Machinery Systems · Philadelphia, PA, United States · USD 25–30/hrtoday
- Technical Support EngineerSightline Applications · Portland, OR, United States · Hood River, OR, United States · USD 95,000–105,000/yrtoday
- Telecom Data Network EngineerPrimary Talent Partners · St. Petersburg, FL · USD 54–59/hrtoday
- Wire EDM Field Service TechnicianMC Machinery Systems · Indianapolis, IN, United States · USD 25–28/hrtoday