Computer Specialist II (Operations) Rep

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

Job summary

Metropolitan Transportation Authority (MTA) seeks a Computer Specialist to support OMNY Services with data, analytics, and system reliability. You will build BI dashboards, automate reports, and manage incidents while collaborating with Dev, QA, and Ops teams.

Requires strong SQL, BI tooling experience, and data modeling knowledge; familiarity with governance and security is valued. This role involves on‑call duties and cross‑functional collaboration.

Qualifications

• Must have strong incident management and production support experience.
• Knowledge of monitoring, observability, logs, alerts, and databases.
• Proficient in advanced SQL with complex queries and optimizations.
• Experience using Power BI, Tableau, Looker, or similar BI tools.
• Data modeling knowledge: star/snowflake schemas and dimensional modeling.
• Experience with SQL Server, Oracle, PostgreSQL; indexing and partitioning.
• Experience with JSON, XML, APIs, data flows and dependency mapping.
• Familiarity with data governance, metadata, and information security.
• Excellent written and verbal communication bridging technical and non‑technical audiences.
• Willingness to participate in on‑call duties and off‑hours incidents.

Responsibilities

• Build BI reports, dashboards, KPIs, and extracts using BI tools.
• Automate reporting with SQL, DAX, Python, and related tech.
• Manage P1–P3 incidents, recovery, escalation, and release validation.
• Monitor and optimize databases, microservices, APIs, apps, and integrations.
• Oversee monitoring, observability, logs, dashboards, and actionable alerts.
• Perform configuration validation, change reviews, and dependency mapping.
• Partner with Development, QA, DevOps, Operations, and stakeholders on issues.
• Apply data governance, quality, metadata, and information-security practices.
• Serve as primary technical point of contact for stakeholders.
• Conduct requirements gathering and translate business needs into specs.

Skills

Incident management

Monitoring & observability

Advanced SQL

BI tooling

Data modeling

Relational DBs

APIs & data flows

Data governance & security

Communication skills

On-call readiness

Education

Technical certificate + HS diploma + 3 years ops/network exp

HS diploma + 5 years ops/data network exp

Baccalaureate + 4 years ops or data network exp

Education/experience equivalent with HS + 3 years complex project exp

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 .

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses