Job Details

ID #44856522
State New York
City New york city
Job type Permanent
Salary TBD
Source MTA New York City Transit
Showed 2022-08-14
Date 2022-08-13
Deadline 2022-10-12
Category Et cetera
Create resume
Apply Now

Computer Specialist, (SW) I-IV, ETL Developer

New York, New york city, 10004 New york city USA
Apply Now

Job Information

Title: Computer Specialist (SW) I-IV ETL Developer

First Date of Posting: 11/8/2021

Last Date of Filing: Until Filled

Authority: MaBSTOA

Department: MTA IT

Division/Unit: Information Management Product Line

Reports to: Product Manager, Data Management

Work Location 2 Broadway, Manhattan

Hours of Work: As Required


In order to protect our employees and continue to provide safe and reliable service to our communities, as of November 14, 2021 we are requiring all new MTA hires to be fully vaccinated against COVID-19 prior to their start date. MTA will consider exceptions for religious and medical reasons, where appropriate. "Fully vaccinated" means you must have both doses of a 2-dose vaccine and two weeks have elapsed since the second dose, or have received 1 dose of a 1-dose vaccine and two weeks have elapsed since the dose. Proof of your vaccination status in the form of a CDC vaccine card must be submitted prior to your start date.


Salary range:

Computer Spec. (SW) 1 TWU: $90,656 - $98,254

Computer Spec. (SW) 2 TWU: $94,445 - $105,803

Computer Spec. (SW) 3 TWU: $101,991 - $115,061

Computer Spec. (SW) 4 TWU: $109,411 - $131,744


The selected candidate will be responsible for the development of the Extract, Transform, Load (ETL). Design & build both logical and physical data models for both Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) solutions. Develop and maintain data mapping specifications based on the results of data analysis and functional requirements. Build a variety of data loading & data transformation methods using multiple tools and technologies. Design & build automated Extract, Transform & Load (ETL) jobs based on data mapping specifications. Manage metadata structures needed for building reusable Extract, Transform & Load (ETL) components. The incumbent will analyze reference datasets and must be familiar with Master Data Management (MDM) tools. Analyze the impact of changes to downstream systems/products and recommend alternatives to minimize the impact. Derive solutions and make recommendations from deep dive data analysis proactively.

Candidate will adhere to DevOps processes and work with application developers on system develop life system functions.

Education and Experience

1. A baccalaureate degree from an accredited college, including or supplemented by 24 semester credits in computer science or a related computer field and two (2) years of satisfactory full-time computer software experience in computer systems development and analysis, applications programming, database administration, systems programming, data communications, including one year in a project leader capacity or as a major contributor on a complex project; or

2. A four-year high school diploma or its educational equivalent and six (6 years of satisfactory full-time computer software experience as described in

"1" above,

including one (1) year in a project leader capacity or as a major contributor on a complex project; or

3. Education and/or experience equivalent to

"1" or

"2" above. College education may be substituted for up to two years of the required experience in

"2" above on the basis that 60 semester credits from an accredited college is equated to one year of experience. A master's degree in computer science or a related computer field may be substituted for one year of the required experience in

"1" or

"2" above.

However, all candidates must have at least a four-year high school diploma or its educational equivalent and at least one (1) year of satisfactory full-time experience in a project leader capacity or as a major contributor on a complex project.

Note : To be eligible for placement in Assignment Level IV, in addition to the Qualification Requirements stated above, individuals must have one (1) year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or on-line applications programming.

Desired Skills

Hands on experience designing, building, configuring and maintaining the development of the Extract, Transform, Load (ETL).
  • Extensive knowledge of governance, design, and implementation of the following platforms:
    • SQL Server
    • Oracle
    • SSIS
    • Python
    • Databricks
    • PowerApps Platform (Power BI Administration)
    • Azure
    • Git
  • A deep understanding of relational database technologies, dimensional Modeling, Operational Data Stores, Enterprise Data Warehouses and Data Marts.
  • Significant experience with data modeling (conceptual, logical, and physical model design), architecture, and performance optimization.
  • Expert level derstanding of ETL fundamentals and building efficient data pipelines using Extract Transform Load (ETL) tools such as SSIS.
  • Experience with cloud data movement and computer technologies including Azure Data Factory, Logic App, Databricks and storage technologies including Azure Managed instance, Azure Data Lake, Azure synapse analytics.
  • Experience with major database platforms including Oracle, SQL Server as well as Cloud databases. NO SQL experience is a plus.
  • Advanced data processing, programming skills using SQL-based technologies, as well as other languages like Python.
  • Experience in modern DevOps practices (including Git, CI/CD).
  • Experience designing, enhancing, and/or modifying data warehouses.
  • Functional knowledge of Microsoft Power BI.
Selection Method

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

Other Information

Appointment may be at a comparable level to current level of selected candidate.

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 $101,379 (this figure is subject to change) per year or if the position is designated as a policy maker.

How To Apply

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

If you have previously applied online for other positions, enter your User Name and Password. If it is your first registration, click on the CLICK HERE TO REGISTER hyperlink and enter a User Name and Password; then 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.

Apply Now Subscribe Report job