Full Time / New York, New York
Data Warehouse Lead Developer/Analyst – Scientific Computing
Strength Through Diversity
Ground Breaking Science. Advancing Medicine. Healing Made Personal.
Role and Responsibilities:
The Data Warehouse Lead Developer/Analyst designs, tests, implements, maintains and controls the Mount Sinai Data Warehouse, with the overarching goal of accelerating translational research and improving clinical care.
The incumbent will develop data warehouses and data marts across multiple platforms and technologies (e.g. Oracle, PostgreSQL, MS SQL, and other columnar and search technologies) for Sinai-specific and NIH-funded national resources and projects. Designs, develops and manages these resources in a high performance computing and data warehousing environment, utilizing a thorough understanding of available technologies, tools, and best practices. Provides world-class support of researchers – fulfilling data requests in various forms (e.g. data feeds, data marts, reports, etc.). Operates as a technical team lead, providing mentorship, strategic technical solutions, recommendations, and guidance for other team members. Specific duties are listed as follows.
Designs, tests, implements, maintains and controls Mount Sinai’s research-oriented Data Warehouse, Data Marts, and other associated Research Databases for researchers and clinicians for grant funded projects. This includes major national and regional projects and data sharing initiatives such as the NIEHS-funded national Children’s Health Exposure Analysis Resource (CHEAR) and the data submissions and study support for the NYC-Clinical Data Research Network (CDRN).
Works closely with technical management and researcher-clients to design and implement databases and database support tools in support of complex business application development requirements and processes (e.g., diverse development platforms, technological environments, software, hardware, tools, etc.).
Provides technical mentorship and support to other Data Warehouse Developer/Analysts. Facilitates meetings to coordinate and prioritize work for the team.
Approaches all relationships with a world-class customer service approach. Maintains a customer-focused approach with users to provide solutions that are science/research-driven.
Supports, designs and manages upgrades to Sinai-developed software that interacts with these databases, such as the Cohort Query Tool.
Monitors transaction activities and assists in the utilization of databases. ETL maintenance and a full understand of the ETL processes is required. Provides guidance on ETL related activities to the ETL support team. Attends and leads ETL meetings.
Responsible for the integrity and security of data in Data Warehouses and Data Marts.
Work with other IT professionals through Mount Sinai effectively. Comply with the Institutional Review Board and HIPAA to follow all applicable policies and procedures.
Assists in the development of standards and procedures affecting database management, design and maintenance.
Establishes and maintains databases for user tests and production purposes.
Performance Tuning of SQL, ETL Jobs, and related scripts.
Trains user groups on procedures and standards.
Must have flexibility to learn and embrace a dynamic environment, which could include other database and pipeline technologies (e.g. PostgreSQL, MongoDB, SQL Server, various ETL tools, Kafka, cloud database services, etc.) and other coding/scripting languages.
May act as a project leader.
Performs related duties as assigned or requested.
Strength Through Diversity
The Mount Sinai Health System believes that diversity is a driver for excellence. We share a common devotion to delivering exceptional patient care. Yet we’re as diverse as the city we call home- culturally, ethically, in outlook and lifestyle. When you join us, you become a part of Mount Sinai’s unrivaled record of achievement, education and advancement as we revolutionize medicine together. We work hard to acquire and retain the best people, and to create a welcoming, nurturing work environment where you can develop professionally. We share the belief that all employees, regardless of job title or expertise, can make an impact on quality patient care. Explore more about this opportunity and how you can help us write a new chapter in our story!
Who We Are
Over 38,000 employees strong, the mission of the Mount Sinai Health System is to provide compassionate patient care with seamless coordination and to advance medicine through unrivaled education, research, and outreach in the many diverse communities we serve. Formed in September 2013, The Mount Sinai Health System combines the excellence of the Icahn School of Medicine at Mount Sinai with seven premier hospital campuses, including Mount Sinai Beth Israel, Mount Sinai Beth Israel Brooklyn, The Mount Sinai Hospital, Mount Sinai Queens, Mount Sinai West (formerly Mount Sinai Roosevelt), Mount Sinai St. Luke’s, and New York Eye and Ear Infirmary of Mount Sinai. The Mount Sinai Health System is an equal opportunity employer. We promote recognition and respect for individual and cultural differences, and we work to make our employees feel valued and appreciated, whatever their race, gender, background, or sexual orientation. EOE Minorities/Women/Disabled/Veterans