DATABASE ADMINISTRATOR - Security Data Science Specialist

Compu-Vision Consulting Inc.
  • New York, NY
  • $75 Per Hour
  • Instant Apply
1 day ago

Job Description

Title: DATABASE ADMINISTRATOR - Security Data Science Specialist
Location: 2 BROADWAY NEW YORK, NY
Duration: 12 months ((7 hours per day, 35 hours per week based on SME availability for meetings and other requirements))
Experience: 6-8 Years


SUMMARY of the FUNCTION/Role:
Client is a municipal organization responsible for efficient public transportation in the New York metropolitan area. The goal of Client Headquarters, Office Of Security ( "OOS ) is to maintain and enhance secure transportation environment for both customers and employees and aims to enhance safety through the services of Fare Evasion / Data Analysts to gather and review fare evasion data per the instruction of the Director Data Information and Analysis or designee.

This position is to provide critical support for Office Of Security ( "OOS )

RESPONSIBILITIES:
  • DATA GATHERING - The successful applicant shall engage in obtaining and gathering statistic data concerning incidences of fare evasion occurring at various client locations, as detailed herein. This service includes, but is not limited to, the dictates of workflow requirements as stated by the Director Data Information and Analysis.
  • COMPILING and REVIEWING RECORDS - The successful database administrator / data professional shall utilize current client's designated computer interfaces and systems, as detailed herein to include both internal reports and databases.
  • DATA ANALYSIS - Under the direction of the 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 client 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.
Critical Key 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

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.

Risks (required by Client's Risk Management):
  • Describe the type of work consultant: Desk work only
  • Whether any work will be performed within 50 feet of track right-of-way (yes or no) NO
  • Whether the work may involve areas with environmental risks (lead, asbestos) -- substantial or minimal (yes or no). NO

Numbers & Facts

LocationNew York, NY
Salary$75 Per Hour

Skills

  • Administrative Skillsunmatched
  • Analysis Skillsunmatched
  • Asbestosunmatched
  • Best Practicesunmatched
  • Business Administrationunmatched
  • Business Analysisunmatched
  • Calendar Managementunmatched
  • Cloud Computingunmatched
  • Communication Skillsunmatched
  • Computer Scienceunmatched
  • Consultingunmatched
  • Customer Support/Serviceunmatched
  • Data Analysisunmatched
  • Data Cleaningunmatched
  • Data Collectionunmatched
  • Data Entryunmatched
  • Data Formatsunmatched
  • Data Managementunmatched
  • Data Modelingunmatched
  • Data Scienceunmatched
  • Data Setsunmatched
  • Database Administrationunmatched
  • Database Technologyunmatched
  • Decision Supportunmatched
  • Document Managementunmatched
  • English Languageunmatched
  • Establish Prioritiesunmatched
  • Information Technology & Information Systemsunmatched
  • Information/Data Security (InfoSec)unmatched
  • Interpersonal Skillsunmatched
  • Microsoft Excelunmatched
  • Microsoft Officeunmatched
  • Microsoft PowerPointunmatched
  • Microsoft Product Familyunmatched
  • Microsoft Visiounmatched
  • Microsoft Windows Operating Systemunmatched
  • Microsoft Wordunmatched
  • Operations Processesunmatched
  • Power BIunmatched
  • Presentation/Verbal Skillsunmatched
  • Problem Solving Skillsunmatched
  • Process Improvementunmatched
  • Public Transportunmatched
  • Python Programming/Scripting Languageunmatched
  • Regulatory Complianceunmatched
  • Relational Databases (RDBMS)unmatched
  • Reporting Dashboardsunmatched
  • Requirements Managementunmatched
  • Risk Managementunmatched
  • SQL (Structured Query Language)unmatched
  • Spreadsheetsunmatched
  • Standard Operating Procedures (SOP)unmatched
  • Statisticsunmatched
  • Time Managementunmatched
  • Writing Skillsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder