Data Engineer I
: Job Details :

Duties: The Data Engineer I is responsible for extract, transformation and loading of data from various source systems into a data store where it can be used for reporting and analytics. This individual works with both classic ETL tools like SQL Developer, Toad and SSIS as well as modern data transformation languages like R and Python (with RStudio or Jupyter Notebooks) but ultimately modeling the data into a relational data warehouse for use in visualizations and analytics. This individual will also have access to our enterprise data management tools, currently Pentaho, to help with scheduling, automation and alerting. The focus is on choosing the right solution for the job, working with business analysts or business subject matter experts who can explain what they want to do with the data and can help with decisions about the data; but this individual must be able to profile new data sources quickly, document issues with the data and work with the stakeholder to resolve data quality issues either at the source, with the 3rd party or handled within the ETL process. Then this individual will build, maintain and monitor the datastore, looking for ways to improve data quality and efficiency, finding new sources and always being mindful of the overarching goal of meeting the business' needs. Essential Duties and Responsibilities 1. Facilitates data collection from a variety of different sources, getting it loaded into the data store, and working to improve data quality and standardization along the way.2. Work closely with other technical team members including other data engineers, devOps, DBAs, analysts and data scientists.3. Responsible for creating the data model that will facilitate the creation of reports and analytics (often through cubes and flattened data marts).4. Translates business requirements into data models and ETLs. Create centralized documents and diagrams of all solutions. 5. Documents the data catalog into a local catalog or contributes to the enterprise data catalog.6. Works with the DBA team to design a backup and disaster recovery plan for the data stores and ETLs7. Approaches all relationships with a world-class customer service approach. Maintains a customer-focused approach with users to provide solutions.8. Responsible for the integrity and security of data in all forms of storage throughout the Data Architecture.9. Works with other IT professionals through Mount Sinai effectively. Comply with HIPAA and other data use policies and procedures.10. Assists in the development of standards and procedures affecting data management, design and maintenance. Documents all standards and procedures. Skills: Experience Requirements • 7+ year's relevant professional development experience.• Strong SQL Database Knowledge of either Oracle or SQL Server.• Proficiency with at least one of these programming languages: SQL, PL/SQL, R, Python or Julia. Must be flexible and fast to pick up new languages.• Strong Healthcare Supply Chain experience is required.• Knowledge of Tableau, ODI or Pentaho is required.• Knowledge of cloud platforms like Azure or AWS and cloud-first databases like Synapse, RedShift, Snowflake, BigQuery is beneficial. Education: Education Requirements Bachelor's degree in Computer Science, data science or a related discipline; Advanced degree preferred.