Crime Data Analyst

The New York State Metropolitan Transportation Authority ( "MTA) is a municipal organization responsible for efficient public transportation in the New York City metropolitan area. The goal of MTA Headquarters, Department of Safety & Security ( "MTA HQS&S) is to maintain a safe and secure transportation environment for both customers and employees and aims to enhance safety through the services of a crime data analyst to provide data analysis review and to the cognizant Director Data Information and Analysis.

This position is to provide critical support for MTA HQS&S) needs.

Responsibilities

• DATA GATHERING - The successful applicant shall engage in obtaining and gathering statistical data concerning the MTA requirements, 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 applicant 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 Crime Data Analyst 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) and determine relevancy. Data collection and gathering from various MTA Agencies for daily security operational statistics. Development of action plans, schedules, and keeping participants in the development meetings appraised and on track.
• Design and map data models to shift raw data into meaningful insights.
• Design and create interactive and visually appealing dashboards, reports, and data visualizations using Power BI.
• Connect and integrate data from various sources, such as databases, spreadsheets, and cloud services, into Power BI datasets.
• Clean, transform, and model data to ensure it is suitable for reporting and analysis.
• Develop and maintain reports and dashboards that provide valuable insights and support data-driven decision-making.
• Identify areas of system optimization based on business processes.
• Implement 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 and maintain documentation for data models, report specifications, and best practices.
  
  

Qualifications EXPERIENCE & EDUCATION

• Bachelor's degree in information systems, Computer Science, Business Administration, or a related field.
• Solid 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.
• Experience in the transportation especially in railroad industry is a plus.
• 4+ years of experience in Business Analytics tools developing Reporting and Dashboards
• 5+ years in Reporting and Analytics using Power BI - M Query, DAX, Data Modelling or related programs.
• 5+ years in database technologies and strong writing skills.
• Microsoft Power BI Data Analyst certified preferred.
• 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 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.
  
  

Critical Required Skills

• Proficient written and oral communication skills in English as well as the ability to collect and interpret data effectively from various verbal and written sources
• Proven ability to act in a professional manner and maintain a positive attitude.
• Previous experience gathering, organizing and managing computer data.
• Proficiency in Microsoft Windows based operating systems, Microsoft Office, and other applications
• Ability to work in a multi-faceted, fast-paced and high intensity emergency environment while maintaining a calm and professional demeanor.
  
  

Preferred Skills

• Work experience with regional police agencies
  
  

Spruce Technology, Inc. is a mid-size, award-winning (Inc 5000, SmartCEO, Entrepreneur of the Year) technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing.

Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process.