Data Specialist, Capital Strategy

Overview

Position at MTA Construction & Development. This position is eligible for telework, which is currently one day per week. New hires are eligible to apply 30 days after their effective date of hire.

JOB TITLE:

AGENCY:
Construction & Development

DEPT/DIV:
Planning, Capital Strategy and Planning

REPORTS TO:

WORK LOCATION:

2 Broadway

HOURS OF WORK: 8:30 AM to 5:00 PM or as required (7.5 HR/DAY)

PAY POINTS: 479

SALARY RANGE: $80,963 to $110,226

Deadline:

• Utilize large databases of information, including asset assessments, asset inventories, regional planning information, transit usage, and socio-economic and demographic information to develop analytical and statistical tools to underpin the agency’s capital planning strategy.
• Develop technical subject matter expertise in data architecture of one or more MTA asset categories.
• Develop automations and ETL pipelines to clean and consolidate asset data from multiple data repositories across agencies to create a consistent version-controlled source of data for asset planning and to reduce manual processes.
• Work collaboratively across departments and staff, creating tools that assist in decision-making based on system and component condition, performance, criticality, safety, impact on service reliability, customer experience, access, resiliency, and other relevant considerations.
• Evaluate datasets and models to assess quality and analytical rigor and enhance data quality reporting.
• Assist in the ongoing improvement of decision-making tools, including data architecture, to continuously improve the MTA’s capital planning process.
• Analyze, interpret, and visualize information, including the maturation of capital analytics, for other data-driven decision-making.
• Establish areas of analysis, including system/network analyses; life-cycling costing; condition deterioration analysis; investment scenario modeling for prioritization of investments; and metrics to establish explicit linkages between the MTA Agencies’ objectives and investment priorities with desired and specific outcomes.
• Recommend and implement frameworks to consider multiple factors, such as asset condition, transit system performance data, and regional needs, trends, and challenges.
• Develop and present planning information, processes, and results to stakeholders.
• Create new and meaningful means for public communication of – and public input into - MTA’s capital planning.

• A Bachelor's degree in Urban Planning, Data Science, Engineering, Public Administration, or a related field.
• Must have a minimum of four (4) years of relevant experience. Master’s degree preferred.
• Knowledge of database management, programming, and other skills related to “big data” or data science – in particular, experience with ADLS and Apache Airflow is a plus.
• A firm grasp on Python, SQL, and D3.
• Understanding of code version control using Git Hub and/or Git Lab.
• Familiarity with front-end web development and related tools like React.
• Some experience with spatial data and GIS.
• Understanding of automation tools like Power Automate is a plus.
• Ability to perform in-depth qualitative and quantitative analyses using a variety of tools and datasets.
• Strong time and task management skills with the ability to manage multiple projects and deadlines and maximize the output of a small staff.
• Effective communication skills. Strong writing and presentation skills.
• Knowledge of the MTA regional network and operating context, as well as local, state, and federal transportation policies.
• The ability to work with both senior-level staff and technical personnel on a diverse array of issues.
• The ability to interface with stakeholders, including senior political and business representatives.
• Proficiency in data science software to produce data analytics, visualization tools, and spatial analysis, such as Power BI, Tableau, or Mode.

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 r to…