Data Specialist (Capital Strategy)

Description 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. 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. #J-18808-Ljbffr Metropolitan Transportation Authority (MTA)