Database Administrator

Title:

Database Administrator

Location: 2 BROADWAY NEW YORK, NY

Job

Description

· 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

RESPONSIBILITIES

• DATA

GATHERING - The successful applicant shall engage in obtaining and gathering

statistic data concerning incidences of fare evasion occurring at various MTA

locations, as detailed herein. This service includes, but is not limited to,

the dictates of workflow requirements as stated by the cognizant Director Data

Information and Analysis.

• COMPILING

and REVIEWING RECORDS - The successful database administrator / data

professional shall utilize current MTA designated computer interfaces and

systems, as detailed herein to include both internal reports and databases.

• DATA

ANALYSIS - Under the direction of the cognizant Director Data Information and

Analysis, the database administrator / data professional Consultant will be

responsible for the successful analysis and presentation of data. Data

analysis includes the ability to compile crime related data fields, enter data,

assign priorities, follow Standard Operations Procedures (“SOP”) and determine

relevancy, and utilize SQL PYTHON to turn varied datasets into actionable

insights.. Data collection and gathering from various MTA Agencies for daily

security operational statistics. Development of action plans, schedules, and

keeping 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.

QUALIFICATIONS

EXPERIENCE & EDUCATION

• 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.

• Experience

in the transportation especially in railroad industry is a plus.

• 4+

years of experience in Reporting and Dashboards.

• 4+

years in database technologies and strong writing skills.

• Microsoft

Power BI Data Analyst certified preferred.

• 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.