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 is currently seeking a hands-on Principal Health Data Architect to support our NY All Payer Database program within the Enterprise Datawarehouse and Analytics group. The Data Architect will work with large healthcare datasets and will translate client's business requirements into enterprise systems, applications, or process designs for large complex health data solutions. The role will drive and support initiatives for the NY APD program as well as participate in the wider EDW group’s areas of data usage and governance, information management, privacy and security, SOA, data analytics and visualization and information modeling.This individual will be part of a dynamic team that builds and implements Data Analytic solutions serving government clients that house data from public and private insurance payers, including insurance carriers, health plans, third-party administrators, and pharmacy benefit managers, as well as Medicaid and Medicare. These solutions are creating new capability within the state departments, including more advanced and comprehensive analytics to support decision making, policy development, and research, while enhancing data security by protecting patient privacy through encryption and de-identification of potentially identifying information. Providing a comprehensive picture of the health care being provided to residents by supporting consumer transparency needs on quality, safety, and costs of care. The systematic integration of data technology and weaving of previously fragmented sources of data creates a key resource to support data analyses that address health care trends, needs, improvements, and opportunities. A key for success in this role is a unique blend of technical skills, business knowledge and working with and influencing multiple cross functional teams within IT and business on the right solutions.You’ll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges.Primary Responsibilities:Strategy & Planning
Develop and deliver long-term strategic goals for data architecture vision and standards in conjunction with data users, department managers, clients, and other key stakeholders
Lead data architecture, data modelling, and data movement initiatives to enhance the architecture of a large data warehouse which supports analytics for the Medicaid ,
Medicare including domains such as claims, Issuer/Plan, and member information subject areas
Create short-term tactical solutions to achieve long-term objectives and an overall data management roadmap
Create end-to-end vision on how logical design translates into one or more physical databases, and how the data will flow through the successive stages
Establish methods and procedures for tracking data quality, completeness, redundancy, compliance and improvement
Assess and determine governance, stewardship, and frameworks for managing data across the enterprise
Create strategies and plans for data capacity planning, data security, life cycle data management, scalability, backup, disaster recovery, business continuity, and archiving
Ensure that data strategies and architectures are in regulatory compliance. Recognize and identify potential areas where existing policies and procedures require change, or where new ones are needed
Project Related Deliverables and Tasks
Select and implement the appropriate tools, software, applications, and systems to support data technology goals
Oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality
Collaborate with project leads and consultants and business unit leaders for all projects involving enterprise data and analytics
Create and maintain data model and metadata policies and procedures for functional design
Provide technical recommendations and engage with ETL/BI Architects, Business SMEs and other stakeholders throughout the Solution/Data Architecture and implementation lifecycle and recommend effective solutions to develop high performance and highly scalable data solutions (data marts/warehouse and data mining and advanced analytics)
Address data-related problems in regard to systems integration, compatibility, and multiple-platform integration
Develop and implement key components as needed to create testing criteria in order to guarantee the fidelity and performance of data architecture
Document the project and programs data architecture and environment in order to maintain a current and accurate view of the larger data picture, an environment that supports a single version of the truth and is scalable to support future analytical needs
Identify and develop opportunities for data reuse, migration, or retirement and platform upgrades
Communicate with customer, project team in a timely manner and escalates issues & risks appropriately
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:
10 + years of progressive data analytics experience
Hands-on experience with related/complementary open source software platforms and languages (e.g. Java, Linux, Apache, Perl/Python/PHP, Chef)
Hands-on experience with ETL (Extract-Transform-Load) tools (e.g. Informatica, Talend))
Hands-on experience with BI tools and reporting software
Hands-on experience with analytical tools, languages, or libraries
Experience with high-scale or distributed RDBMS (Teradata, Exadata)
Demonstrated experience with problem solving, influencing, communication, and presentation skills, self-starter
Extensive knowledge of regulatory security requirements regarding HIPPA and other regulatory security requirements.
Extensive knowledge of healthcare transaction sets 834 , 837
Healthcare domain knowledge of Medicaid, Medicare and Commercial data sets
Expertise in Data Architecture, Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client
Proven expertise with normalized OLTP, MDM and DW Dimensional modeling techniques, Oracle & Snowflake schemas, modeling slowly changing dimensions and role playing dimensions, dimensional hierarchies, and data classification
Proven expertise in Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival and Data Migration strategies using appropriate tools
Proven drive delivery in a matrixed environment working with various internal IT partners
Demonstrated ability to work in a fast paced and changing environment with short deadlines, interruptions, and multiple tasks/projects occurring simultaneously
Proven ability to work independently and have skills in planning, strategy, estimation, scheduling
Preferred Qualifications:
Knowledge of cloud computing infrastructure (e.g. Amazon Web Services EC2, Elastic MapReduce) and considerations for scalable, distributed systems
Knowledge of NoSQL platforms (e.g. key-value stores, graph databases, RDF triple stores)
All employees working remotely will be required to adhere to UnitedHealth Group’s Telecommuter PolicyCalifornia, Colorado, Connecticut, Hawaii, Maryland, Nevada, New Jersey, New York, Rhode Island, Washington, Washington, D.C. Residents Only: The salary range for this role is $122,100 to $234,700 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.