Note: The job is a remote job and is open to candidates in USA. The Metropolitan Transportation Authority is North America's largest transportation network, serving a population of 15.3 million people. The Security Data Analyst Level I, II, and III roles provide varying levels of support and analysis to assist in the development, collection, and utilization of sensitive police and security data, contributing to public safety and operational metrics.
Responsibilities
- Assist in developing and maintaining queries that combine and transform datasets to support Security and Police analytical needs
- Conduct research and assist with drafting analytical products related to Security, Criminal Justice, and Policing topics under guidance
- Support the development of reports, dashboards, and visualizations using tools such as Power BI, Report Builder, ArcGIS, and automated reporting systems
- Learn and apply data analysis methods, visualization techniques, and security analytics practices
- Collaborate with Security team members and analysts to support the creation of analytical reports and operational products
- Assist in compiling and organizing analysis from confidential, open-source, police, and security information sources
- Support monitoring of security incident data and help identify basic trends while maintaining data quality
- Develop and maintain queries and data transformations that combine multiple datasets to support Security and Police operational and investigative needs
- Conduct research and produce analytical reports related to Security, Criminal Justice, and Policing issues
- Design and deliver reports, dashboards, and visualizations using Power BI, Report Builder, ArcGIS, and automated reporting tools for operational and leadership stakeholders
- Apply data analysis methods, visualization techniques, and security analytics practices to produce accurate and actionable insights
- Collaborate with Security team leads and operational units to develop analytical report products and performance metrics
- Produce analytical assessments using confidential, open-source, police, intelligence, and security information sources to support operational planning and decision-making
- Analyze and monitor security incident data to identify trends, patterns, and anomalies, and recommend improvements to data collection and data integrity processes
- Design and develop advanced queries, datasets, and analytical approaches to support complex Security and Police operational and intelligence needs
- Conduct advanced research and produce high-level analytical reports related to Security, Criminal Justice, and Policing issues
- Develop sophisticated analytical products and visualizations using tools such as Power BI, Report Builder, ArcGIS, and automated reporting platforms
- Apply advanced analytical methods and emerging technologies to enhance analytical capabilities and improve reporting effectiveness
- Serve as a subject-matter expert guiding complex analytical questions or data challenges
- Produce comprehensive analytical assessments using confidential, open-source, law enforcement, and security information sources to support operational planning and risk assessment
- Perform advanced analysis of security incident data to identify complex patterns, emerging risks, and long-term trends while supporting improvements to data collection and data integrity practices
Skills
- Demonstrated proficiency in or the ability to learn the Microsoft Office Suite or comparable applications, i.e., Word, Excel, PowerPoint, and Outlook
- Proficiency in and/or ability to learn communication and interpersonal skills
- Proficiency in and/or ability to learn analytical and/or quantitative skills
- Proficiency in and/or ability to learn organizational and presentation skills
- Proficiency in and/or ability to learn to work with all internal levels within a given organization
- Proficiency in and/or ability to learn to communicate and interact well with external agencies
- Proficiency in and/or ability to learn to complete short- and long-term projects effectively and as efficiently as possible
- Familiarity with data exploration/data visualization tools like Tableau, Power BI, Web Focus, etc
- Knowledge of the development of reports in actionable metrics utilizing Excel, Power BI, Report Builder, ArcGIS, automated emails, etc
- Associate's Degree (AA) in Security, Criminal Justice, Homeland Security, Mathematics, Psychology, Sociology, Public Administration, Computer Science, Engineering, Information Management, Statistics, Data Science, Data Engineering, Public Policy, or a related field. An equivalent combination of education from an accredited college and experience may be considered in lieu of a degree
- Minimum 1 year of work experience
- Bachelor's Degree in Arts/Sciences (BA/BS) in Security, Criminal Justice, Homeland Security, Mathematics, Psychology, Sociology, Public Administration, Computer Science, Engineering, Information Management, Statistics, Data Science, Data Engineering, Mathematics, Public Policy or a related field from an accredited college or an equivalent combination of education from an accredited college and experience may be considered in lieu of a degree
- Minimum 1 year of related experience handling large datasets, including building and structuring datasets
- Minimum 1 year of experience developing advanced analytical products and writing database queries
- Minimum 1 year of experience merging data and performing QA to identify and resolve data anomalies and errors
- Minimum 2 years of related experience handling large datasets, including building and structuring datasets
- Minimum 2 years of experience developing advanced analytical products and writing database queries
- Minimum 2 years of experience merging data and performing QA to identify and resolve data anomalies and errors
- Minimum 2 years of experience with relational databases (e.g., Oracle, Postgres, SQL Server)
- Bachelor's Degree in Arts/Sciences (BA/BS) in Security, Criminal Justice, Homeland Security, Mathematics, Psychology, Sociology, Public Administration, Computer Science, Engineering, Information Management, Statistics, Data Science, Data Engineering, Public Policy, or a related field
- Knowledge of the development of Multidimensional Database Management systems such as Oracle, Postgres, and SQL Server
- Familiarity with the MTA's policies and procedures
- Familiarity with the MTA, Security, and Police Department(s)
- Master's degree in Arts/Sciences (MA/MS) in Security, Criminal Justice, Homeland Security, Mathematics, Psychology, Sociology, Public Administration, Computer Science, Engineering, Information Management, Statistics, Data Science, Data Engineering, Mathematics, Public Policy, or a related field from an accredited college
- Knowledge of the development of reports in actionable metrics utilizing Excel, Power BI, Report Builder, ArcGIS, automated emails, etc
Benefits
- This position is eligible for telework, which is currently one day per week. New hires are eligible to apply 30 days after their effective date of hire.
Company Overview