Security Data Science Specialist

The Metropolitan Transportation Authority (MTA) is seeking a Security Data Science Specialist to support the Office of Security with data collection, analysis, reporting, and dashboard development related to security operations and fare-evasion activities. The ideal candidate will have strong experience with SQL, Python, relational databases, data analysis, reporting, dashboards, and Power BI. The candidate will work with data from multiple sources, clean and organize datasets, identify trends, and convert data into actionable insights for management and security operations. Key Responsibilities Collect, organize, and analyze security and fare-evasion data from various MTA agencies and systems. Compile and review records from databases, reports, spreadsheets, and other internal systems. Use SQL and Python to analyze large and varied datasets and identify meaningful trends and insights. Connect and integrate data from databases, spreadsheets, relational databases, and cloud-based sources. Clean, validate, and organize data for reporting and analysis. Develop and maintain Power BI reports, dashboards, and data visualizations to support management decision-making. Analyze crime- and security-related data, assign priorities, identify relevant information, and follow established procedures and SOPs. Prepare daily and periodic security operational statistics and reports. Identify opportunities for system and business-process improvements based on data analysis. Collaborate with business analysts, data engineers, security personnel, and other stakeholders to understand requirements and deliver analytical solutions. Translate business requirements into effective dashboards, reports, and data insights. Create and maintain documentation for data models, reports, dashboards, and reporting processes. Maintain data confidentiality and follow applicable security and data protection requirements. Support action plans, schedules, meetings, and other data-related activities as directed by management. Present analytical findings and technical information clearly to both technical and non-technical stakeholders. Required Qualifications

Bachelor’s degree in Computer Science, Information Systems, Business Administration, or a related field. 4+ years of experience in data analysis, reporting, dashboards, or a related analytical role. 4+ years of experience working with databases, preferably relational databases. Strong hands-on experience with SQL and Python. Strong experience developing reports and dashboards, preferably using Microsoft Power BI. Experience gathering, cleaning, organizing, integrating, and analyzing data from multiple sources. Strong analytical and problem-solving skills with the ability to work with large datasets. Advanced proficiency with Microsoft Office applications, particularly Excel and PowerPoint. Experience with Word, Visio, and Microsoft Project is preferred. Excellent written, verbal, and presentation skills. Ability to explain complex technical information to non-technical stakeholders. Ability to work independently, prioritize multiple tasks, and meet deadlines in a high-pressure environment. Strong interpersonal skills and the ability to work effectively with individuals at all organizational levels.