Security Data Analyst I III - Metropolitan Transportation Authority

Key Responsibilities

• Collect, clean, and integrate security data from multiple sources (CCTV, access control, incident logs, etc.).
• Develop and maintain SQL queries, data pipelines, and Python scripts for automated data extraction and transformation.
• Create interactive dashboards and visual reports in Tableau and Power BI to monitor trends, incidents, and performance metrics.
• Perform statistical and predictive analyses to identify risk patterns, support investigations, and recommend mitigation strategies.
• Collaborate with security operations, IT, and leadership to translate analytical findings into actionable policies and procedures.

Requirements

• Bachelor’s degree in Data Science, Computer Science, Statistics, Criminal Justice, or related field; relevant experience may substitute.
• Proficiency in SQL and Python for data manipulation and analysis.
• Experience building dashboards and visualizations using Tableau or Power BI.
• Strong analytical mindset with ability to apply statistical methods to security data.
• Understanding of cybersecurity principles and security operations data flows.