Metropolitan Transportation Authority Careers

Description

JOB INFORMATION:

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) 

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 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
2. A four‐year high school diploma or its educational equivalent and six years of satisfactory full time computer software experience as described in ʺ1ʺ above, including one year in a project leader capacity or as a major contributor on a complex project; or

1. 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, or a certificate of at least 625 hours in computer programming from an accredited technical school (post high school), 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 year of satisfactory full‐time experience in a project leader capacity or as a major contributor on a complex project. 

 Special Note

1. 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”).

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 Username and Password.  If it is your first registration, click on the CLICK HERE TO REGISTER hyperlink and enter a Username 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.