Business Intelligence Analyst II

Memorial Sloan Kettering Cancer Center (MSK) is a world-renowned leader in cancer care, research, and education, driven by a mission to end cancer for life. The Business Intelligence Analyst II will join the Analytics team and serve as a key partner in advancing research analytics through data-driven insights.

This role is ideal for a highly analytical professional who thrives in navigating ambiguity, translating complex business questions into actionable solutions, and delivering impactful reporting and visualization tools that support strategic decision-making across research and operational stakeholders.

Role Overview

• Partner with research, operational, and analytics stakeholders to understand business needs and translate complex, ambiguous requests into scalable analytical solutions.

• Design, develop, andmaintaininteractive dashboards, reports, and visualizations with a strong emphasis on Power BI.

• Leverage SQL extensively to extract, analyze,validate, and transform data from multiple sources to support reporting and analytics initiatives.

• Develop meaningful metrics, key performance indicators, and reporting frameworks that enable data-driven decision-making.

• Analyze large and complex datasets toidentifytrends, patterns, and opportunities that support researchobjectives.

• Collaborate with data engineering and analytics teams to ensure data quality, consistency, and adherence to governance standards.

• Present analytical findings and recommendations to both technical and non-technical audiences in a clear and actionable manner.

• Support the enhancement of analytics infrastructure, reporting processes, and self-service analytics capabilities.

• Serve as a trusted analytics partner, proactivelyidentifyingopportunities to improve data accessibility, reporting effectiveness, and insight generation.

• 4+ years of experience in business intelligence, analytics, reporting, ora relateddata-focused role.

• Advanced SQL skills withdemonstratedexperience developing,optimizing, andmaintaininganalytical and reporting solutions.

• Strong hands-on experience building dashboards and data visualizations, with Power BI experiencerequired.

• Tableau experience is a plus but notrequired

• Experience working with relational databases, data modeling concepts, and data transformation processes.

• Experience withdbt(data build tool) is highly preferred.

• Exposure to Epic Cogito tools and the broader Cogito reporting suite is a plus.

Core Skills

• Exceptional critical thinking and problem-solving abilities.

• Ability to take vague or loosely defined requests and convert them into clear, actionable analytical deliverables.

• Strong communicationand relationship-building skills with diverse stakeholder groups.

• High attention to detail and commitment to data quality, accuracy, and integrity.

• Intellectual curiosity, initiative, and a continuous improvement mindset.

Pay Range: $125,400.00 - $200,700.00

FSLA Status: Exempt

Closing:

At MSK, we believe in fair, competitive pay that reflects your job, experience, and skills.

The people of Memorial Sloan Kettering Cancer Center (MSK) are united by a singular mission: ending cancer for life. Our specialized care teams provide personalized, compassionate, expert care to patients of all ages. Informed by basic research done at our Sloan Kettering Institute, scientists across MSK collaborate to conduct innovative translational and clinical research that is driving a revolution in our understanding of cancer as a disease and improving the ability to prevent, diagnose, and treat it. MSK is dedicated to training the next generation of scientists and clinicians, who go on to pursueour missionat MSK and around the globe.