Apply on Employer Site

Metropolitan Transportation Authority · 7 hours ago

Data Specialist, Capital Strategy

New York, NY

Full-time

Hybrid

Mid Level

$81K/yr - $110K/yr

4+ years exp

Metropolitan Transportation Authority is seeking a Data Specialist in Capital Strategy. The role involves utilizing large databases to develop analytical tools for capital planning, collaborating across departments, and improving decision-making processes.

Transportation/Trucking/Railroad

Responsibilities

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

Qualification

Data architecturePythonSQLData visualizationETL pipelinesDatabase managementGISPower BIApache AirflowStakeholder engagementFront-end developmentAutomation toolsEffective communicationTime management

Required

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

Knowledge of database management, programming, and other skills related to 'big data' or data science

A firm grasp on Python, SQL, and D3

Understanding of code version control using GitHub and/or GitLab

Familiarity with front-end web development and related tools like React

Some experience with spatial data and GIS

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

Preferred

Master's degree preferred

Experience with ADLS and Apache Airflow is a plus

Understanding of automation tools like Power Automate is a plus

Company

Metropolitan Transportation Authority

Glassdoor3.6

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.

Founded in 1834

New York, NY, US

10001+ employees