Senior Cloud Data Engineer - Remote

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.

We are looking for a passionate professional preferably with more than 3+ years of experience in cloud implementations. This individual should be self-driven with an ownership mindset and self-motivated to continuously learn and invest in personal development as well as keep abreast of leading-edge cloud and data management technologies in the industry.

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 strong written and verbal communication, presentation, analytical and interpersonal skills

• Ability to work closely with Business Analysts and SMEs to understand business requirements

• Ability 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, Snowflake etc.

• Stored Procedure development using SQL/Teradata/Snowflake

• 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.

Years of post-high school education can be substituted/is equivalent to one year of experience.

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 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 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

• Proficiency in software delivery experience using Agile including CI/CD and DevOps with constituent applications such as Jira, Rally, Aha, GitHub, Selenium, etc.

• Excellent understanding of Enterprise Data warehouse data models and dimensional modelling concepts, source to target mapping and Data pipeline architectures

• Configuration Management using GitHub and/or other version control tools

• Experience in one or more programming languages such as Python/Scala/Java

• Demonstrated ability to meet tight deadlines, follow development standards and effectively raise critical issues with the client

• Demonstrated excellent oral and written communication skills

• Based on the business needs and permissible travel conditions, 50% - 70% travel could be expected

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

• Understanding of digital and data engineering architecture patterns such as containerization, microservices, streaming, event sourcing etc.

• Previous working experience with Java and/or Kafka streaming architectures

• Experience in Data Profiling & data analysis in a cloud DW environment in GCP, Azure and/or AWS

• Experience with IaaS using Terraform, Helm deployments.

• Experience in API design and development

• Knowledge of HL7 and EDI transactions and related formats including FHIR APIs

• Experience in containerization using Kubernetes, Dockers, OpenShift etc.

• Experience in Big Data/Cloud eco system - ability to design, develop, document & architect Hadoop/Cloud applications

• 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, or Washington Residents Only: The salary range for California/Colorado/Connecticut/Hawaii/Nevada/New Jersey/New York/Rhode Island/Washington residents is $88,000 to $173,200 annually. Pay is based on several factors including but not limited to education, work experience, certifications, etc. 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.

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.