3 days ago
Remote, United StatesSenior
Base Salary
$87k - $161k/yr
Responsibilities
- Design, build, maintain, and support scalable ETL/ELT pipelines that ingest and transform data into Snowflake.
- Develop tested, documented DBT models, macros, tests, and version-controlled deployments.
- Build and support Informatica PowerCenter and/or IDMC integration workflows, mappings, and taskflows.
- Write, optimize, and tune complex SQL, including stored procedures, views, and analytical queries for large data volumes.
- Design dimensional, star/snowflake, and data vault models for reporting and analytics.
- Optimize Snowflake performance and cost through warehouse sizing, clustering, query tuning, and resource monitoring.
- Migrate and modernize legacy data platforms and ETL jobs to Snowflake, including code conversion, reconciliation, and parallel testing.
- Implement data quality checks, validation, reconciliation, and monitoring for data accuracy, completeness, and timeliness.
- 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.
- Apply data security, governance, and compliance standards when handling sensitive data such as PHI and PII.
- Collaborate with business and technical stakeholders to translate requirements into technical solutions.
- Conduct code reviews, mentor junior engineers, and contribute to engineering standards, documentation, and best practices.
Requirements
- Bachelor's degree in a quantitative or business field such as statistics, mathematics, engineering, or computer science, or equivalent experience.
- 4–6 years of related experience.
- 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 and cost optimization.
- Practical DBT experience building models, tests, and macros with Git and CI/CD.
- Strong knowledge of data warehousing, dimensional modeling, data integration patterns, and ETL/ELT design.
- Preferred certifications include SnowPro Core Certification and dbt Certified Developer.
- Must be authorized to work in the U.S. without current or future employment-based visa sponsorship.
Benefits
- Comprehensive benefits package including health insurance, 401K, stock purchase plans, tuition reimbursement, paid time off, and holidays.
- Flexible work arrangements including remote, hybrid, field, or office schedules.
- Full-time or part-time status may affect pay and benefits eligibility.
- Competitive pay and potential additional incentive compensation are available, subject to applicable factors and program eligibility.
About Centene
Centene is a publicly traded managed care company that delivers government-sponsored and commercial health insurance through local health plans across the U.S. It contracts with state and federal programs to administer Medicaid, Medicare, and Affordable Care Act Marketplace coverage, and provides related services such as pharmacy benefit management and behavioral health. Founded in 1984 and headquartered in St. Louis, Missouri, Centene trades on the NYSE under the symbol CNC.
