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 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.
Primary Responsibilities:
- Developing Data Pipelines: Creating and maintaining optimal data pipeline architectures to ensure efficient data flow and processing
- Data Integration: Assembling large, complex data sets from various sources to meet business requirements Process
- Improvement: Identifying and implementing internal process improvements, such as automating manual processes and optimizing data delivery
- Infrastructure Building: Designing and building the infrastructure required for data extraction, transformation, and loading (ETL) using technologies like SQL and AWS
- Collaboration: Working with stakeholders, including data scientists, analysts, and executives, to support their data infrastructure needs and resolve data-related technical issues
- Data Quality: Running tests to isolate errors and updating systems to accommodate changes in company needs
- Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so
Required Qualifications:
- Experience with DBT Core
- Health care domain knowledge
- Programming Languages: Familiarity with languages like Python or Java for data analysis and application development
- Data Modeling: Proficiency in creating logical and physical data models to represent business requirements and system architecture
- Data Warehousing: Understanding of data warehousing concepts, including data storage, retrieval, and optimization
- Data Security: Knowledge of data security best practices, encryption, and access controls
- ETL (Extract-Transform-Load): Expertise in ETL processes and tools like DBT (Data Build Tool) and DBT framework/packages
- Database Management Systems (DBMS): Proficiency in relational databases (e.g., Microsoft SQL Server) and NoSQL databases
- Cloud Computing: Understanding of cloud platforms (e.g., Azure, AWS, GCP) and their data services
- Delta Lake: Familiarity with Delta Lake, an open-table format that combines data lake flexibility with ACID transactions
- Medallion Architecture: Knowledge of the medallion architecture, which organizes data layers (Bronze, Silver, Gold) in a lakehouse
- Data Vault: Understanding of the Data Vault methodology for scalable and flexible data warehousing
- Azure Data Factory (ADF): Proficiency in using ADF for orchestrating data workflows, data movement, and transformation
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.
Skills Required
- Experience with DBT Core
- Health care domain knowledge
- Familiarity with programming languages like Python or Java
- Proficiency in data modeling
- Understanding of data warehousing concepts
- Knowledge of data security best practices
- Expertise in ETL processes and DBT tools
- Proficiency in relational and NoSQL databases
- Understanding of cloud platforms such as Azure, AWS, GCP
- Familiarity with Delta Lake
- Knowledge of medallion architecture
- Understanding of Data Vault methodology
- Proficiency in Azure Data Factory
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.