Computer Specialist (SW) 4 Represented TA/OA

Metropolitan Transportation Authority; New York (NY); On-site; USD 132,000 - 159,000; Full time

Job summary

Metropolitan Transportation Authority seeks a Computer Specialist (SW) IV to ensure accurate data in EAM Hexagon and Spear 4i. You will develop SQL/PLSQL queries, support Oracle relations, and drive work-order planning using Power BI dashboards.

Responsibilities include updating records, creating custom work orders, and automating workflows with Power Automate/Power Apps, while collaborating with field maintenance staff to resolve issues and maintain performance.

Qualifications

• Bachelor’s degree or higher with 2+ years of software experience in data systems development and analysis.
• Experience building queries, views, procedures in Oracle and SQL Server environments.
• Proficiency with Oracle PL/SQL, T‑SQL, and SQL scripting tools is required.

Responsibilities

• Develop and maintain queries, searches, and business rules across SQL Server and Oracle.
• Support and maintain Spear 4i clients connected to Oracle databases.
• Create and modify data records, work orders, and inspection patterns in EAM systems.
• Design reports and dashboards using Power BI to guide maintenance planning.
• Collaborate with field staff to troubleshoot issues and ensure system reliability.

Skills

Oracle PL/SQL

T‑SQL

SQL Server

Data analysis

Power BI

Problem solving

Communication

Education

Bachelor's degree in Computer Science or related field

Two years of software experience in development/analysis

Tools

SQL Developer

TOAD

SQL Plus

Power Automate

Power Apps

Excel

Windows/Linux environments

Job description

Computer Specialist (SW) 4 Represented TA/OA

Electronics Maintenance (EMD) / Automated Fare Collection

Location:

2 Broadway

Hours:

8am – 4pm, May Vary

Director AFC Performance Review

Deadline (if Applicable):

Compensation\Authority - Union

TA/OA

EMD - Computer Specialist (SW) IV

$131,642- $158,514 / OA

EMD - Computer Specialist (SW) IV

$135, 251 / TA – CIVIL SERVANT TITLE ONLY

POSITION SUMMARY:

The selected candidate will play a critical role in ensuring the accuracy, completeness, and consistency of data within the EAM Hexagon and Spear 4i environments. This position is responsible for developing and maintaining database queries, custom searches, business rules, pivot tables, and job schedulers across both SQL Server and Oracle platforms. The role includes supporting and maintaining Spear 4i clients integrated with Oracle 9i, 11g, and 12c databases, and leveraging Kezava and Power BI dashboards to analyze inspection and maintenance patterns that drive effective work‑order generation. Additional responsibilities involve updating data records, creating custom work orders, and designing inspection and maintenance patterns within the EAM system. The candidate will collaborate closely with field maintenance personnel to troubleshoot issues, resolve user concerns, and ensure reliable system performance.

RESPONSIBILITIES:

• Maintain and support Spear 4i client applications interfacing with Oracle 9i, 11g, and 12c databases.
• Utilize Kezava and Power BI dashboards and reporting tools to analyze inspection and maintenance trends that inform effective work‑order planning and generation.
• Update and maintain data records within the EAM environment, including creating custom work orders and designing inspection and maintenance patterns.
• Develop and implement workflow automation solutions using Power Automate and Power Apps to streamline and optimize key business processes.
• Collaborate regularly with field maintenance personnel to troubleshoot issues, resolve user concerns, and ensure seamless system functionality.
• Support continuous improvement of EAM processes by identifying data gaps, proposing enhancements, and ensuring accuracy and reliability of system outputs.

EDUCATION AND EXPERIENCE:

Computer Specialist IV (Software)

• A baccalaureate degree from an accredited college, including or supplemented by 24 semester credits in computer science or a related computer field, and two years of satisfactory full‑time computer software experience in computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development and design, including one year in a project leader capacity or as a major contributor on a complex project; or
• Afour‑yearhighschooldiplomaoritseducationalequivalentandsixyearsof satisfactoryfull timecomputersoftwareexperienceasdescribedinʺ1ʺabove, includingoneyearinaprojectleadercapacityorasamajorcontributorona complexproject;or
• Educationand/orexperienceequivalenttoʺ1ʺorʺ2ʺabove.Collegeeducation maybesubstitutedforuptotwoyearsoftherequiredexperienceinʺ2ʺabove onthebasisthat60semestercreditsfromanaccreditedcollegeisequatedto oneyearofexperience.Amaster’s degree in computer scienceorarelated computerfield,oracertificateofatleast625hoursincomputerprogramming fromanaccreditedtechnicalschool(posthighschool),maybesubstitutedfor oneyearoftherequiredexperienceinʁ1ʺorʁ2ʺabove.However,allcandidatesmusthaveatleastafour‑yearhighschooldiplomaoritseducationalequivalentandatleastoneyearofsatisfactoryfull‑timeexperienceinaprojectleader capacityorasamajorcontributoronacomplexproject.

Special Note

• To be eligible for Assignment Level IV, candidates must have one additional 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 applications programming.

DESIRED SKILLS:

• Demonstrated experience supporting EAM maintenance management databases and developing applications using Oracle PL/SQL and T‑SQL, including designing tables, queries, views, stored procedures, packages, cursors, and exception handlers.
• Proficiency in SQL Developer, TOAD, SQL Plus, and relevant scripting languages.
• Strong knowledge of EAM systems, Oracle Gateways to DB2, MS Access, MS Excel, Power BI, Power Automate, and Power Apps.
• Familiarity with Windows 10/Windows Server 2012, Linux, Visual Studio, VBA, C++, C#, HTML, and ASP.NET.
• Exceptional analytical, written, verbal, and interpersonal communication skills.
• Proven ability to collaborate effectively with personnel at all organizational levels.
• Ability to manage and prioritize multiple projects within tight timeframes.

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.