Senior Data Engineer

Centene Corp.

South Dakota

Hybrid

USD 87,000 - 161,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health insurance
401K and stock purchase plans
Tuition reimbursement
Paid time off + holidays
Flexible work arrangements

Job summary

Centene Corp. is seeking a Senior Data Engineer to design, build, and support scalable data pipelines and models powering analytics and reporting.

The role focuses on Snowflake, DBT, Informatica, and SQL, with responsibilities spanning data integration, modeling, performance tuning, and data quality. You will mentor junior engineers, promote engineering standards, and help modernize our data platform while working across remote teams.

Qualifications

  • Expert-level knowledge with SQL (complex joins, window functions, CTEs, stored procedures, and query tuning on large data volumes).
  • Strong hands-on Snowflake experience (virtual warehouses, Snowpipe, streams and tasks, role-based access, performance and cost optimization).
  • Practical DBT experience building models, tests, and macros with Git and CI/CD.
  • Solid knowledge of data warehousing, dimensional modeling, and data integration patterns.
  • Strong ETL/ELT design skills
  • Preferred Certifications: SnowPro Core Certification, dbt Certified Developer

Responsibilities

  • Design, build, and maintain scalable ETL/ELT pipelines to ingest, transform, and deliver data into Snowflake.
  • Build and manage modular, tested, and well-documented data transformations using DBT, including models, macros, tests, and version-controlled deployments.
  • Develop, enhance, and support data integration workflows, mappings, and taskflows using Informatica (PowerCenter and/or IDMC).
  • Write, optimize, and tune complex SQL for large data volumes, including stored procedures, views, and analytical queries.
  • Design and implement data models (dimensional, star/snowflake schemas, and data vault where applicable) that support reporting and analytics needs.
  • Optimize Snowflake performance and cost through warehouse sizing, clustering, query tuning, and resource monitoring.
  • Support migration and modernization of legacy data platforms and ETL jobs to Snowflake, including code conversion, reconciliation, and parallel testing.
  • Implement data quality checks, validation, reconciliation, and monitoring to ensure accuracy, completeness, and timeliness of data.
  • Troubleshoot and resolve production issues, perform root cause analysis, and provide on-call or production support as needed.
  • Schedule and orchestrate data workflows using enterprise scheduling tools (e.g., Control-M) and follow CI/CD and release management practices.
  • Apply data security, governance, and compliance standards, including handling of PHI/PII.
  • Collaborate with business analysts, data architects, analytics teams, and product owners to translate requirements into technical solutions.
  • Conduct code reviews, mentor junior engineers, and contribute to engineering standards, documentation, and best practices.

Skills

SQL
Snowflake
DBT
Informatica
Data warehousing
ETL/ELT design
CI/CD
Git

Education

Bachelor's degree in a quantitative or business field

Tools

PowerCenter
IDMC
Git
CI/CD tools

Job description

Senior Data Engineer### Senior Data EngineerApply: Remote-MO: Remote-NE: Remote-KS: Remote-AZ: Remote-SD: Full time: Posted Yesterday: 1674266**Position Purpose:** The Senior Data Engineer designs, builds, and supports scalable, reliable, and secure data pipelines and data models that power analytics, reporting, and business decision-making. This role is a hands-on technical expert in Snowflake, DBT, Informatica, and SQL, and plays a key part in modernizing our data platform. The Senior Data Engineer partners with business and technical stakeholders, mentors junior engineers, and helps set engineering standards and best practices. **Key Details**: Must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Sponsorship and future sponsorship are not available for this opportunity, including employment-based visa types H-1B, L-1, O-1, H-1B1, F-1, J-1, OPT, or CPT * Design, develop, and maintain scalable ETL/ELT pipelines to ingest, transform, and deliver data from multiple source systems into Snowflake* Build and manage modular, tested, and well-documented data transformations using DBT, including models, macros, tests, and version-controlled deployments* Develop, enhance, and support data integration workflows, mappings, and taskflows using Informatica (PowerCenter and/or IDMC)* Write, optimize, and tune complex SQL for large data volumes, including stored procedures, views, and analytical queries* Design and implement data models (dimensional, star/snowflake schemas, and data vault where applicable) that support reporting and analytics needs* Optimize Snowflake performance and cost through warehouse sizing, clustering, query tuning, and resource monitoring* Support migration and modernization of legacy data platforms and ETL jobs to Snowflake, including code conversion, reconciliation, and parallel testing* Implement data quality checks, validation, reconciliation, and monitoring to ensure accuracy, completeness, and timeliness of data* Troubleshoot and resolve production issues, perform root cause analysis, and provide on-call or production support as needed* Schedule and orchestrate data workflows using enterprise scheduling tools (e.g., Control-M) and follow CI/CD and release management practices* Apply data security, governance, and compliance standards, including handling of sensitive data such as PHI/PII* Collaborate with business analysts, data architects, analytics teams, and product owners to translate requirements into technical solutions* Conduct code reviews, mentor junior engineers, and contribute to engineering standards, documentation, and best practices* Performs other duties as assigned* Complies with all policies and standards**Education/Experience:** A Bachelor's degree in a quantitative or business field (e.g., statistics, mathematics, engineering, computer science) and Requires 4 – 6 years of related experience. Or equivalent experience acquired through accomplishments of applicable knowledge, duties, scope and skill reflective of the level of this position. **Technical Skills:** * Expert-level knowledge with SQL (complex joins, window functions, CTEs, stored procedures, and query tuning on large data volumes)* Strong hands-on Snowflake experience (virtual warehouses, Snowpipe, streams and tasks, role-based access, performance and cost optimization)* Practical DBT experience building models, tests, and macros with Git and CI/CD* Solid knowledge of data warehousing, dimensional modeling, and data integration patterns* Strong ETL/ELT design skills **Preferred Certifications:*** SnowPro Core Certification* dbt Certified DeveloperPay Range: $87,000.00 - $161,300.00 per year **At Centene, we connect people to the care they need to live healthier lives — and the work you do here makes that impact real every day.** You’ll take on meaningful challenges that directly support individuals, families, and communities, building your skills while making healthcare more accessible and effective. It’s work with a purpose you can see, backed by a team committed to improving lives well beyond the workday.Centene offers a comprehensive benefits package including: competitive pay, health insurance, 401K and stock purchase plans, tuition reimbursement, paid time off plus holidays, and a flexible approach to work with remote, hybrid, field or office work schedules. Actual pay will be adjusted based on an individual's skills, experience, education, and other job-related factors permitted by law, including full-time or part-time status. Total compensation may also include additional forms of incentives. Benefits may be subject to program eligibility.Centene is an equal opportunity employer that is committed to diversity, and values the ways in which we are different. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other characteristic protected by applicable law.Qualified applicants with arrest or conviction records will be considered in accordance with the LA County Ordinance and the California Fair Chance Act
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

Centene Corp. • Missouri

Hybrid
USD 87,000 - 161,000
Competitive pay
Health insurance
401K and stock purchase plans
+3
Financial Data Analyst III
Financial Data Analyst III

Centene Corp. • Florida

Hybrid
USD 70,000 - 126,000
Health insurance
401K
Stock purchase plan
+3
Senior Data Engineer - Snowflake & DBT Expert (Remote)
Senior Data Engineer - Snowflake & DBT Expert (Remote)

Centene Corp. • Missouri

Hybrid
USD 87,000 - 161,000
Competitive pay
Health insurance
401K and stock purchase plans
+3
Business Technical Analyst
Business Technical Analyst

Oklahoma Complete Health • South Dakota

Hybrid
USD 70,000 - 126,000
Health insurance
401K plans
Stock purchase plans
+1
Senior Data Engineer - Remote | Snowflake & DBT Expert
Senior Data Engineer - Remote | Snowflake & DBT Expert

Centene Corp. • South Dakota

Hybrid
USD 87,000 - 161,000
Health insurance
401K and stock purchase plans
Tuition reimbursement
+2
Financial Data Analyst III
Financial Data Analyst III

Oklahoma Complete Health • Indiana

Hybrid
USD 70,000 - 126,000
Manager, Business Insights
Manager, Business Insights

Centene Corp. • South Dakota

Hybrid
USD 88,000 - 158,000
Senior Snowflake Engineer
Senior Snowflake Engineer

Jobgether • United States

Remote
USD 150,000 - 210,000
Remote work within US
3-month contract
Cloud Data Engineer - Snowflake
Cloud Data Engineer - Snowflake

Edward Elmhurst Health • Skokie (IL)

Hybrid
USD 59,000 - 91,000
Tuition Reimbursement
Medical, Dental & Vision options
Paid Time Off and Holidays
+2
Senior Data Engineer
Senior Data Engineer

TSG Resources, Inc. • Louisiana

On-site
USD 87,000 - 128,000
Medical insurance
Dental insurance
Vision insurance
+1