Lead Data Engineer - Technology Specialist I - Digital and Technology Partners

Lead Data Engineer - Technology Specialist I - Digital and Technology Partners -  Remote - Req#3020902

Acts as the principal technology expert for major systems and their subsystems utilizing a thorough understanding of available technology, tools and existing designs.

The Enterprise Data Services team strives to advance an insight-driven culture across Mount Sinai Health System through the development of modern, user-friendly and timely data and analytics products and services. As a Lead Data Engineer, you will play a critical role in designing and developing robust ETL pipelines to integrate diverse data sources. This role requires expertise in creating efficient data pipelines and ensuring data integrity in Oracle and Azure data platforms. The lead will be responsible for developing standards to optimize and monitor ETL jobs for performance, efficiency, and stability; the lead will also mentor other data engineers on the team.  

The ideal candidate enjoys engaging with non-technical stakeholders to solve complex business needs; this lead role will be working with both on-shore and off-shore team members on a diversity of tasks and constantly learning new technologies. 
 

• Provides comprehensive consultation to business unit and IT management and staff at the highest technical level on all phases of the project development cycle. 
• Works closely with client management to identify and specify the complex business requirements and processes for diverse development platforms.  
• Performs analysis and system design.  May code new or modified programs, reuse existing code through the use of program development software alternatives and/or integrates purchased solutions. 
• Documents, tests, implements and provides on-going support for the applications. 
• Provides highly technical consulting and leadership in identifying and implementing new uses of information technologies that assist the functional business units in meeting their strategic objectives. 
• Acts as expert technical resource to development staff in all phases of the development and implementation process. 
• Performs related duties as assigned or requested.

• Bachelor degree in Computer Science or a related discipline, or an equivalent combination of education and work experience. Masters degree preferred.
• Eight years of diverse work experience in IT with a minimum of six years experience in systems analysis and application program development, or an equivalent combination of education and work experience.

Strongly preferred skills:

• Some management or lead experience. 
• In depth knowledge of the Azure cloud platform including Azure Data Factory and Databricks. Must also be comfortable working in Oracle. 
• Proficiency in programming languages (SQL and Python). 
• Knowledge of data warehousing data modeling and best practices as well as DevOps practices and tools (Git). 
• Experience with implementing data governance and security measures in a cloud environment. 
• Strong verbal and written communication skills with the ability to explain complex technical concepts to non-technical stakeholders.

General Skills & Competencies:

• Requires an In-depth knowledge of the system development life cycle, the client area's functions and systems, and data development and data applications program development.
• Must be competent to work at the highest technical level of all phases of system design and implementation.  
• Requires excellent communication skills, analytical ability, strong judgment and management skills, and the ability to work effectively with client and IT management and staff.

Non-Bargaining Unit, 223 - DTP Enterprise Data & Analytics - MSH, Mount Sinai Hospital