Database Administrator

About This Role

This position provides critical support for key security operational needs within a municipal entity responsible for public transportation. The role involves gathering, compiling, reviewing, and analyzing data related to fare evasion to enhance safety for customers and employees.

Responsibilities

• Obtain and gather statistical data concerning incidences of fare evasion occurring at various locations
• Utilize current designated computer interfaces and systems, including internal reports and databases, to compile and review records
• Analyze and present data under the direction of the designated Director of Data Information and Analysis
• Compile crime-related data fields, enter data, assign priorities, follow Standard Operating Procedures (“SOP”), determine relevancy, and utilize SQL / PYTHON to turn varied datasets into actionable insights
• Collect and gather data from various agencies for daily security operational statistics
• Develop action plans and schedules, and keep meeting participants currently 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

• Above average English written and oral communication skills coupled with the ability to effectively collect and interpret data from various verbal and written sources
• Proficiency with Microsoft Windows based operating systems, such as Office, Excel, PowerPoint, and other applications
• Proven ability to act in a professional manner and maintain a positive attitude
• Ability to work in a multi-faceted, fast-paced, and high-intensity Security environment while maintaining a calm and professional demeanor
• Previous experience gathering, organizing, and managing computer data
• Work experience with SQL and PYTHON
• 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