Business Intelligence Analyst II

Memorial Sloan Kettering Cancer Center; New York (NY); Hybrid; USD 139,000 - 188,000; Full time

Job summary

Memorial Sloan Kettering Cancer Center is seeking a Business Intelligence Analyst II to join the Analytics team, driving data‑driven insights for research and operations. You will design dashboards, implement reporting solutions, and partner with researchers and staff to translate questions into analytics.

The role emphasizes Power BI, SQL, and data visualization across large datasets, with opportunities to improve analytics infrastructure and governance while collaborating with data engineers.

Qualifications

• 4+ years in BI, analytics, or related data role.
• Advanced SQL skills with reporting solutions.
• Experience building dashboards with Power BI.
• Tableau experience is a plus.
• Experience with relational databases, data modeling, and data transformation.
• Familiarity with dbt and Cogito tools is preferred.

Responsibilities

• Partner with research, operational, and analytics stakeholders to translate complex needs into scalable analytical solutions.
• Design, develop, and maintain interactive dashboards, reports, and visualizations with a strong emphasis on Power BI.
• Leverage SQL to extract, analyze, validate, and transform data from multiple sources to support reporting and analytics initiatives.
• Develop meaningful metrics, KPIs, and reporting frameworks for data-driven decision-making.
• Analyze large and complex datasets to identify trends and opportunities that support research objectives.
• Collaborate with data engineering and analytics teams to ensure data quality and governance.
• Present analytical findings and recommendations to both technical and non-technical audiences.
• Support the enhancement of analytics infrastructure, reporting processes, and self-service analytics capabilities.
• Serve as a trusted analytics partner, proactively identifying opportunities to improve data accessibility, reporting effectiveness, and insight generation.

Skills

Critical thinking

Problem-solving

Communication

Stakeholder collaboration

Tools

Power BI

SQL

Tableau

dbt

Epic Cogito

Relational databases

Data modeling

Job description

About Us

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.

About Us

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.

Exciting Opportunity at MSK:

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, and maintain interactive 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 to identify trends, patterns, and opportunities that support research objectives.
• 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, proactively identifying opportunities to improve data accessibility, reporting effectiveness, and insight generation.

Key Qualifications

• 4+ years of experience in business intelligence, analytics, reporting, or a related data-focused role.
• Advanced SQL skills with demonstrated experience developing, optimizing, and maintaining analytical and reporting solutions.
• Strong hands‑on experience building dashboards, with Power BI experience required.
• Tableau experience is a plus but not required
• Experience working with relational databases, data modeling concepts, and data transformation processes.
• Experience with dbt (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 communication and 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.

Additional Information

• Schedule: Hybrid 3-4 x a month on site with flexibility as needed; 9:00 AM – 5:00 PM Monday – Friday
• Location: 885 Third Avenue, New York, NY
• Reporting To: Associate Director, Analytics

Helpful Links

• Compensation Philosophy
• Benefits

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.

MSK is an equal opportunity and affirmative action employer committed to diversity and inclusion in all aspects of recruiting and employment. All qualified individuals are encouraged to apply and will receive consideration without regard to race, color, gender, gender identity or expression, sexual orientation, national origin, age, religion, creed, disability, veteran status or any other factor which cannot lawfully be used as a basis for an employment decision.

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.