Business Intelligence Analyst II

Company overview
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.

Please review important announcements about vaccination requirements and our upcoming EHR implementation by clicking here .

Important Note for MSK Employees:

Your Career Hub profile is submitted to the hiring team as your internal resume. Please be sure your profile is fully complete with your skills, relevant experience and education (if required). Click here to learn more. Please note, this link is only accessible for MSK employees.


Job details
Exciting Opportunity at MSK

We are seeking a senior level Analyst to join the Business Insights team. This is an exciting opportunity to join our digital, informatics and technology organization and work on high-priority platforms supported by Health Informatics. Health Informatics focuses on the interaction of people, processes, and technology enabling MSK to meet critical patient care and research objectives. In particular, the Strategic Evaluation and Applied Research (SEAR) group within Health Informatics provides vision and direction for the creation of such data assets as data marts and Tableau reporting dashboards that support clinical and translational research at MSK and enable evaluations of key MSK strategic initiatives.

Role Overview:

• Create data analytic assets, for example, data marts and Tableau dashboards, to support predictive modeling, other research goals, an understanding of the efficiency and effectiveness of MSK's operational processes, and evaluations of MSK's strategic initiatives.
• Work with MSK business users to understand their business processes; gather and document requirements; translate requirements into functional specifications for dashboards and reports.
• Design and optimize multidimensional data models to support efficient reporting.
• Identify project risks and impediments; advise management; proactively work with other members of the team to complete tasks as defined by project scope and timelines.
• Assist in the development of data governance processes which entails documentation and implementation of data quality policies, procedures and standards to ensure a high level of data integrity.
• Create ad-hoc queries and reports.
• Develop test plans to assure the functionality and integrity of reporting solutions.
• Provide leadership and technical guidance to identify system deficiencies, analyze problems and solutions to conclude and implement corrective action.

Key Qualifications:

• 5+ years demonstrated ability developing reporting solutions against relational and dimensional underlying data in a multi-platform environment.
• Strong proficiency in SQL programming, deep knowledge of relational database design principles, and Tableau / data visualization & BI tools
• Experience with DB2, R & Python programming a plus
• Experience with Databricks and DBT a plus.
• Exposure to SAFe or agile methodologies a bonus

Core Skills:

• Capable of building strong customer relationships and delivering customer-centric solutions
• A good decision-maker, with proven success at making timely decisions that keep the organization moving forward.
• Able to work effectively in an environment notable for complex, sometimes contradictory information.
• Consistently achieving results, even under tough circumstances
• Ability to work independently and on a team

Additional Information:

• Location: 633 Third Avenue
• Reporting: Manager, Data & Analytics
• Schedule: Full Time Days, Hybrid - Onsite quarterly

Pay Range $120,200 - $192,300

Helpful links:

• MSK's Compensation Philosophy
• Review our great benefits offerings

#LI-POST

#LI-HYBRID

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.