Posted 2w ago

Data Specialist (Capital Strategy)

@ Metropolitan Transportation Authority
New York City, New York, United States
$77k-$96k/yrHybridFull Time
Responsibilities:Develop analytics, ETL pipelines, Collaborate across departments
Requirements Summary:Bachelor’s in urban planning, data science, engineering, public administration or related field; 4+ years of relevant experience; strong Python, SQL; ETL and data visualization experience; Git/GitHub; ADLS and Apache Airflow; GIS/spatial data; front-end and stakeholder skills.
Technical Tools Mentioned:ADLS, Apache Airflow, Python, SQL, D3, GitHub, GitLab, Power BI, Tableau, Mode, React, GIS, Power Automate
Save
Mark Applied
Hide Job
Report & Hide
Job Description
New York,
NY

Description

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:

Data Specialist (Capital Strategy)

AGENCY:

Construction & Development

DEPT/DIV:

Planning, Capital Strategy and Planning

REPORTS TO:

Director, Capital Strategy

WORK LOCATION:

2 Broadway

HOURS OF WORK:

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

JOB FAMILY: DAB

Grade: 003

SALARY RANGE:

$77,059 to $96,324

DEADLINE:

Open Until Filled

 

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.

 

Education and Experience

 

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 GitHub and/or GitLab.

 

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.

 

Other Information

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.

Selection Criteria

Based on the evaluation of education, skills, experience, and interview.

 

How to Apply

Qualified applicants can submit an online application by clicking on the “APPLY NOW” button on the CAREERS page or the JOB DESCRIPTION page.

 

If you have previously applied online for other positions, enter your Username and Password. If it is your first registration, click the CLICK HERE TO REGISTER hyperlink and enter a Username and Password; click on the REGISTER button.

 

Equal Employment Opportunity

MTA 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.