Data Engineer III

Gainsco

United States

Hybrid

USD 120,000 - 160,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Excellent benefits package
401K + Company Match
Parental Leave Policy
PTO + Company holidays

Job summary

GAINSCO is seeking a Data Engineer III to design, build, and optimize scalable data pipelines powering analytics and reporting across the organization. You will lead complex engineering efforts, mentor junior staff, and partner with cross-functional teams to translate business needs into robust data solutions.

The role focuses on ETL/ELT development using Azure Data Factory, Snowflake, dbt, Airflow, and related tools, with a strong emphasis on data governance, security, and quality metrics.

Qualifications

  • Bachelor’s degree in Computer Science or a related field required.
  • Minimum 8 years of experience in data engineering, ETL development, or related roles.
  • Advanced SQL skills and experience with Microsoft SQL Server at large scale.
  • 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, and optimizing systems.
  • Working knowledge of Power BI datasets and reporting fundamentals.
  • CI/CD, version control, and DevOps workflows (Git, Azure DevOps, GitHub Actions).

Responsibilities

  • Build and optimize scalable ETL/ELT data pipelines using Azure Data Factory, Azure Data Lake, Synapse, and/or Snowflake.
  • Set up and manage Snowflake, dbt, Airflow, and related data stack technologies for reliability.
  • Implement data quality checks, validation rules, and error-handling frameworks.
  • Optimize Snowflake performance via sizing, profiling, clustering and caching, and monitors.
  • Troubleshoot production issues and monitor pipeline reliability.
  • Build data integration flows using Snowflake Openflow to ingest data from various sources.
  • Collaborate with BI teams to deliver governed datasets for Power BI reporting.
  • Apply data governance and security in Snowflake with Horizon and RBAC policies.
  • Follow CI/CD and release practices using Azure DevOps.
  • Mentor junior engineers and drive data engineering best practices across teams.

Skills

Advanced SQL
Python/Scala
ETL/ELT
Data pipelines design
Cloud data engineering
CI/CD

Education

Bachelor’s degree in Computer Science or related field

Tools

Snowflake
dbt
Airflow
Azure Data Factory
Azure Data Lake
Synapse Analytics
Databricks
Power BI

Job description

  • Hybrid
  • Information Technology
  • Full-Time
  • Requisition #: DATAE003333
Description
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).
  • 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

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer III
Data Engineer III

Gainsco • Richardson (TX)

Hybrid
USD 120,000 - 160,000
Excellent benefits package (medical, 

Parental Leave Policy
401K + Company Match
+2
Enterprise Data Architect
Enterprise Data Architect

Gainsco • Richardson (TX)

Hybrid
USD 140,000 - 220,000
Hybrid work schedule
Excellent benefits package
Parental Leave Policy
+2
Enterprise Data Architect
Enterprise Data Architect

Gainsco • Richardson (TX)

Hybrid
USD 140,000 - 190,000
Medical + dental + vision
Life insurance
Disability insurance
+3
Enterprise Data Architect
Enterprise Data Architect

Gainsco • Texas

Hybrid
USD 150,000 - 210,000
Hybrid work model
Excellent benefits package
401K + Company Match
+1
Senior Data Engineer: Scalable Pipelines & Snowflake Expert
Senior Data Engineer: Scalable Pipelines & Snowflake Expert

Gainsco • Richardson (TX)

Hybrid
USD 120,000 - 160,000
Excellent benefits package (medical, 

Parental Leave Policy
401K + Company Match
+2
Senior Platform Engineer
Senior Platform Engineer

Gainsco • Richardson (TX)

Hybrid
USD 140,000 - 180,000
Benefits package including medical,**d
Parental Leave Policy
401(k) with company match
+1
Data Engineer III
Data Engineer III

INSPYR Solutions • Florida

On-site
USD 140,000 - 154,000
Analytics Engineer
Analytics Engineer

G3 Enterprises • Modesto (CA)

On-site
USD 94,000 - 117,000
Sr. Data Engineer
Sr. Data Engineer

Sedgwick • Lansing (MI)

Remote
USD 120,000 - 160,000
Data Solutions Engineer - Hybrid / Durham, NC
Data Solutions Engineer - Hybrid / Durham, NC

Southern Company • Durham (NC)

Hybrid
USD 90,000 - 130,000
Medical Insurance
Dental Insurance
Vision Insurance
+2