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. 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 and data visualizations, with Power BI experience required . T ableau 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.