Senior Data Engineer

Posted 4hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Senior Data Engineer modernizing Centene’s healthcare data platform through Snowflake, DBT, Informatica, and SQL. Building secure pipelines, models, and analytics infrastructure.

Responsibilities:

  • Design, develop, and maintain scalable ETL/ELT pipelines into Snowflake
  • Build and manage modular, tested, documented DBT transformations, including models, macros, tests, and version-controlled deployments
  • Develop, enhance, and support Informatica PowerCenter and/or IDMC workflows, mappings, and taskflows
  • Write, optimize, and tune complex SQL, including stored procedures, views, and analytical queries
  • Design and implement dimensional, star/snowflake, and data vault models
  • 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
  • Implement data quality checks, validation, reconciliation, and monitoring
  • Troubleshoot production issues, perform root cause analysis, and provide on-call or production support as needed
  • Schedule and orchestrate workflows using enterprise scheduling tools such as Control-M and follow CI/CD and release management practices
  • Apply data security, governance, and compliance standards for sensitive PHI/PII data
  • 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
  • Perform other duties as assigned and comply with all policies and standards

Requirements:

  • Must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future
  • Bachelor's degree in a quantitative or business field (e.g., statistics, mathematics, engineering, computer science)
  • 4–6 years of related experience, or equivalent experience acquired through applicable knowledge, duties, scope and skill
  • Expert-level SQL knowledge, including complex joins, window functions, CTEs, stored procedures, and query tuning on large data volumes
  • Strong hands-on Snowflake experience, including virtual warehouses, Snowpipe, streams and tasks, role-based access, and performance/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
  • SnowPro Core Certification preferred
  • dbt Certified Developer preferred

Benefits:

  • Health insurance
  • 401K
  • Stock purchase plans
  • Tuition reimbursement
  • Paid time off plus holidays
  • Flexible approach to work with remote, hybrid, field or office work schedules
  • Additional forms of incentives may be included in total compensation