Senior Business Analyst - Remote

About the Role

Key Responsibilities

• Manage the full cycle of Medicaid provider enrollment data, including loading from text files into database tables, conducting comparison of state data to current Optum network enrollment, submitting providers for load or update as appropriate, monitoring the progress of the data through various system processes, and maintaining records of items processed in order to provide information on workload and data trends
• Understand the various data sources available and determine the best approach for combining data from multiple sources/platforms
• Take ownership of assigned network processes and manage most aspects independently with minimal direction
• Work with business partners to design and perform ad hoc and recurring reporting and analysis of provider data, and facilitate data loads and updates of provider data in response to requests from business partners
• Lead the design and implementation of continuous improvements to the provider data load and maintenance processes
• Perform routine analysis on provider data to identify and remediate errors and trends that could indicate larger system issues
• Participate as a SME in meetings with business partners to provide insight into provider data as well as departmental processes for its maintenance
• Present analysis and recommendations for operational and business review/planning
• Assist other team members with using available technology to simplify workflows and improve data accuracy

Requirements

• 3+ years of experience in business analysis
• Experience with data transfer between multiple formats (delimited/nondelimited flat files, Microsoft Excel, Microsoft Access, Microsoft SQL Server)
• Knowledge of relational databases and table structure
• Intermediate knowledge in Microsoft Access, Microsoft Teams, and Microsoft SQL Server
• Understanding data types and how to convert between systems during import/export processes
• Ability to identify matching data elements between multiple systems when the names/descriptions do not obviously indicate a match
• Experience developing user interfaces in Microsoft Access for multi-table data sources to review and update data, including basic error checks and usability features
• Developing code to handle full processes from data import to reporting with minimal manual intervention
• Writing moderately complex queries for data research and ad hoc reporting, including multi-table joins, matched/unmatched queries, and summary/grouping queries
• Developing automation processes using batch files and platform-specific automation capabilities
• Proven ability to research and learn independently without specific training or documentation
• Strong deductive reasoning and problem-solving abilities
• Ability to analyze for root cause and identify solutions and next steps

Nice to Have

• Experience using Microsoft Teams as a data sharing platform with Microsoft Access and/or Microsoft SQL Server
• Experience using Microsoft SharePoint as a data sharing platform with Microsoft Access and/or Microsoft SQL Server
• Knowledge of provider demographic data, especially related to Medicaid requirements (NPI/Medicaid ID/address alignment, eligibility dates, provider type and specialty)
• Knowledge of Optum systems (OHBS Facets, NDB, CSP Facets) and pricing configuration in each system

Qualifications

• Educational background is not explicitly specified, but 3+ years of business analysis experience is required

Benefits & Perks

• Comprehensive benefits package
• Incentive and recognition programs
• Equity stock purchase
• 401k contribution
• Salary range from $71,200 to $127,200 annually
• Remote work flexibility
• Adherence to UnitedHealth Group's Telecommuter Policy