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.