DATABASE ADMINISTRATOR

New Wave People, Inc.; New York (NY); On-site; USD 90,000 - 120,000; Full time

Job summary

New Wave People, Inc. is seeking a data professional to gather statistics on fare evasion, compile and review records, and analyze data under the Director Data Information and Analysis.

You will turn datasets into actionable insights using SQL and Python. Responsibilities include integrating data from databases, spreadsheets, and clouds, building reports and dashboards, ensuring data confidentiality, and collaborating with analysts and engineers to meet business needs.

Qualifications

• Bachelor's degree in information systems, computer science, or related field.
• Solid experience with relational databases.
• Excellent analytical and communication skills.
• 4+ years of experience in Reporting and Dashboards.
• 4+ years in database technologies with strong writing skills.
• Power BI Data Analyst certification preferred.
• Experience in transportation/railroad industry is a plus.

Responsibilities

• Data gathering of statistics on fare evasion occurrences.
• Compiling and reviewing records using company interfaces.
• Data analysis and presenting data under the Director Data Information and Analysis.
• Connect and integrate data from databases, spreadsheets, relational databases, and cloud services into synchronized datasets.
• Clean and organize data for reporting and analysis.
• Develop and maintain reports and dashboards to provide data insight.
• Identify areas of system optimization based on business processes.
• Follow data security measures and comply with data protection regulations.
• Collaborate with analysts, data engineers, and stakeholders to deliver solutions.
• Create and maintain documentation for data models and reporting specifications.

Skills

Analytical skills

Communication skills

Time management

Problem solving

Interpersonal skills

Education

Bachelor's degree in information systems, Computer Science, Business Administration, or related field

Tools

SQL

Power BI

MS Office

Visio

Excel

Job description

M-F 7 HOURS TOTAL –
9-5 with 1 hour unpaid lunch or 9-4 with out lunch.
No holiday overtime or travel
No parking provided

RESPONSIBILITIES

• DATA GATHERING - The successful applicant shall engage in obtaining and gathering statistic data concerning incidences of fare evasion occurring at various 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 company 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

Salary commensurate with scope of work job experience

New Wave People is an Equal Opportunity Employer (EEO).