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, and data 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.
Perform the full development cycle of a Data Warehouse including requirements gathering, design, implementation and maintenance.
You will enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges.
Primary Responsibilities
- Develop technical specifications and design documents
- Architect and design Data Warehouse infrastructure and solutions
- Develop code unit test and develop test strategies
- Test plans, test scenarios, and Test scripts
- Deploy and maintain Data Warehouses and Data Marts while performing tests; profile and analyze data by writing SQL statements
- Ensure quality processes throughout all phases of the Software Development Lifecycle
- Design and implement (Code) efficient and effective functional design solutions
- Coordinate with Business and Developers to ensure requirements are met
- Resolve business data and reporting issues within the team, across functional teams, and with business stakeholders
- Coordinate with Business during User Acceptance Testing (UAT) to assist business users in defining test cases and plans
- Participate in user group meetings to review use cases and review Test Results prior to UAT start
- Present written and verbal data analysis findings to the project team and business stakeholders
- Monitor operational activities associated with responsible domains including job, issue identification, documentation, analysis and resolution
- Develop tools to eliminate, reduce, streamline, and automate processes
You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear directions on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
Required Qualifications:
- High School Diploma/GED
- 3+ years of experience involving the following: Data Warehousing, or ETL Development and Testing
- 3+ years of experience with Scripting such as SQL, Unix (Shell Scripting), Perl, or Python
- 3+ years of experience with Databases such as Teradata or similar
- 3+ years of experience with Data Analysis, including Healthcare data analysis
- 3+ years of experience with Agile tools such as Rally or similar
Preferred Qualifications:
- Bachelors degree in Computer Science, Engineering, Computer Information Systems or a related field
- Cloud Services Azure/AWS/GCP and Cloud technology such as Databricks & Snowflake; and Scheduling Tools including Airflow or TWS
*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 $91,700 to $163,700 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
- High School Diploma or GED
- 3+ years of experience with data warehousing or ETL development and testing
- 3+ years of experience with scripting, such as SQL, Unix shell scripting, Perl, or Python
- 3+ years of experience with databases such as Teradata or similar
- 3+ years of experience with data analysis, including healthcare data analysis
- 3+ years of experience with Agile tools such as Rally or similar
- Bachelor's degree in Computer Science, Engineering, Computer Information Systems, or a related field
- Experience with cloud services Azure, AWS, or GCP
- Experience with Databricks and Snowflake
- Experience with scheduling tools such as Airflow or TWS
Optum Compensation & Benefits Highlights
-
Parental & Family Support — Paid parental leave (six weeks), paid caregiver leave (up to two weeks), Bright Horizons back-up care, and adoption assistance up to $10,000 are prominently included. Feedback suggests these family supports meaningfully aid work-life balance and are often highlighted as strengths.
-
Retirement Support — A 401(k) with company match is available to all employees, including part-time staff, alongside other financial protections like disability and life insurance. Feedback suggests broad access and matching make retirement support a core pillar of the package.
-
Equity Value & Accessibility — An Employee Stock Purchase Plan offers discounted company stock, with some roles also eligible for sign-on or performance bonuses. Feedback suggests the ESPP is a standout financial perk that helps employees build ownership over time.
Optum Insights
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.