Data Intelligence 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 inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

Data Intelligence Analysts work with trading partner data directly. They implement new trading partner data files which arrive in various formats. In that process, they generate and document mapping of the data into Confluence – including relevant data crosswalks, particularly identifying the type of coverage each member in the file has which is crucial for downstream users of the trading partner data. Analysts troubleshoot reported issues with trading partner data from downstream users and developers. This role also creates carrier edits to create additional leads for carriers who are not formal trading partners. 

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

Primary Responsibilities:

• Implement new trading partner data files: perform initial evaluation and mapping of new trading partner data feeds
  • Analyze raw inbound trading partner test file(s) of various non-standard formats and create initial data mapping to ensure successful ingestion of new data feeds
  • Utilize ConnectCenter, Availity and other eligibility verification portals to validate random sample of member data and plan types from new trading partner file
  • Join calls/send emails as needed to address questions about new trading partner data as complete initial mapping process
  • Document the new trading partner’s Confluence page used by developers and ops showing how we map inbound raw data to our standardized format
  • Create data crosswalk tables in Confluence for critical data such as relationship codes and coverage plan types
• Troubleshoot issues reported with existing trading partner data files: analyze reported issues from development and/or downstream users of the trading partner data as escalated to this team           
  • Open card in MS Planner documenting the issue and track workflow as it evolves
  • Review inbound trading partner data and our crosswalk of that data to our standardized file using SQL
  • Compare inbound and standardized data to Confluence documentation to verify if the issue is due to raw data from the trading partner or if there is an issue in our mapping of the data to our standardized format
  • Use PowerBI, Power Query and/or other analytical tools as needed to determine scope of issue and drive deeper analysis as appropriate
  • Communicate questions and solutions to stakeholders to ensure correct understanding of the issue and resolution
  • If a change is needed by developers, open Aha Idea for escalation to IT
• Create Carrier Edits: analyze trading partner data for patterns we can use to create additional leads for non-trading partner payers
  • Use PowerBI, Power Query and/or other tools to analyze trading partner data searching for patterns in groups, employers, to identify likely coverage from non-trading partner payers
  • Utilize results from analysis of data patterns, verify member data in ConnectCenter, Availity and other portals to confirm coverage
  • Create Aha Idea to clone lead from existing trading partner data to a new lead and create a new lead based on criteria identified in analysis and verified through eligibility portals

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:

• 3+ years of electronic claim, remittance, or eligibility file experience
• 2+ years of SQL experience
• 2+ years of data mapping experience
• Proficient in Microsoft Office365 applications

Preferred Qualifications:

• 2 years utilizing PowerBI and/or Power Query
• Experience with AWS and Athena
• Proven excellent written and spoken interpersonal communication skills
• Proven ability to react quickly with purpose to advance objectives while maintaining professional tone and demeanor

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

Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer 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 us, you’ll find a far-reaching choice of benefits and incentives. The salary for this role will range from $71,200 to $127,200 annually based on full-time employment. We comply with all minimum wage laws as applicable.

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.