Data Engineer II - Snowflake, Python

Centene Corporation

About The Position

You could be the one who changes everything for our 28 million members by using technology to improve health outcomes around the world. As a diversified, national organization, Centene's technology professionals have access to competitive benefits including a fresh perspective on workplace flexibility. Position Purpose: Develops and operationalizes data pipelines to make data available for consumption (reports and advanced analytics), including data ingestion, data transformation, data validation / quality, data pipeline optimization, and orchestration. Engages with the DevSecOps Engineer during continuous integration and continuous deployment. Designs and implements standardized data management procedures around data staging, data ingestion, data preparation, data provisioning, and data destruction (scripts, programs, automation, assisted by automation, etc.) Designs, develops, implements, tests, documents, and operates large-scale, high-volume, high-performance data structures for business intelligence analytics Designs, develops, and maintains scheduled processes supporting automated daily, weekly and monthly refreshes Ensure quality of technical solutions as data moves across Centene’s environments Provides insight into the changing data environment, data processing, data storage, and utilization requirements for the company and offers suggestions for solutions Develops, constructs, tests, and maintains architectures using programming language and tools Identifies ways to improve data reliability, efficiency, and quality; use data to discover tasks that can be automated Performs other duties as assigned Complies with all policies and standards

Requirements

A Bachelor's degree in a quantitative or business field (e.g., statistics, mathematics, engineering, computer science) and requires 2 – 4 years of related experience. Or equivalent experience acquired through accomplishments of applicable knowledge, duties, scope and skill reflective of the level of this position.
Experience with SQL and/or PL-SQL
Teradata or Snowflake desired including experience developing intermediate to large data pipelines in Snowflake
Hands on experience with Python or other languages
Experience with Power BI or other data visualization tools
Knowledge of CI/CD including automated deployments (Gitlab or other tools)
Familiarity diagnosing system issues, data validation and quality assurance testing
Implementation of common engineering best practices including documentation in project management tools such as JIRA
Seeks to learn new technology and stay up to date with trends in data analysis and data engineering
Ability to identify problems and procedural irregularities, collect data, establish facts, and draw conclusions
Ability to work independently

Responsibilities

Develops and operationalizes data pipelines to make data available for consumption (reports and advanced analytics), including data ingestion, data transformation, data validation / quality, data pipeline optimization, and orchestration.
Engages with the DevSecOps Engineer during continuous integration and continuous deployment.
Designs and implements standardized data management procedures around data staging, data ingestion, data preparation, data provisioning, and data destruction (scripts, programs, automation, assisted by automation, etc.)
Designs, develops, implements, tests, documents, and operates large-scale, high-volume, high-performance data structures for business intelligence analytics
Designs, develops, and maintains scheduled processes supporting automated daily, weekly and monthly refreshes
Ensure quality of technical solutions as data moves across Centene’s environments
Provides insight into the changing data environment, data processing, data storage, and utilization requirements for the company and offers suggestions for solutions
Develops, constructs, tests, and maintains architectures using programming language and tools
Identifies ways to improve data reliability, efficiency, and quality; use data to discover tasks that can be automated
Performs other duties as assigned
Complies with all policies and standards