Principal Data Analyst – 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.

 

We are seeking a skilled and motivated Sr. Principal Data Analyst to join our team.  We need an Sr. Principal Data Analyst that will be responsible for delivery of Informatica components of a multi-terabyte Oracle Exadata environment that will contain public and private health care encounter and enrollment data from NYS healthcare plans.  Data will be synthesized, using Informatica, to support the management, evaluation, and analysis of the NYS health care system.  This project requires comprehensive knowledge of the Informatica product suite in that it includes not only PowerCenter, but also Master Data Management, Metadata Manager and Data Quality components of the solution.  This role requires detailed knowledge of healthcare claims processing and member data management.  

 

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

 

Primary Responsibilities:

• Create data mapping and workflow using Informatica PowerCenter to extract, transform and load data into the NY APD target reporting environment  
• Conform to Informatica workflow and mapping standards so development is consistent across all development resources (i.e., no hard coding, leverage of maplet, reuse concepts, etc.)
• Conduct ETL optimization, troubleshooting and debugging
• Design and develop test plans for ETL unit testing and integration testing
• Tune and optimize ETL jobs for performance and throughput. Interact with data modelers and DBAs on data architecture optimization for ETL performance
• Provide development support, including walk through approvals, to other ETL application resources to ensure that standards are followed, and optimized workflow is implemented
• Advocate and enforce secure coding principles, as defined by State of New York coding policies, to ensure compliance with all NY standards 
• Assist in documenting and maintaining operational procedures in the form of an operations manual for all ETL workflow
• Assist with troubleshooting efforts for ETL job issues related to pre-production and production
• Assist in designing and developing data validation processes using Informatica Data Quality.  

 

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:

• 4+ years of healthcare data experience across Medicaid, Medicare, Exchange or commercial payer environments
• 3+ years of experience with Informatica PowerCenter. Experience with 834, 837, NCPDP transactions
• Proven extensive knowledge and experience of healthcare claims, adjudication processing, and healthcare analysis
• Experience in code lifecycle management and repositories such as GIT & GitHub

 

Preferred Qualifications:

• Proven solid knowledge of HIPAA regulatory security requirements
• Experience in performing data loads to support Optum Symmetry product
• Oracle Exadata and experience with multi-terabyte data structures 
• Proven knowledge of Informatica Test Data Manager
• Experience with Informatica Data Quality
• Experience with Master Data Management
• Knowledge of healthcare member data management

 

*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, Washington, D.C. Residents Only: The salary range for this role is $104,700 to $190,400 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.