Business Data Analyst, Sr.

About The CompanyOptum is a global organization dedicated to delivering innovative healthcare solutions through the integration of advanced technology and compassionate care. Our mission is to help millions of people live healthier lives by connecting them with essential health services, pharmacy benefits, and resources that promote well-being. At Optum, we foster a culture that values inclusion, diversity, and continuous growth, supported by talented peers and comprehensive benefits. Our commitment extends beyond individual health, aiming to improve community health outcomes on a global scale. Join us to make a meaningful impact as we advance health optimization and create a healthier future for all.About The RoleWithin Optum Advisory, the Data & Research function plays a critical role in providing analytics capabilities that leverage expertise in data management, analysis, healthcare informatics, and financial assessment. The Data Analyst will be instrumental in translating complex business requirements into technical specifications, conducting detailed data profiling and analysis, and collaborating with data engineering teams to develop and maintain scalable ETL processes. This role involves working with large datasets related to health insurer eligibility, membership, and claims data, ensuring data integrity, quality, and reliability. The successful candidate will demonstrate strong technical aptitude, analytical skills, and the ability to communicate findings effectively to diverse audiences. Flexibility to work remotely from anywhere within the U.S. is a key benefit of this role, offering a dynamic environment to tackle challenging projects and contribute to healthcare improvements.Qualifications4+ years of hands-on experience analyzing health insurer's Medical Eligibility/Membership and Medical Claims data4+ years of Business Analyst experience, including requirement gathering and writing data functional specifications4+ years of experience with database technologies such as Oracle, SQL Server, DB2, Teradata, or SnowflakeProficiency in writing adhoc SQL queries against large data warehouses from multiple sourcesIntermediate or higher proficiency in SQL, including SELECT statements, filtering, joining tables, aggregating, and nestingExperience with Microsoft Excel, including pivot tables and functions like VLOOKUP, SUM, CONCATENATEStrong communication skills, both written and verbalAbility to work independently, conduct data profiling, and present findings clearlyExperience collaborating with data engineers, actuarial staff, and project managersDemonstrated ability to perform data and code reviews to ensure accuracy and reliabilityResponsibilitiesDefine, gather, and review data requirements for health insurer databases, including eligibility, membership, and claims dataPerform data profiling and analysis to assess source data quality and usability for business needsTranslate business requirements into detailed, actionable data specifications and documentationCollaborate with data engineers to develop, optimize, and update ETL processes for data extraction, transformation, and loadingDesign and execute quality assurance checks to validate data accuracy and process performanceMaintain comprehensive documentation such as functional specifications, data flow diagrams, and data dictionariesInvestigate root causes of data issues, recommend, and implement effective solutionsWork with data engineering teams to ensure the reliability and scalability of high-volume data processesDevelop insights and analyses to communicate changes or updates to production data processes to stakeholdersSupport continuous improvement initiatives to enhance data quality, process efficiency, and reporting capabilitiesBenefitsComprehensive health, dental, and vision insurance plansRetirement savings options including 401(k) contributionsIncentive and recognition programsEquity stock purchase opportunitiesFlexible remote work arrangementsCareer development and training resourcesPaid time off and holiday leaveEqual OpportunityUnitedHealth Group and Optum are committed to creating a diverse and inclusive workplace. We are an Equal Employment Opportunity employer and do not discriminate based on race, national origin, religion, gender, sexual orientation, gender identity, age, disability, veteran status, or any other protected characteristic.