Spruce Technology, Inc Hiring for Data Analyst at New York, NY Full Time

The New York State Metropolitan Transportation Authority ( “MTA”) is a municipal organization responsible for efficient public transportation in the New York metropolitan area. The goal of MTA Headquarters, Department of Safety & Security ( “MTA HQ S&S”) is to maintain a safe and secure transportation environment for both customers and employees and aims to enhance safety through the services of two (2) Fare Evasion / Data Analysts to gather and review fare evasion data per the instruction of the cognizant Director Data Information and Analysis or designee.

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

Responsibilities

• DATA GATHERING – The successful applicant shall engage in obtaining and gathering statistic data concerning incidences of fare evasion occurring at various MTA locations, 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 fare evasion / data analyst professional 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 Fare Evasion / 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 meeting participants currently appraised.
• Connect and integrate data from various sources, such as databases, spreadsheets, and cloud services, into Power BI datasets.
• Clean and organize data to ensure it is suitable for reporting and analysis.
• Develop and maintain reports and dashboards which provide data insight and support management decision-making.
• Identify areas of system optimization based on business processes.
• Follow 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.
• Must possess a valid State issued Driver’s License.
• 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 Reporting and Dashboards.
• 4+ 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 Requirements

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

• Previous experience gathering, organizing and managing computer data.
• Work experience with regional, municipal and / or 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.