Note: The job is a remote job and is open to candidates in USA. UnitedHealth Group, through its Optum business, delivers technology-enabled health solutions that help people live healthier lives. The Sr Data Engineer/Test Automation role focuses on creating and automating tests for ETL pipelines, validating data and schemas, and monitoring application performance across features and releases.
Responsibilities
- Create test scripts for ETL pipelines to verify source and target data matches in record count and content and metadata checks to verify schemas align
- Schedule /automate test scripts by adding data tests to CI/CD tools using GitHub Actions
- Develop suite of tests for features and releases to monitor speed and memory degradation as a result of changes
Skills
- 3+ years of experience programming skills in Databricks/Python to automate tests
- 3+ years of experience SQL skills for complex test scripting and data checks
- 3+ years of experience with ETL orchestration tools like Azure Data Factory, Airflow
- 3+ years of experience with standard data pipeline patters and comfortable reading ETL pipelines and determining which test to setup at each stage
- 3+ years of experience testing pipelines, cover for edge cases, investigate issues and logging issues
Benefits
- A comprehensive benefits package
- Incentive and recognition programs
- Equity stock purchase
- 401k contribution
- Remote work flexibility for employees working from anywhere within the U.S.
- For all hires in the Minneapolis or Washington, D.C. area, work in the office a minimum of four days per week
Company Overview