Senior Business 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 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.

Within UHG Trend Analytics, the Data & Research function provides capabilities for Analytics that capitalizes on expertise in data, analysis, advanced methodologies, quality management, healthcare informatics, financial analysis, and custom data integration. A successful candidate will be highly motivated/curious, analytical, and detail-oriented, possess solid technical aptitude with databases, demonstrate the ability to interpret and summarize complex findings, and communicate effectively across diverse and large audiences.

You’ll enjoy the flexibility to work remotely
* from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week.

• Define, gather, and review data requirements for health insurer's Eligibility/Membership and Claims databases (e.g., Medical, Pharmacy claims)
• Conduct data profiling and analysis to determine how source data can fulfill business and technical requirements
• Translate business needs into clear, actionable data functional specifications
• Collaborate with data engineers to create new repeatable data ETL processes and/ or update existing repeatable data ETL processes
• Design and perform QA checks ensuring development efforts align with expectations
• Author and maintain comprehensive documentation such as functional specifications, test plans, data flow diagrams, project plans, and data dictionaries
• Research and investigate root causes of data issues and recommend effective solutions
• Work with data engineering team to manage complex, high-volume production data processes with a focus on reliability and scalability
• Develop analyses and insights to assess and communicate code changes/updates to production processes to internal and external stakeholders

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.

• 4+ years of hands‑on data analysis of health insurer's Medical Eligibility/Membership and Medical Claims data
• 4+ years Business Analyst experience, gathering requirements and writing data functional specifications
• 4+ years of hands‑on experience with database technologies such as Oracle, SQL Server, DB2, Teradata, Snowflake
• 4+ years hands‑on experience writing adhoc SQL against a data warehouse that contains large volumes of data from a variety of different sources
• Intermediate+ hands‑on experience writing SQL statements using the following commands in a relational database (e.g., select statements with filtering, linking multiple tables, aggregating, sorting, nesting, etc.)
• Intermediate+ experience with Microsoft Excel, including experience creating pivot tables and writing functions (e.g., SUM, VLOOKUP, CONCATENATE, etc.)
• Demonstrated awareness of when to appropriately elevate issues/risks
• Demonstrated ability to work independently to conduct data profiling and analysis and then summarize and present findings to others
• Demonstrated ability to collaborate with data engineers, actuarial staff, project leads and manager for data‑driven deliverables
• Demonstrated ability in conducting in‑depth code and data reviews to validate the accuracy and reliability of output
• Demonstrated excellent communication skills, both written and verbal

• Experience supporting data production processes that refresh on a regular cadence
• Experience…