Security Data Analyst Levels I - III

Description

Position at MTA Headquarters

JOB TITLE:

Security Data Analyst Levels I - III

DEPT/DIV:

Safety, Security & Environment

SUPERVISOR:

Director Data Info & Analysis

WORK LOCATION:

2 Broadway / Various

HOURS OF WORK:

8:00 am - 4:30 pm (7.5 hours/day) or as required

FULL/PART-TIME

FULL

SALARY RANGE:

Level I: $63,759 - $71,729

Level II: $70,409 - $79,210

Level III: $77,059 - $86,692

DEADLINE:

Until filled

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.

Opening:

The Metropolitan Transportation Authority is North America's largest transportation network, serving a population of 15.3 million people across a 5,000-square-mile travel area surrounding New York City, Long Island, southeastern New York State, and Connecticut. The MTA network comprises the nation's largest bus fleet and more subway and commuter rail cars than all other U.S. transit systems combined. MTA strives to provide a safe and reliable commute, excellent customer service, and rewarding opportunities.

Job Summary:

The Security Data Analyst Level I, II, and III provides varying levels of support and analysis, dependent on the level, to the MTA HQ's Office of Security. The Security Data Analyst role involves assisting in the development, collection, and utilization of sensitive police and security data, information, and intelligence datasets. This includes researching, performing analysis, drafting, and/or contributing to reports and presentations, and delivering updates based on their work product within public safety, MTA transit systems, or criminal justice from MTA Police and all operating MTA Security departments.

Key activities include assisting in the development of compiling, validating and analyzing critical information to identify critical security trends, emerging threats and operational vulnerabilities by producing core metrics and security reports devoted to Quality of Life (QOL), crime, customer and employee safety; working with departmental leadership and liaisons on the development of security metrics and reporting; coordinating the preparation and delivery of security submissions; tracking and analyzing security trends for operational development, monthly reporting, and ad hoc analytical projects.

Responsibilities:

Level I:

• 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.

Level II:

• 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.

Level III:

• 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.

Required Knowledge/Skills/Abilities:

Level I:

• 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.

Level II:

• Demonstrated proficiency in or the ability to learn the Microsoft Office Suite or comparable applications, i.e., Word, Excel, PowerPoint, and Outlook.
• Must possess analytical and/or quantitative skills.
• Must be able to work with all internal levels within a given organization.
• Must possess excellent communication and interpersonal skills.
• Must possess the ability to communicate and interact well with external agencies.
• Must possess the ability to complete short- and long-term projects effectively and as efficiently as possible.
• Knowledge of or ability to learn and develop reports in actionable metrics utilizing Excel, Power BI, Report Builder, ArcGIS, automated emails, etc.
• Familiarity with data exploration/data visualization tools like Tableau, Power BI, Web Focus, etc.
• Must have demonstrated ability to learn organizational and presentation skills.

Level III:

• Expertise in Microsoft Office Suite and/or comparable applications, i.e., Word, Excel, PowerPoint, and Outlook.
• Expertise in the development of reports in actionable metrics utilizing Excel, Power BI, Report Builder, ArcGIS, automated emails, etc.
• Knowledge of Multidimensional Database Management systems such as Oracle, Postgres, and SQL Server.
• Knowledge of the development of Multidimensional Database Management systems such as Oracle, Postgres, and SQL Server.
• Knowledge of GIS mapping of data or equivalent geospatial application.
• Familiarity with data exploration/data visualization tools like Tableau, Power BI, Web Focus, etc.
• Must possess demonstrated ability to complete short- and long-term projects effectively and as efficiently.
• Must possess demonstrated analytical and/or quantitative skills.
• Must possess excellent communication and interpersonal skills.
• Must possess demonstrated ability to work with all internal levels within a given organization.
• Must possess demonstrated ability to communicate and interact well with external agencies.
• Must possess strong organizational and presentation skills.

Required Education and Experience:

Level I:

• 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.

Level II:

• 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.

Level III:

• 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 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).

The Following is/are preferred:

Level I:

• 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).

Level II:

• 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.
• Familiarity with the MTA's policies and procedures.
• Familiarity with the MTA, Security, and Police Department(s).
• Knowledge of the development of Multidimensional Database Management systems such as Oracle, Postgres, and SQL Server.

Level III:

• 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, Public Policy, or a related field. A Master's degree can account for one year of related experience.
• Familiarity with the MTA's policies and procedures.
• Familiarity with the MTA, Security, and Police Department(s).

Other Information

May need to work outside of normal work hours (i.e., evenings and weekends)

Travel may be required to other MTA locations or other external sites.

According to the New York State Public Officers Law & the MTA Code of Ethics, all employees who hold a policymaking position must file an Annual Statement of Financial Disclosure (FDS) with the NYS Commission on Ethics and Lobbying in Government (the "Commission").

Equal Employment Opportunity

MTA and its subsidiary and affiliated agencies are Equal Opportunity Employers, including those concerning veteran status and individuals with disabilities.

The MTA encourages qualified applicants from diverse backgrounds, experiences, and abilities, including military service members, to apply.