Health ETL Developer

Updated: about 1 month ago
Location: New York City, NEW YORK

Details

Posted: 17-Mar-24

Location: New York, NY, US, 10001

Type: Full-time

Salary: Open

Categories:


Other Staff/Administrative

Internal Number: 238177458


Health ETL Developer
US-NY-New York
Job ID: 2023-11789
Type: Student Health Center
# of Openings: 1
Category: Technology
New York University
Overview

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.


Responsibilities

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.


Qualifications

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


Salary: 140000.00

PI238177458


Create a Job Alert for Similar Jobs
About New York University
New York University (NYU) is one of the top private universities in the United States, and NYU Tandon School of Engineering traces its roots back to 1854, building on an illustrious past as Brooklyn Poly and the NYU Polytechnic School of Engineering. Our mission is to excel in research, teaching, and entrepreneurship and inspire and educate engineers for the 21st century — backed by an historic commitment of $1 billion to recruit new faculty, fuel groundbreaking basic and applied research in key areas, and expand the Downtown Brooklyn campus. NYU Tandon faculty are world renowned leaders in science and technology, with a strong commitment to research, innovation, and entrepreneurship that make a difference in the world. We lead and have ties to multidisciplinary centers in wireless technology, cybersecurity, urban informatics, data sciences, artificial intelligence, renewable energy, and health, among others. Our faculty and students are part of the high-tech start-up culture in New York City and in downtown Brooklyn, and we support three “future lab” business incubators that connect our students and faculty to today’s innovation economy. We are deeply committed to teaching and le...arning, and with NYU's unrivaled global network of campuses, we promote a truly global engineering education. NYU Tandon is committed to substantially increase the proportion of our faculty from historically underrepresented groups in STEM and we encourage candidates from such groups to apply. We aspire to create a climate where diversity and inclusion are not only appreciated but considered an asset for creativity and innovation, and we seek faculty who have a real passion for a culturally diverse environment. We take pride in our high numbers of female students and students who are the first in their family to go to college. NYU belongs to the Higher Education Recruitment Consortium (HERC), which assists with dual-career searches, and our faculty are supported by a range of work-life balance programs provided by the NYU Office of Work Life
Show more
Show less
Connections working at New York University
More Jobs from This Employer
https://main.hercjobs.org/jobs/19885537/health-etl-developer
Return to Search Results


Similar Positions