Data Engineer II (Data Bricks expertise) - Memorial Sloan Kettering Cancer Center

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.  

Data Engineer II

Exciting Opportunity at MSK

We are seeking a Data Engineer II to join our Data Management team. In this role you will be shaping and maintaining the data infrastructure of our organization. Positioned as a mid-level professional, you will be tasked with making tactical decisions based on objectives set by higher-level management. You are responsible for developing and managing data pipelines that ensure the seamless flow of data from various sources into our state-of-the-art accessible and reliable repository systems. Your work will involve integrating, transforming, and preparing data for analysis, supporting the organization’s efforts to derive insights and drive decision-making.

Role Overview:

• Leverage clinical and data domain knowledge to build data extract, delivery, and transformation processes to meet user requirements.
• Build individual and integrated data domains and datamarts as needed with analytical data transformations to support Dashboards and other systems of insight
• Work with the latest tools to maintain data in our repositories
• Apply Agile practice/ DevSecOps and Design thinking principles
• Drive initiatives through analysis, design, test, and implementation phases. execute operational tasks, work on processes automation, troubleshoot, and devise solutions to user issues and enhancement requests.

Key Qualifications:

• 4-7 years demonstrated ability in data technical solutions.
• Working Experience of Agile practices using Rally.
• Understanding of data warehousing concepts and experience with data warehousing solutions (e.g., Snowflake, Redshift, BigQuery).
• Knowledge of cloud-based data services and platforms (e.g., AWS, Azure, Google Cloud) and experience with deploying and managing data solutions in the cloud.
• Proficient in SQL, PySpark, Databricks, DBT, Github, Airflow
• Excellent communication skills to work effectively with cross-functional teams and convey technical concepts to non-technical stakeholders.
• Proficient in using Office tools, including Outlook, Teams, Lucidchart, and other productivity software, to enhance communication, collaboration, and workflow efficiency.

Core Skills:

• Ability to troubleshoot and solve complex data issues.
• A team player, passionate about learning new technology/methodology.
• Able to work effectively in a fast-paced environment
• An effective communicator who possess team and customer-focused competency.
• Resilient in recovering from setbacks and skilled at finding detours around problems.

Additional Information:

• Location: 633 Third Avenue, NY
• Reporting to Director, Data Management
• Schedule: Hybrid, 4 days a month onsite

Pay Range: $118,800 - $196,200

Helpful Links:

• MSK Compensation Philosophy
• Review Our Greats Benefits Offerings

#LI-HYBR

#LI-POST

#ZIP

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.