Sarah Cannon Research Institute (SCRI) is one of the world’s leading oncology research organizations conducting community-based clinical trials. Focused on advancing therapies for patients over the last three decades, SCRI is a leader in drug development. In 2022, SCRI formed a joint venture with former US Oncology Research to expand clinical trial access across the country. It has conducted more than 850 first-in-human clinical trials since its inception and contributed to pivotal research that has led to the majority of new cancer therapies approved by the FDA in the past decade. SCRI’s research network brings together more than 1,300 physicians who are enrolling patients into clinical trials at more than 200 locations in 20+ states across the U.S.
Mid Business Intelligence Analyst
Location
United States
Posted
5 days ago
Salary
$93.3K - $155.5K / year
Seniority
Senior
Job Description
Mid Business Intelligence Analyst
McKesson
• Support Medically Integrated Dispensing (MID) programs across a portfolio of health system and provider-based specialty pharmacy clients • Analyze distribution data along with operational metrics to support internal performance monitoring • Identify trends in volume, reimbursement, utilization, and payer mix • Support root cause analysis to identify performance gaps and operational issues • Contribute to development and tracking of standard MID KPIs • Assist with trend analysis, performance tracking, and forecasting support • Contribute to reporting on program ramp and growth across the MID portfolio • Prepare inputs and insights for quarterly business reviews (QBRs) and client deliverables • Translate data into clear, actionable insights and summaries for client consumption • Develop and maintain tables, reports, dashboards in Power BI, SSRS, Tableau, Snowflake, Databricks, or similar tools
Job Requirements
- 4+ years of relevant experience
- 4+ years of experience analyzing prescription claims data
- Substantially proficient with PowerBI, SQL, Databricks, Snowflake
- 4+ years of experience in data analysis, reporting, or business intelligence in a healthcare related field
- Strong knowledge of pharmacy claims and dispensing data
- High proficiency in PowerBI, SQL, Snowflake, Tableau, and Databricks
- Extensive understanding and application of ETL processes
- Experience working with large, complex datasets
Benefits
- Competitive compensation package
- Annual bonus or long-term incentive opportunities
Related Guides
Related Categories
Related Job Pages
More Business Intelligence Developer Jobs
• Se busca un perfil tipo **Power BI Analyst** que pueda apoyar en la construcción de dashboards y análisis de información para requerimientos de Dirección de proyectos.
BI Developer II
Sound PhysiciansWe deliver uncompromising care and lasting partnerships across acute and post-acute settings.
• Independently design, build, and maintain advanced Power BI dashboards, reports, and semantic models to meet enterprise reporting needs • Translate complex business requirements into scalable, performant BI solutions that adhere to established governance, data modeling, and visual design standards • Develop and maintain advanced DAX calculations, incorporating time intelligence, conditional logic, and security filters to meet nuanced analytical needs • Optimize report and data model performance through indexing, query tuning, and best-practice modeling techniques • Implement and manage Row-Level Security (RLS) and other governance features to ensure secure, role-based data access • Collaborate with data engineers and governance teams to align BI assets with enterprise architecture, data quality standards, and compliance requirements • Mentor BI Developer 1 team members, providing technical guidance, code reviews, and skill development feedback • Document data models, report specifications, and development standards to ensure reusability, maintainability, and team alignment • Actively contribute to BI strategy by proposing new solutions, evaluating emerging tools, and championing continuous improvement in BI delivery processes
Data Analyst, PowerBI Engineer
ProArchConsulting and technology- enabled by cloud, guided by data, fueled by apps, and secured by design.
• Design, develop, and maintain interactive dashboards and reports using Power BI and Fabric workspaces • Conduct data analysis to identify trends, patterns, and insights that inform business strategies • Collaborate with cross-functional teams to gather requirements and deliver data-driven solutions • Ensure data accuracy and integrity by implementing quality control processes • Assist in presenting findings and recommendations to stakeholders through effective storytelling • Stay current with industry trends and best practices in data analytics and Power BI
• Set up and maintain a working development environment • Plan, manage, and report on all development activities using DevOps tools (pipelines, boards, user stories, artifacts) • Configure policies and permissions for users and groups within Microsoft platforms • Conduct agile ceremonies and follow best practices for iterative delivery • Create detailed functional and technical designs • Build and configure technical solutions, including data migration tasks • Develop source code, scripts, and deployment procedures for business processes • Package and deliver work items for development, testing, and acceptance environments • Perform unit testing and resolve defects promptly • Support UAT by writing test cases and ensuring quality deliverables • Deploy solutions into designated environments and maintain them post-release • Produce and maintain technical documentation for all initiatives • Ensure UI/UX consistency with organizational branding and design standards • Align data sets with established taxonomy and reporting structures • Enhance and create new reports using Power BI, ensuring consistency and accuracy • Provide strategic advice on Power BI platform structure, security, accessibility, and monitoring • Ensuring that all activities and duties are carried out in full compliance with regulatory requirements and supporting the continued implementation of the Group Anti-Bribery and Corruption Policy.




