Data Engineer II - Digital and Technology Partners - Hybrid/Remote

This is a remote/hybrid position, may require onsite for interviews and occasionally onsite as needed

Location: 150 E 42nd Street, New York, NY

The Data Engineer II focuses on data collection, movement, storage, transformation processing, and storage ofBig Data. This individual works with both current ETL/Data Warehousing and future Big Data/Streaming/Pipeline architectures. The focus is on choosing optimal solutions to use for these purposes, then implementing, maintaining, and monitoring them, always being mindful of the overarching goal of accelerating translational research and improving clinical care.

1. Facilitates data collection from a variety of different sources, getting it in the right formats, assuring that it adheres to data quality standards, and assuring that downstream users can get that data quickly and with a common standard interface.

2. Ensures that data streams/pipelines are scalable, repeatable, and secure, and can serve multiple users within the Institute.

3. Develops as a core member of an Agile team, using Agile tools and methodology. Work closely with other team members including Application Developers, Database Developers, and Data Scientists.

4. Responsible for creating the infrastructure that provides insight from raw data and handles diverse sources of data seamlessly.

5. Enables big data and batch/real-time analytical solutions that leverage emerging technologies.

6. Additional responsibilities include developing prototypes and proof of concepts for the selected solutions, and implementing complex big data projects with a focus on collecting, parsing, and managing large sets of data using multiple platforms to allow for Research and Data Science initiatives.

7. Translates business requirements into modern data pipeline solutions. Create centralized documents and diagrams of all solutions.

8. Creates a data catalog store of all metadata.

9. Designs and implements monitoring, backup, and disaster recovery of data systems.

10. 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.

11. Responsible for the integrity and security of data in all forms of storage throughout the Data Architecture.

12. Works with other IT professionals through Mount Sinai effectively. Comply with the Institutional Review Board and HIPAA to follow all applicable policies and procedures.

13. Assists in the development of standards and procedures affecting data management, design and maintenance.Documents all standards and procedures.

14. Provides presentations and training to other team members in the above.

15. Possesses an extremely flexible attitude. Willing to work with multiple types of technologies and languages with an open mind and without technology bias. Continuous interest in updating skill sets and knowledge of trends in the Big Data Technology space.

16. Other duties as assigned.

• Bachelors degree in Computer Science or a related discipline; Advanced degree preferred.
• 4+ years relevant professional development experience, preferably in a Data Engineering role.
• In depth knowledge of the Azure cloud platform including Azure Data Factory and Databricks.
• Strong SQL and NoSQL Database Knowledge: Oracle, PostgreSQL/MYSQL, and Mongo DB (or similar).
• Proficiency on installation and configuration of big data software and technology
• Knowledge of Hadoop, Spark, Kafka and other big data technology stacks and streaming tools.
• Knowledge of healthcare data, HL7, and Mirth are also a big plus.
• Experience with CI/CD and Observability tools. Also, experience with version control (Git).
• Strong skills in data structures, data/file formats, algorithms and object oriented design.
• Proficiency with at least 2 programming languages among Scala/Python/ Java. Must be flexible and fast to pick up new languages.
• Proficiency in Restful service development, preferably with Node JS, Django and PHP.
• Experience with micro-services and SOA.
• Proficiency on installation and configuration of big data software and technology
• Knowledge of Hadoop, Spark, Kafka and other big data technology stacks and streaming tools.
• Familiarity with and the ability to leverage a wide variety of open source technologies and tools.
• Working knowledge of cloud architecture and implementation on Azure or AWS, is a big plus. Experience with serverless computing, creating VMs, cloud security, and other cloud services is also a big plus.
• Experience working in an Agile methodology. Experience working with JIRA is a plus.

Compensation Statement

The Mount Sinai Health System (MSHS) provides salary ranges that comply with the New York City Law on Salary Transparency in Job Advertisements. The salary range for the role is $90,000.00 - $135,285.00 Annually. Actual salaries depend on a variety of factors, including experience, education, and operational need. The salary range or contractual rate listed does not include bonuses/incentive, differential pay or other forms of compensation or benefits.

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