Business Intelligence Analyst II
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 pursue our mission at MSK and around the globe.
About the Role
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.
- 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.
Requirements
- 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 and data visualizations, 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.
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.
Schedule
Hybrid: 3-4 days a month on site with flexibility as needed; 9:00 AM – 5:00 PM Monday – Friday.
Location
885 Third Avenue, New York, NY
Pay
Pay Range: $125,400.00 - $200,700.00
Benefits
MSK is an equal opportunity and affirmative action employer committed to diversity and inclusion in all aspects of recruiting and employment. Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities.