Health ETL Developer

Position Summary

NYU’s Global Programs & University Life organization is committed to being a welcoming campus community that reflects and enacts the values of inclusion, diversity, belonging, equity and accessibility that inform academic excellence. Employees in this organization are expected to contribute to diverse, equitable, inclusive and accessible learning and working environments for our students, staff, and faculty.

The Health ETL Developer is responsible for the design of the enterprise-wide data/information architecture. This position will maintain and build numerous data pipelines from end to end that support software for the Student Health Center. The role is expected to understand and apply best practices and provide expertise in acquiring data from source systems to build database content. As such, it is expected that the individual will understand the full lifecycle of data warehousing and business intelligence projects. The Health ETL Developer will be required to identify business requirements, develop data models, perform data analysis, write advanced SQL queries and triggers, design and code complex stored procedures, and maintain and performance tune existing databases.

Qualifications

Required Education:Bachelor’s Degree in Computer Science, Information Management, Information Systems, Information Technology, Electrical Engineering.Preferred Education:Master’s Degree in Computer Science, Information Management, Information Systems, Information Technology, Electrical Engineering, Business Administration.Required Experience:5+ years demonstrated experience in designing and developing architectural/data solutions in Enterprise Data Warehouse environment using SQL. Experience in leading and collaborating with technical resources ensuring technical solutions are adhering to specifications. Experience working with healthcare, academic, human resources data.Preferred Experience:5+ years previous experience in higher education environment and/or previous experience in healthcare organization, experience with HIPAA, HITRUST, SOC 2, and GDPR. Previous experience with a wide range of development tools: Databricks, Airflow, REST, Aptible, Docker, Terraform, Spark, Kafka, Fivetran, AWS (S3, Lambda, Kinesis, Aurora, Glue). Knowledge and experience in Microsoft SQL, Oracle SQL, Snowflake, PostgreSQL, Tableau. Previous experience in Iterative and/or Agile methodologies.Required Skills, Knowledge and Abilities:Demonstrated strong knowledge of entity relationship diagram modeling and dimensional data modeling. Demonstrated strong knowledge of entity relationship diagram modeling and dimensional data modeling. Ability to structure and conduct interviews to gather business knowledge on a subject area. Strong written and oral communication skills, including the demonstrated ability to explain complex business processes and technical concepts for various stakeholder groups. Functional knowledge of the business processes in a higher education or healthcare environment. Functional knowledge of operational data and processes of at least one major ERP system such as PeopleSoft, SAP or Workday. Proficient in Structured Query Language (SQL).Preferred Skills, Knowledge and Abilities:Advanced programming skills in SQL and Python. Knowledge of NYU’s enterprise systems such as UDW+. Familiarity with technologies / methodologies including AWS, Mulesoft, Tableau, sqlDBM and Data Vault.

Additional Information

In compliance with NYC’s Pay Transparency Act, the annual base salary range for this position is USD $140,000.00 to USD $160,000.00. New York University considers factors such as (but not limited to) scope and responsibilities of the position, candidate’s work experience, education/training, key skills, internal peer equity, as well as, market and organizational considerations when extending an offer. This pay range represents base pay only and excludes any additional items such as incentives, bonuses, clinical compensation, or other items. NYU aims to be among the greenest urban campuses in the country and carbon neutral by 2040. Learn more at nyu.edu/nyugreen.EOE/AA/Minorities/Females/Vet/Disabled/Sexual Orientation/Gender Identity