Manager, HR Data Engineer

Description

Job Title: Manager, HR Data Engineer

Dept/DIV: People Department

Work Location: 2 Broadway

Full/Part-Time: Full

Salary Range: $110,000 - $123,000

Deadline: Until filled

This position is eligible for teleworking, which is currently one day per week. New hires are eligible to apply 30 days after their effective hire date.

The Metropolitan Transportation Authority is North America's largest transportation network, serving a population of 15.3 million people across a 5,000-square-mile travel area surrounding New York City, Long Island, southeastern New York State, and Connecticut. The MTA network comprises the nation’s largest bus fleet and more subway and commuter rail cars than all other U.S. transit systems combined. MTA strives to provide a safe and reliable commute, excellent customer service, and rewarding opportunities.

This position will report to the Director of HR Data Science and support the day‑to‑day data pipeline initiatives to design, build, and maintain ease for data structures to facilitate reporting and monitor key performance indicators. The incumbent will collaborate across Human Capital Management disciplines to identify internal and external data sources to design table structure, define ETL strategy, automate quality assurance checks, and implement scalable ETL solutions.

• Ensure that all assignments are completed with the highest quality and within agreed‑upon Service Level agreement guidelines and Key Performance Indicator (KPI) targets.
• Create and conduct a project/architecture design review.
• Proficient knowledge of Azure Data Factory, Databricks, & Azure Delta Lake.
• Experience programming languages (e.g., Python, R).
• Working experience in data extraction using API.
• Develop HR data pipelines and reports with advanced SQL programming language and maintain Data Warehousing/Data Lakes/Data Hubs and Analytical reporting Environment.
• Work with IT teams to collect required data from internal and external systems and troubleshoot HR system issues.
• Design and build modern data management solutions and create POC when necessary to test new approaches.
• Create runbooks and actionable alerts as part of the development process.
• Perform SQL and ETL tuning as necessary.
• Perform ad hoc analysis as necessary.
• Identify and implement continuous improvement initiatives as assigned.
• Other duties as assigned.

Knowledge/Skills/Abilities:

• Strong understanding of data modeling principles, including Dimensional modeling, data normalization principles, etc.
• Proficient understanding of SQL Engines and able to develop advanced queries and analytics.
• Familiarity with data exploration/data visualization tools like MS Power BI, People Soft HCM, Job Vite, JDXpert, Jetdocs, or Oracle Analytics Cloud Ability to think strategically, analyze, and interpret Human Capital Management and Financial data.
• Strong communication skills – written and verbal presentations.
• Excellent conceptual and analytical reasoning competencies.
• Comfortable working in a fast‑paced and highly collaborative environment.
• Process‑oriented with excellent documentation skills, including strong Excel & PowerPoint skills, Visio flows, and mock‑up creation.

Required

Education and Experience:

• Bachelor's degree in Computer Science, Information Management, Statistics, or Finance or related field. An equivalent combination of education and experience may be considered in lieu of a degree.
• A minimum of four (4) years of relevant professional experience leading, implementing, and reporting on business key performance indicators in a data warehousing/lake/hub environment.
• Minimum of four (4) years of experience using SQL for analytics, working with traditional relational databases and/or distributed systems such as People Soft Enterprise Performance Management (EPM), Hadoop / Hive, Big Query, Redshift, or Oracle Databases.

• Master's Degree in Computer Science, Information Management, or Statistics.
• Experience programming languages (e.g., Python, R) preferred.
• Minimum of four (4) years of management experience.
• Minimum of one (1) year of experience with workflow management tools (Airflow, Oozie, Azkaban, UC4).
• Understanding of Finance Data and Human Resource Data practices and procedures.
• Proficient Knowledge of Data Repositories/warehouses/Lakes/Hubs.

May need to work outside of normal work hours (i.e., evenings and weekends).

Travel may be required to other MTA locations or other external sites.

MTA and its subsidiary and affiliated agencies are Equal Opportunity Employers, including those concerning veteran status and individuals with disabilities.

The MTA encourages qualified applicants from diverse backgrounds, experiences, and abilities, including military service members, to apply.