Senior Cloud Data Warehouse Solution Lead - Telecommute

Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably. There's no room for error. Join us and start doing your life's best work.(sm)

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 Sr. Cloud Data Warehouse Solution Lead will be a key technical resource during the solution implementation of cloud-centric data management architecture. The primary role of the Solution Lead 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 Solution Lead 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 5+ 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 data management technologies in the industry

You’ll enjoy the flexibility to telecommute* 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
• As a solution lead, define technical product capabilities and features as well as prioritizing and directing the product engineering delivery as part of an agile team
• 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
• 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 etc.
• Automate pipeline processes using scheduling tools like AirFlow
• Ability to adapt, learn, work and deliver in a very high paced environment with limited information at times to support business needs
• 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:

• Bachelor’s Degree in Computer Science, Information Technology or related area
• 6+ years of experience designing, scaling, and/or implementing data warehouse and analytics solutions on prem and on cloud
• 5+ 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.
• 5+ years of experience working as part of data engineering teams through a product life cycle - requirements, design, development, testing and deployment
• 2+ years of experience in one or more programming languages such as Python/Scala/Java
• Proficiency in software delivery experience using Agile including CI/CD and DevOps with constituent applications such as Jira, Rally, Aha, GitHub, Selenium, etc.
• Demonstrated excellent understanding of Enterprise Data warehouse data models and dimensional modeling concepts, source to target mapping and Data pipeline architectures
• Demonstrated ability to lead small teams, meet tight deadlines, follow development standards and effectively raise critical issues with the client
• Demonstrated excellent oral and written communication skills
• Ability to travel 50% - 70% based on the business needs and permissible travel conditions
• Full COVID-19 vaccination is an essential job function of this role. Candidates located in states that mandate COVID-19 booster doses must also comply with those state requirements. UnitedHealth Group will adhere to all federal, state and local regulations as well as all client requirements and will obtain necessary proof of vaccination, and boosters when applicable, prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation

Preferred Qualifications:

• Cloud Data Engineering certification
• 5+ years of experience designing and implementing health insurance data and information management solutions and familiarity with provider data
• 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 in software delivery using Agile including CI/CD and DevOps with constituent applications such as Jira, Rally, Aha, GitHub, Selenium, etc.
• Knowledge of Healthcare Interoperability (FHIR, HL7) standards, EDI transactions and related formats including FHIR APIs
• Design and 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
• Working experience in building and automate AI/ML workstream from data analysis, experimentation, operationalization, model training, model tuning to Visualization
• Understanding of digital and data engineering architecture patterns such as containerization, microservices, streaming, event sourcing etc
• Working experience with Java and/or Kafka streaming architectures
• Working experience in containerization using Kubernetes, Dockers, OpenShift etc.
• Working knowledge of cloud data engineering technologies stack, architecture patterns and best practices
• Working experience in Big Data/Cloud eco system - ability to design, develop, document & architect Hadoop/Cloud applications
• Experience with Configuration Management using GitHub and/or other version control tools
• Experience with IaaS using Terraform, Helm deployments
• Experience in developing/deploying custom APIs

To protect the health and safety of our workforce, patients and communities we serve, UnitedHealth Group and its affiliate companies require all employees to disclose COVID-19 vaccination status prior to beginning employment. In addition, some roles and locations require full COVID-19 vaccination, including boosters, as an essential job function. UnitedHealth Group adheres to all federal, state and local COVID-19 vaccination regulations as well as all client COVID-19 vaccination requirements and will obtain the necessary information from candidates prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation. Failure to meet the vaccination requirement may result in rescission of an employment offer or termination of employment

Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)

*All Telecommuters will be required to adhere to UnitedHealth Group’s Telecommuter Policy.

Colorado, Connecticut or Nevada Residents Only: The salary/hourly range for Colorado residents is $97,300 to $176,900. The salary/hourly range for Connecticut/Nevada residents is $97,300 to $176,900. 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.

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.

Recommended Skills

• Api
• Adaptability
• Agile Methodology
• Analytical
• Apache Hadoop
• Apache Kafka