Job Description
Job Title Manager HR Data Engineer
Job ID 100934
Location Manhattan - Downtown
Job Information
JOB TITLE: Manager, HR Data Engineer
SALARY RANGE: Salary Commensurate with Experience
DEPT/DIV: People Department
SUPERVISOR: Senior Manager, HR Data Engineer
LOCATION: 2 Broadway New York, NY 10004
HOURS OF WORK: 9:00 am - 5:00 pm (7 hours/day)
DEADLINE: December 15, 2022
Summary
This position will report to the Senior Manager of HR Data Engineer and support the day-to-day data pipeline initiatives to design, build, and maintain ease for using data structures to facilitate reporting and monitor key performance indicators. The incumbent will collaborate across Human Capital Management disciplines to identify internal/external data sources to design table structure, define ETL strategy, automated quality assurance checks, and implement scalable ETL solutions.
Responsibilities
• Ensure that all assignments are completed with the highest quality and within agreed-to Service Level agreement guidelines and Key Performance Indicator (KPI) targets.
• Create and conduct project/architecture design review.
• Develop HR data pipelines and reports with advance 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.
• Develop and maintain dashboards/reports using MS Power BI and Oracle Analytic Cloud.
• Perform ad hoc analysis as necessary.
• Identify and implement continuous improvement initiatives as assigned.
• Other duties as assigned.
Qualifications
• Strong understanding of data modeling principles, including Dimensional modeling, data normalization principles, etc.
• Proficient understanding of SQL Engines and able to develop advanced quires and analytics
• Familiarity with data exploration/data visualization tools like Tableau, MS Power BI, PeopleSoft EPM, Web Focus, Oracle Business Intelligence, 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.
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 three (3) years of relevant professional experience leading, implementing, and reporting on business key performance indicators in a data warehousing/lake/hub environment.
• Minimum of three (3) 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 three (3) years management experience
• Minimum of one (1) years 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/warehouse/Lakes/Hubs.
• Strong understanding of Data Management principles.
Other Information
As an employee of MTA Headquarters, you may be required to complete an annual financial disclosure statement with the State of New York, if your position earns more than $108,638 (this figure is subject to change) per year or if the position is designated as a policy maker.
How To Apply
MTA employees must apply via My MTA Portal. You can submit an online application by logging into My MTA Portal, clicking the My Job Search ribbon, and selecting the “Careers” link.
Logging in through My MTA Portal will link your BSC ID number to your job application to identify you as an internal applicant.
Equal Employment OpportunityMTA and its subsidiary and affiliated agencies are Equal Opportunity Employers, including with respect to veteran status and individuals with disabilities.
The MTA encourages qualified applicants from diverse backgrounds, experiences, and abilities, including military service members, to apply.