At Memorial Sloan Kettering (MSK), we're not only changing the way we treat cancer, but also the way the world thinks about it. By working together and pushing forward with innovation and discovery, we're driving excellence and improving outcomes.
For the 27th year, MSK has been named a top hospital for cancer by U.S. News & World Report. We are proud to be on Becker's Healthcare list as one of the 150 Great Places to Work in Healthcare in 2016, as well as Glassdoor's annual Employees' Choice Awards 2017. We're treating cancer, one patient at a time. Join us and make a difference every day.
MSK is seeking an Application Specialist to support the installation, analysis, design, development, testing, documentation and implementation of reporting solutions for the Reporting and Analytics department. This individual will work with senior managers to understand and analyze requirements and develop solutions using Business Intelligence and SQL Server tools and underlying technologies.
Work with business users to understand their business processes; gather and document requirements; translate requirements into functional specifications for dashboards and reports
Design and optimization of dimensional data models to support reporting infrastructure
Identify project risks and impediments; notify management; proactively work with other members of the team to complete assigned 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.
Configuration and upgrades of software and servers
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
Adept at planning and prioritizing work to meet commitments aligned with organizational
Adept at building partnerships and working collaboratively with others to meet shared objectives and goals
An effective communicator, capable of determining how best to reach different audiences and executing communications based on that understanding
Resilient in recovering from setbacks and skilled at finding detours around obstacles
Able to operate effectively, even when things are not clear or the way forward is not obvious
Adept at learning quickly, applying insights from past efforts to new situations
Bachelor's Degree in Computer Science, Health Administration or equivalent experience
2-4 years experience developing reporting solutions against relational and dimensional underlying data in a multi-platform environment
Strong proficiency in SQL and deep knowledge of relational database design principles
Experience with data visualization and analysis tools (Tableau, Splunk)
3+ years experience with relational database management systems and ETL processes
3+ years experience with Microsoft SQL Servers
2-4 years in the healthcare industry
Data governance experience a plus
Tableau experience a plus
Experience with DB2 a plus
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.
As one of the world's premier cancer centers, Memorial Sloan-Kettering Cancer Center is committed to exceptional patient care, leading-edge research, a...nd superb educational programs. The close collaboration between our physicians and scientists is one of our unique strengths, enabling us to provide patients with the best care available today as we work to discover more effective strategies to prevent, control, and ultimately cure cancer in the future. Our education programs train future physicians and scientists, and the knowledge and experience they gain at Memorial Sloan-Kettering has an impact on cancer treatment and the biomedical research agenda around the world.