Computer Specialist II (Operations) Rep

Metropolitan Transportation Authority (MTA); New York (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

Metropolitan Transportation Authority (MTA) seeks a Computer Specialist to support the OMNY services, focusing on data, operations, and systems analysis for reliable fare payments. The role emphasizes BI reporting, data governance, and collaboration with Development, QA, DevOps, and stakeholders.

Qualifications include strong SQL/Python skills, experience with BI tools (Power BI/Tableau/Looker), and ability to manage incidents and change reviews in large multi-tier environments.

Qualifications

• Advanced SQL and data modeling experience required.
• Strong BI/reporting with Power BI/Tableau/Looker.
• Experience in incident management and production support.

Responsibilities

• Build BI reports, dashboards, KPIs, and extracts.
• Automate reporting with SQL, DAX, Python.
• Manage incidents and release validation.
• Monitor databases, microservices, and APIs.
• Coordinate with DevOps, QA, Operations, and stakeholders.

Skills

Power BI

SQL

Python

Data governance

Incident management

Monitoring/Observability

API/microservices

Stakeholder communication

Education

Bachelor's degree or equivalent

Tools

Tableau

Looker

SQL Server

Oracle

PostgreSQL

Job description

Computer Specialist, OMNY Services supports the reliable, secure, and effective operation of the OMNY fare payment system through a range of technical, operational, analytical, data, configuration, and stakeholder-management activities. Depending on assignment, incumbents may focus on system reliability and operations, data and business intelligence, stakeholder and configuration management, or a combination of these functions .

RESPONSIBILITIES:

• Build BI reports, dashboards, KPIs, and extracts using Power BI, Tableau, Looker, or equivalent .
• Automate reporting with SQL, DAX, Python, and related technologies .
• Manage P1–P3 incidents, recovery, escalation, defect tracking, and release validation .
• Monitor and optimize databases, microservices, APIs, applications, and integrations .
• Oversee monitoring, observability, logs, dashboards, and actionable alerts .
• Perform configuration validation, change reviews, dependency mapping, and systems analysis .
• Partner with Development, QA, DevOps, Operations, and stakeholders on defects, releases, and technical issues.
• Apply data governance, quality, metadata, and information-security practices .
• Serve as primary technical point of contact for internal/external stakeholders .
• Conduct requirements-gathering sessions and translate business needs into functional and technical specifications .

EDUCATION AND EXPERIENCE:

• A certificate from an accredited technical school (approximately 675 hours) with a specialization in computer operations plus a four-year high school diploma or its educational equivalent, and three years of satisfactory, full-time computer operations experience in a large-scale mainframe or multi-tiered computer environment, or three years of satisfactory data communications network experience in a mainframe or multi-tiered computer environment, one year of which must have been in a project leader capacity or as a major contributor on a complex project; or
• A four-year high school diploma or its educational equivalent and five years of satisfactory full-time computer operations or data communications network experience as described in ‘1’ above, one year of which must have been in a project leader capacity or as a major contributor on a complex project; or
• A baccalaureate degree from an accredited college and four years of satisfactory full-time computer operations or data communications network experience as described in ‘1’ above, one year of which must have been in project leader capacity or as a major contributor on a complex project; or
• Education and/or experience equivalent to "1", "2", or "3" above. However, all candidates must have at least a four-year high school diploma or its educational equivalent and three years of satisfactory full-time computer operations or data communications network experience as described in "1" above, one year of which must have been in a project leader capacity or as a major contributor on a complex

DESIRED SKILLS:

Mission-critical incident management and production support experience .

Strong knowledge of monitoring, observability, log analytics, alerting, databases, APIs, microservices, and application environments .

Advanced SQL: complex queries, joins, window functions, and query optimization .

BI experience with Power BI, Tableau, Looker, or equivalent .

Data modeling knowledge: star schema, snowflake schema, dimensional modeling .

Relational database experience: SQL Server, Oracle, PostgreSQL; indexing, partitioning, optimization .

Experience with JSON, XML, APIs, integrations, data flows, and dependency mapping .

Knowledge of configuration management, stakeholder coordination, data governance, data quality, metadata, and information security .

• Excellent communication skills with the ability to bridge technical and non ‑ technical audiences .

Ability to participate in on ‑ call duties and respond to off ‑ hours incidents when required .

SELECTION METHOD :

Based on evaluation of education, skills, experience, interview, and written assessment . All selected candidates will be subject to a full background investigation that includes employment and education. Discrepancies may lead to dismissal .

OTHER INFORMATION :

Appointment may be at a comparable level to current level of selected candidate. (If necessary)

As an employee of MTA NYC Transit, 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 is subject to change) per year or if the position is designated as a policy maker .

For 55-a eligible titles: Candidates selected for this position may be placed in a competitive or non-competitive class position based on their qualifications. Qualified candidates who are placed in a competitive class position are eligible for the 55-a Program. Please indicate in your cover letter and in the upper right corner of your resume that you would like to be considered for the position under the 55-a Program. For detailed information regarding the 55-a Program, please visit the following link https://www1.nyc.gov/site/dcas/employment/55-a-program.page

TA APPLICANTS MUST BE IN A PERMANENT CIVIL SERVICE STATUS IN THE TITLE(S). IF YOU ARE ON AN ESTABLISHED LIST, YOUR LIST NUMBER MUST BE REACHABLE TO BE CONSIDERED FOR APPOINTMENT. The Metropolitan Transportation Authority is North America's largest transportation network, serving a population of 15.3 million people across a 5,000-square-mile travel area surrounding New York City, Long Island, southeastern New York State, and Connecticut. The MTA network comprises the nation’s largest bus fleet and more subway and commuter rail cars than all other U.S. transit systems combined. MTA strives to provide a safe and reliable commute, excellent customer service, and rewarding opportunities .

ADDITIONAL INFORMATION :

Final salary is determined experience, skillset, and alignment with compensation practices. The posted range reflects expected compensation and may be updated as market or business needs evolve .

To be eligible for consideration for a new role, current MTA employees must complete at least one year of service in their current role prior to applying. Additionally, eligibility to interview is contingent upon maintaining a satisfactory record of job performance, attendance, and disciplinary conduct. Pursuant to the New York State Public Officers Law & the MTA Code of Ethics, all employees who hold a policymaking position must file an Annual Statement of Financial Disclosure (FDS) with the NYS Commission on Ethics and Lobbying in Government (the “Commission”) .

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 .