Sobre este puesto de Senior Data Engineer en Centene
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 Developer
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