Operations Data & BI Specialist

MABSTOA; United States; On-site; USD 114,000 - 127,000; Full time

Job summary

MTA NYC Transit seeks a Computer Specialist (Operations) 2 for OMNY Services to support reliable and secure operation through technical, operational, analytical, data, and stakeholder-management activities. You may focus on system reliability, data & BI, or a mix of these functions.

Responsibilities include building BI dashboards, automating reports, managing incidents, and working with DevOps, QA, and stakeholders on releases and config management.

Qualifications

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

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.

Skills

Incident management

Monitoring & observability

SQL expertise

BI tools

Data modeling

RDBMS

APIs & integrations

Data governance

Communication skills

On-call readiness

Education

Technical certificate (675 hours) in computer operations

High school diploma

Baccalaureate degree

Education/experience equivalency

Tools

SQL Server

Oracle

PostgreSQL

Power BI

Tableau

Looker

Python

APIs

Job description

MTA NYC Transit seeks a Computer Specialist (Operations) 2 for OMNY Services to support reliable and secure operation through technical, operational, analytical, data, and stakeholder-management activities. You may focus on system reliability, data & BI, or a mix of these functions.

Responsibilities include building BI dashboards, automating reports, managing incidents, and working with DevOps, QA, and stakeholders on releases and config management.