← Back to jobsJob ID col-cmv9tojz301baqu01f8rm36tc

Donnelly & Moore CorporationPosted 30+ days ago

Python SQL Data Analyst

Full-time
On-site
4+ years
Competitive
Posted 30+ days ago

A confidential transportation client in New York City is hiring a Python SQL Data Analyst to gather, compile, and analyze data related to fare evasion and security operations. The role uses SQL and Python to integrate datasets, produce reports and dashboards, and support management decisions while maintaining data confidentiality.

Posted
30+ Days Ago
Source
www1.jobdiva.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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”), 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

  • 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
  • Work experience with SQL & PYTHON
  • Ability to work in a multi-faceted, fast- paced and high intensity Security environment while maintaining a calm and professional demeanor
  • 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

Preferred

  • Experience in the transportation especially in railroad industry is a plus
  • Microsoft Power BI Data Analyst certified preferred
  • Transportation Industry Experience
  • Railroad Industry Experience
  • Microsoft Power BI Data Analyst Certification

Required skills

PythonSQLRelational DatabasesReporting and DashboardsMicrosoft OfficeMicrosoft WindowsPower BI

Full job description

A confidential transportation client in New York City is hiring a Python SQL Data Analyst to gather, compile, and analyze data related to fare evasion and security operations. The role uses SQL and Python to integrate datasets, produce reports and dashboards, and support management decisions while maintaining data confidentiality.

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”), 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

Preferred

  • Experience in the transportation especially in railroad industry is a plus
  • Microsoft Power BI Data Analyst certified preferred
  • Transportation Industry Experience
  • Railroad Industry Experience
  • Microsoft Power BI Data Analyst Certification

Company

  • IT and cybersecurity staffing and consulting firm
  • New York, New York, USA
  • https://donmor.com/
  • Founded in 1997
  • 51-200 employees

Qualifications

  • 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
  • Work experience with SQL & PYTHON
  • Ability to work in a multi-faceted, fast- paced and high intensity Security environment while maintaining a calm and professional demeanor
  • 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
  • Experience in the transportation especially in railroad industry is a plus
  • Microsoft Power BI Data Analyst certified preferred
  • 4+ years of experience in Reporting and Dashboards.
  • 4+ years in database technologies and strong writing skills.

Required skills

  • Python, SQL, Relational Databases, Reporting and Dashboards, Microsoft Office, Microsoft Windows, Power BI, Microsoft Power BI Data Analyst Certification

Preferred skills

  • Microsoft Power BI Data Analyst certified preferred

Experience

  • 4+ years

Job details

Employment type

Full-time

Seniority level

4+ years

Date posted

Oct 15, 2026

Work mode

On-site

Job source

www1.jobdiva.com

Company

Donnelly & Moore Corporation

Information Technology & AI

IT and cybersecurity staffing and consulting firm

  • New York, New York, USA
  • Information Technology & AI
  • 51-200 employees
  • Founded 1997
  • donmor.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs in New York

Brillio

1d ago

New

Data Specialist

Full-timeHybridSan Francisco, CACompetitive

Brillio is hiring a Data Specialist to architect and optimize scalable Databricks data solutions. The role develops ETL pipelines, data warehousing solutions, and data integrations while supporting data governance, reliability, and analytics.

Why similarSame rolePythonSQL

Flow Traders

Today

New

Core Data Engineer

Full-timeOn-siteNew York, NY$165K – $210K/yr

Flow Traders is hiring a Core Data Engineer to own the lifecycle and quality of foundational data products, including market, trading, and reference data.

Why similarSimilar titlePythonData & Analytics

Snorkel AI

Today

New

Senior/Staff Forward Deployed Engineer - Data as a Service

Full-timeHybridNew York, NY$180K – $320K/yr

Snorkel AI is a frontier AI data lab that develops datasets, benchmarks, evaluations, and custom solutions for AI systems.

Why similarSimilar titlePythonData & Analytics

Get new Data Analyst jobs in New York by email

Create job alert

Python SQL Data Analyst

Donnelly & Moore Corporation · Competitive

Apply on company site