Optum ยท 3 days ago
Senior Business Data Analyst - Remote
United States
Full-time
Remote
Mid, Senior Level
$90K/yr - $161K/yr
4+ years expOptum is a global organization that delivers care aided by technology to help millions of people live healthier lives. They are seeking a Senior Business Data Analyst to define data requirements, conduct analysis, and collaborate with data engineers to enhance data processes, ultimately improving health outcomes.
EducationHealth CareMedicalPharmaceutical
Responsibilities
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
Qualification
Required
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 escalate 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
Preferred
Experience supporting data production processes that refresh on a regular cadence
Experience establishing database connections with query tools (e.g., Toad, Dbeaver, DBVisualizer, etc.)
Proven advanced SQL skills
Proven solid analytical skills to assess the impact of upstream database modifications on downstream data integrity, performance, and business processes
Demonstrated ability to proactively develop and recommend solutions to mitigate or resolve downstream effects to ensure continuity of business deliverables
Demonstrated ability to analyze and interpret relational data structures to identify dependencies and relationships between database tables and fields
All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy
Benefits
Comprehensive benefits package
Incentive and recognition programs
Equity stock purchase
401k contribution
Company
Optum
Optum is a healthcare company that provides pharmacy services, health care operations, and population health management. It is a sub-organization of UnitedHealth Group.
10001+ employees
H1B Sponsorship
Optum has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (648)
2024 (559)
2023 (620)
2022 (851)
2021 (593)
2020 (438)
Funding
Current Stage
Late StageLeadership Team
Daniel Castillo
Chief Executive Officer, Optum Care Delivery
J
Jay Green
Chief Financial Officer
Recent News
2025-11-29
2025-11-19
2025-11-07
Company data provided by crunchbase