Sr. Business Analyst

Cardinal Health is a leading healthcare services and products company, and they are seeking a Sr. Business Analyst. This role is crucial for supporting contracts, data validation, analytics, and performance insights, requiring advanced critical thinking and technical data analysis skills.

Responsibilities:

• Perform data entry and system maintenance associated with contracts within Averon’s internal custom applications and Microsoft Azure Data Platform
• Ensure daily data feeds are loaded and validated within Azure and Power BI
• Maintain Microsoft Azure Data Platform and Power BI dashboards
• Handle ad hoc data requests, advanced data analysis, and predictive modeling needs not covered by dashboards and other tools
• Document data sources, validation logic, and identification methodology
• Partner with Averon subject matter experts and stakeholders to identify root causes, develop solutions, and drive desired results
• Perform routine reconciliations of data feeds from manufacturers, parent organizations, and wholesalers, including analysis of data variances for contract alignment
• Analyze and troubleshoot reconciliation issues and recommend steps for resolution
• Align data from multiple sources into standardized, usable formats
• Conduct predictive analysis, scenario modeling, and trend forecasting to identify risks, opportunities, marketplace shifts, and potential future business impacts using historical and current data
• Provide insights into marketplace trends, including new biosimilar launches and product availability
• Design, create, and maintain Power BI dashboards and Excel files with appropriate quality control measures
• Support the effective use of dashboards and visualizations to clearly convey information to the target audience
• Synthesize complex information into clear, digestible insights
• Communicate findings and insights through presentations and reports, primarily in PowerPoint

Requirements:

• Advanced SQL skills, required
• Advanced Microsoft Office skills, including Excel, Power BI, Microsoft Teams, SharePoint, and related tools, required
• Ability to work with large, complex datasets and apply data modeling and statistical analysis techniques within business intelligence and data platform environments
• Proven ability to gather insights from multiple platforms and apply forecasting, predictive analysis, and data-driven recommendations to support business decisions
• Demonstrated ability to identify patterns, anomalies, and emerging trends, and translate findings into clear insights for leadership and cross-functional stakeholders
• Demonstrated ability to manage multiple workstreams
• Collaborative team player with clear written and verbal communication skills
• Strong attention to detail and a process-driven mindset
• Targeting individuals with a degree in analytics, business, data science, finance or a related field; or, 10+ years of relevant work experience aligned with the responsibilities of the role
• Proficiency with Azure SQL Databases and Azure Data Lake, highly preferred
• Proficiency with Salesforce, a plus