About This Role
The Database Administrator is responsible for gathering, compiling, reviewing, and analyzing statistical data related to fare evasion and security operations. This role involves utilizing computer interfaces, internal reports, and databases to turn varied datasets into actionable insights, supporting management decision-making.
Responsibilities
- Obtain and gather statistical data concerning incidences of fare evasion at various locations
- Utilize current company-designated computer interfaces and systems, including internal reports and databases, for compiling and reviewing records
- Analyze and present data under the direction of the Director Data Information and Analysis
- Compile crime-related data fields, enter data, assign priorities, follow Standard Operations Procedures ("SOP"), and determine relevancy
- Utilize SQL PYTHON to turn varied datasets into actionable insights
- Collect and gather data from various MTA Agencies for daily security operational statistics
- Develop action plans and schedules, and keep meeting participants appraised
- Connect and integrate data from various sources, such as databases, spreadsheets, relational databases, and cloud services, into synchronized datasets
- Clean and organize data to ensure it is suitable for reporting and analysis
- Develop and maintain reports and dashboards which provide data insight and support management decision-making
- Identify areas of system optimization based on business processes
- Follow security measures to ensure data confidentiality and compliance with data protection regulations
- Collaborate with business analysts, data engineers, and other stakeholders to understand requirements and deliver solutions that meet business needs
- Create, maintain, and manage documentation for data models, report specifications, and adherence to best practices
Requirements
- Bachelor's degree in information systems, Computer Science, Business Administration, or a similarly related field
- Solid and progressive experience in working with relational databases
- Excellent analytical skills with the ability to dissect large amounts of data
- Strong communication skills and the ability to effectively convey complex information
- 4+ years of experience in Reporting and Dashboards
- 4+ years in database technologies
- Strong writing skills
- Proficient in MS Office applications, Word, Excel, Visio, PowerPoint, Project
- Excellent oral, written, and presentation communication skills in successfully relating technical information to non-technical personnel
- Strong analytical and problem-solving skills
