Business Intelligence Analyst II

Pay Range: $120,200.00-$192,300.00 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 pursue our mission at 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 Description:

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

Closing:

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.