Metropolitan Transportation Authority · 9 hours ago
Manager, HR Data Engineer
New York, NY
Full-time
Hybrid
Mid, Senior Level
$110K/yr - $123K/yr
4+ years expThe Metropolitan Transportation Authority is North America's largest transportation network, serving a population of 15.3 million people. This role involves managing HR data pipeline initiatives, collaborating across departments, and implementing scalable ETL solutions.
Transportation/Trucking/Railroad
Responsibilities
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
Qualification
Required
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, PeopleSoft HCM, JobVite, 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
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 PeopleSoft Enterprise Performance Management (EPM), Hadoop / Hive, BigQuery, Redshift, or Oracle Databases
Preferred
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
Company
Metropolitan Transportation Authority
The Metropolitan Transportation Authority is North America's largest transportation network, serving a population of 15.3 million people in the 5,000-square-mile area fanning out from New York City through Long Island, southeastern New York State, and Connecticut.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Janno Lieber
Chair & CEO
Sam Tabikh, P.E.
Facilities Engineer and Projects CEO
Recent News
Crain's New York Business
2025-10-07
San Francisco Chronicle
2025-10-05
2025-10-04
Company data provided by crunchbase