Database Administrator

Tri-Force Consulting Services, Inc.•New York, NY

1d•Onsite

About The Position

The Database Administrator will be responsible for gathering, compiling, reviewing, and analyzing data from various sources within the MTA. This role involves working with SQL and Python to transform datasets into actionable insights, developing reports and dashboards, and ensuring data confidentiality and compliance. The administrator will collaborate with stakeholders to understand requirements and deliver solutions that meet business needs, while also maintaining documentation and adhering to best practices.

Requirements

Above average English written & 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 & 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.
Strong communication skills and the ability to effectively convey complex information.
4+ years of experience in Reporting and Dashboards.
4+ years in database technologies and strong writing skills.
Good communication skills to translate business requirements into Dashboards and Reporting
Proficient in MS Office applications, Word, Excel, Visio, PowerPoint, Project
Excellent oral, written and presentation communication skill in successfully relating technical information to non-technical personnel.
Strong analytical and problem-solving skills
Ability to effectively prioritize and execute in a high-pressure environment.
Ability to independently set priorities and meet deadlines.
Excellent inter-personal skills including the ability to work with individuals at all levels of the organization.

Nice To Haves

Experience in the transportation especially in railroad industry is a plus.
Microsoft Power BI Data Analyst certified preferred.

Responsibilities

Obtain and gather statistic data concerning incidences of fare evasion occurring at various MTA locations.
Utilize current MTA designated computer interfaces and systems to compile and review records, including both internal reports and databases.
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 and PYTHON to turn varied datasets into actionable insights.
Collect and gather data from various MTA Agencies for daily security operational statistics.
Develop action plans, 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.