The Role
Validate ETL processes, verify source-to-target mappings, and test data transformations in the EDW. Use SQL, Python and AI tools to automate tests and ensure dashboard/report accuracy. Create test plans/cases, collaborate with data engineers and analysts, support defect resolution, and drive quality across data platforms and pipelines.
Summary Generated by Built In
Requisition Number: 2323913
Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together.
An EDW (Enterprise Data Warehouse) QA (Quality Assurance) professional is responsible for ensuring the accuracy, integrity, and quality of data within the data warehouse environment. With every role in the company, each position has a requirement for building quality into every output. The Technology Quality Function is reserved for those positions where Quality is the primary objective of the work delivered.
You will enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges
Primary Responsibilities:
You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
Required Qualifications:
Preferred Qualifications:
*All Telecommuters will be required to adhere to UnitedHealth Group's Telecommuter Policy.
Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $71,200 to $127,200 annually based on full-time employment. We comply with all minimum wage laws as applicable.
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.
At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location, and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups, and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.
UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.
UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.
#RPO #GREEN
Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together.
An EDW (Enterprise Data Warehouse) QA (Quality Assurance) professional is responsible for ensuring the accuracy, integrity, and quality of data within the data warehouse environment. With every role in the company, each position has a requirement for building quality into every output. The Technology Quality Function is reserved for those positions where Quality is the primary objective of the work delivered.
You will enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges
Primary Responsibilities:
- Validating ETL (Extract, Transform, Load)
- Processes using AI tools
- Verifying source-to-target data mappings
- Testing data transformations
- Leveraging AI CoPilot, Python ensuring that reports and dashboards reflect accurate business information
- Collaborate closely with data engineers, business analysts, and developers to identify data issues, create comprehensive test plans and test cases, and support defect resolution throughout the development lifecycle
- Technology Quality roles will cover all primary quality activity across all technological functions that ensure we deliver high quality products and services
- Strategy, planning, standards, process, policy, tools, engineering, assurance, management, metrics, research and development, automation, data preparation, maintenance, new development, operations and delivery
- Generally, work is self-directed and not prescribed
- Works with less structured, more complex issues
- Serves as a resource for others
- Leverage enterprise-approved AI tools to enhance productivity and innovation by streamlining workflows and automating repetitive tasks. Evaluate emerging trends to drive continuous improvement and strategic innovation
You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
Required Qualifications:
- Bachelor's degree in Computer Science, Information Systems, Engineering, or related field
- 3+ years of experience in QA/testing with a focus on data warehouse, ETL, or BI testing
- 3+ years of experience with SQL skills for data validation and test automation
- 3+ years of experience with QA tools like HP ALM, JIRA, ADO or any test management tool
- 3+ years of experience in writing test cases and executing manual, automated tests and experience with automated tests in data warehouse
Preferred Qualifications:
- Advanced Tools & Technologies:
Strong understanding of Bronze/Silver/Gold data architecture in modern data platforms (e.g., Databricks, Snowflake, Azure Synapse) - Experience with cloud data platforms (e.g., Snowflake)
- Familiarity with data visualization tools (e.g., Tableau, Power BI)
- Scripting experience in Python or Shell for test automation
- Experience in domains like Medicaid (Healthcare), Claims and Providers
- Exposure to AI/ML model validation or testing data pipelines that support machine learning workflows
- ISTQB or equivalent QA certification
- Familiarity with data warehouse concepts (star/snowflake schema, fact/dimension tables)
- Strong analytical and problem-solving skills
- Excellent communication and documentation abilities
- Strong understanding of data quality, data profiling, and reconciliation techniques
*All Telecommuters will be required to adhere to UnitedHealth Group's Telecommuter Policy.
Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $71,200 to $127,200 annually based on full-time employment. We comply with all minimum wage laws as applicable.
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.
At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location, and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups, and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.
UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.
UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.
#RPO #GREEN
Skills Required
- Bachelor's degree in Computer Science, Information Systems, Engineering, or related field
- 3+ years of QA/testing experience focused on data warehouse, ETL, or BI testing
- 3+ years of SQL experience for data validation and test automation
- 3+ years of experience with QA/test management tools (e.g., HP ALM, JIRA, ADO)
- 3+ years writing test cases and executing manual and automated tests for data warehouses
- Understanding Bronze/Silver/Gold data architecture and modern data platforms (Databricks, Snowflake, Azure Synapse)
- Experience with cloud data platforms (e.g., Snowflake)
- Familiarity with data visualization tools (Tableau, Power BI)
- Scripting experience in Python or Shell for test automation
- Experience in Medicaid, Claims, or Provider domains
- Exposure to AI/ML model validation or testing ML data pipelines
- ISTQB or equivalent QA certification
- Familiarity with data warehouse concepts (star/snowflake schema, fact/dimension tables)
- Strong understanding of data quality, data profiling, and reconciliation techniques
- Excellent communication and documentation abilities
Optum Compensation & Benefits Highlights
-
Leave & Time Off Breadth — PTO accrues each pay period with eight paid U.S. holidays plus a floating holiday, and generous time away is consistently emphasized. This breadth supports planned and unplanned time off beyond standard vacation days.
-
Parental & Family Support — Six weeks of paid parental leave, up to two weeks of paid caregiver leave, Bright Horizons back‑up care, and adoption assistance signal strong family-oriented support. EAP access with counseling sessions further extends help to employees and their households.
-
Wellbeing & Lifestyle Benefits — Company‑paid short‑ and long‑term disability, Calm app membership, tuition reimbursement, commuter and FSA accounts, and broad employee discounts expand everyday wellbeing resources. Free or low‑cost virtual visits complement these lifestyle supports.
Optum Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Optum, part of the UnitedHealth Group family of businesses, is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together. At Optum, we support your well-being with an understanding team, extensive benefits and rewarding opportunities. By joining us, you’ll have the resources to drive system transformation while we help you take care of your future. We recognize the power of connection to drive change, improve efficiency and make a difference in health care. Join a team where your skills and ideas can make an impact and where collaboration is key to creating technology that produces healthier outcomes.
Gallery
Optum Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
Optum has three workplace models that balance the needs of the business and the responsibilities of each role. These models, core on‑site (5 days/week), hybrid (4 days/week) and telecommute or fully remote, vary by country, role and location.
Typical time on-site:
Not Specified
