Senior Cloud Data Engineer

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.

Optum Advisory Services operates on the intersection of strategy, business operations, data and technology to help our clients realize exceptional business value. We harness data and technology and use them to reimagine business transformations to design and architect solutions that help realize exceptional value for our clients. We are uniquely positioned to accelerate the value proposition for our clients across the healthcare ecosystem with our unwavering focus on making health system work better for everyone.

The Senior Cloud Data Engineer will be a key technical resource during the solution implementation of cloud-centric data management architecture. The primary role of the cloud data engineer is to take the design and technical specifications and develop effective and high-quality technical solutions that meet the business requirements. The technical domain of the Cloud Data Engineer includes understanding Data Acquisition/Integration (DA/DI) best practices, tools and technologies, security in the environment, understanding of different data warehousing and dimensional modelling concepts, DI development, performance tuning and support system testing.

You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges.

Primary Responsibilities:

• Provide technical leadership in design and engineering for the modernization of legacy Data Ingestion, ETL/ELT and Database to new technologies in the Public Cloud (AWS/Azure), Big Data Space
• Self-driven, ownership mindset to navigate ambiguity, identify options to resolve constraints, mitigate implementation risks and define solutions to implementation challenges with minimal supervision.
• As part of the data management solution, implement appropriate data access and security patterns in alignment with appropriate regulatory and compliance standards such as HIPAA, PHI, PII, locational data restrictions, contractual, etc.
• Build partnership and rapport with client technical resources by demonstrating solid written and verbal communication, presentation, analytical and interpersonal skills
• Be able to work closely with Business Analysts and SMEs to understand business requirements
• Be able to work in a matrixed team environment with distributed responsibility across different teams
• Create Process Flows using diagraming tools like Visio and OmniGraffle
• Perform Data profiling and analysis of structured and unstructured data
• Define new interface layouts (custom or healthcare industry standards) for integrating into the Data warehouse
• Create source to target mappings and ETL/ELT pipeline design for integration of new/modified data streams into on-prem/cloud-based data warehouse/data marts
• Create & Validate ETL/ELT pipeline processes using technologies like Databricks, ADF, Informatica, Talend, SSIS, Spark, Python, Scala etc.
• Automate pipeline processes using scheduling tools like AirFlow
• Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions.
• Conduct ETL/ELT unit testing; participate in system and integration testing; identify and remedy solution defects.

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:

• 5+ years of experience in designing, scaling, and/or implementing data warehouse and analytics solutions on prem and on cloud
• 3+ years of experience with Data Warehousing concepts such as ETL, data quality management, data privacy & security, and MDM along with experience in technologies such as Snowflake, Databricks, ADF, Informatica, Data Stage, SSIS, Talend, Collibra, Hadoop, Cloudera, Graph Database, Map-Reduce etc.
• 3+ years of implementation experience with enterprise data and cloud initiatives such as cloud-native data warehouses, implementation of data management & analytics solutions on Snowflake, Azure, AWS, and/or Google Cloud.
• 3+ years of experience working as part of data engineering teams, including offshore teams, through a product life cycle - requirements, design, development, testing and deployment.
• 3+ years of software delivery experience using Agile including CI/CD and DevOps with constituent applications such as Jira, Rally, Aha, GitHub, Selenium, etc.
• 2+ years of experience in one or more programming languages such as Python/Scala/Java
• Based on the business needs and permissible travel conditions, willing or ability to 25-50% travel

Preferred Qualifications:

• Cloud Data Engineering certification
• 3+ years of experience designing and implementing healthcare data and information management solutions and familiarity with healthcare payer/provider data with respect to Membership, Enrollment, Claims (Medical, Pharmacy etc.) and Clinical data
• 3+ years of experience with digital and data engineering architecture patterns such as containerization, microservices, streaming, event sourcing etc.
• 3+ years of experience in Data Profiling & data analysis in a cloud DW environment in GCP, Azure and/or AWS
• 2+ years of experience with Java and/or Kafka streaming architectures
• 1+ years of experience with HL7 and EDI transactions and related formats including FHIR APIs

*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy

California, Colorado, Connecticut, Hawaii, Nevada, New Jersey, New York, Rhode Island, Washington, or Washington, D.C. Residents Only: The salary range for this role is $88,000 to $173,200 annually. Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. UnitedHealth Group complies with all minimum wage laws as applicable. In addition to your salary, UnitedHealth Group offers 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 UnitedHealth Group, you'll find a far-reaching choice of benefits and incentives.

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.

Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.