Data Engineer III

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., * 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.

Do you have experience in Version control?, Do you have a Bachelor's degree?, * 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.

Pulled from the full job description

• Parental leave
• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Dental insurance
• Life insurance, * 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

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., 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.