Location: Remote-MO
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.
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 Developer
Pay 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
Additional Locations: Remote-NE, Remote-KS, Remote-AZ, Remote-SD, Remote-ND, Remote-WA State, Remote-NV, Remote-MT, Remote-ID, Remote-NM, Remote-UT, Remote-OR, Remote-CO, Remote-TX, Remote-OK, Remote-CA
Job description provided by Centene.
View the original posting