Database Administrator

Job Title: Database Administrator
Location: 2 Broadway, New York, NY

Job Description

STAFFXPERT is seeking a detail-oriented Database Administrator to support the MTA Office of Security in collecting, organizing, analyzing, and reporting fare evasion and security-related data. The ideal candidate will have strong SQL and Python skills, experience with relational databases, and expertise in reporting and dashboard development.

The candidate will work closely with management, business analysts, and other stakeholders to transform data from multiple sources into actionable insights that support operational decision-making.

Key Responsibilities

• Collect and consolidate fare evasion and security-related data from various MTA agencies and internal systems.
• Compile, review, organize, and maintain records using MTA-designated databases and reporting systems.
• Use SQL and Python to query, process, clean, and analyze large datasets.
• Develop and maintain reports, dashboards, and visualizations to support management decision-making.
• Integrate data from relational databases, spreadsheets, and other sources into consistent, synchronized datasets.
• Identify data trends, inconsistencies, and opportunities for process and system optimization.
• Follow established Standard Operating Procedures (SOPs) and prioritize data based on operational requirements.
• Ensure data accuracy, confidentiality, and compliance with applicable security and data protection requirements.
• Collaborate with business analysts, data engineers, and stakeholders to gather requirements and deliver reporting solutions.
• Prepare and maintain documentation for data models, report specifications, and reporting processes.
• Communicate findings and present analytical results to technical and non-technical stakeholders.
• Manage multiple priorities and meet deadlines in a fast-paced, high-pressure security environment.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or a related field.
• 5-6 years of relevant experience in database technologies, data analysis, reporting, or dashboard development.
• Strong hands-on experience with SQL and relational databases.
• Working experience with Python for data processing and analysis.
• 4+ years of experience developing reports and dashboards.
• Proficiency in Microsoft Office applications, including Excel, Word, PowerPoint, Visio, and Project.
• Experience gathering, cleaning, organizing, and analyzing data from multiple sources.
• Strong analytical, problem-solving, and data interpretation skills.
• Excellent written, verbal, and presentation communication skills.
• Ability to translate business requirements into meaningful reports and dashboards.
• Ability to work independently, prioritize tasks, and meet deadlines in a high-pressure environment.
• Professional attitude and ability to collaborate effectively with stakeholders at all organizational levels.

Preferred Qualifications

• Microsoft Power BI Data Analyst certification.
• Experience with Power BI or similar business intelligence and reporting tools.
• Previous experience in the transportation or railroad industry.
• Experience working with security-related, operational, or incident-based datasets.
• Knowledge of data confidentiality, security procedures, and data governance best practices.

Critical Skills

SQL | Python | Relational Databases | Data Analysis | Reporting & Dashboards | Power BI | Data Cleaning | Microsoft Excel | Data Integration | Data Visualization | Documentation | Communication Skills