Data Analyst

Posting number: 26-20310

Department: MBTA - Technology Innovation Division

Division: 863-Technology Innovation Division

Job classification: Data Analyst (Technology Innovation Division)

Posting type: Open/External and Promotional/Internal

Categories: IT and Computers

Summary

The Data Analyst (TID) is part of the Transit Technology team within the Transformation & Technology Department. The Transit Technology team is responsible for designing, building, and maintaining dispatching systems and other technology tools that enable MBTA Operations division to deliver safer, more efficient, and more reliable transit services. This role will work closely with Transit Tech product teams to measure and monitor the success of technology products and initiatives as part of outcome-driven technology delivery.

The Data Analyst (TID) will empower stakeholders to make data-driven decisions and create a culture of continuous improvement. The position will collect, clean, and validate data, perform statistical analyses using modern data analysis and visualization tools, communicate findings, and write technical documentation. The Data Analyst will collaborate with other team members to share knowledge, provide cross-training, and jointly support cross-divisional projects.

Examples of duties

• Design dashboards, visualizations, graphs, charts, and tools that clearly communicate outcomes, findings, and trends of Operations data.
• Proactively build and maintain positive and effective relationships with Departments. Work with Departments to analyze results, forecast current and future needs, assess performance, and evaluate strategic opportunities.
• Communicate with and present to executive leadership project results and findings.
• Gather, analyze, and interpret operational data using a combination of SQL, Excel, Python and/or relevant modern data analysis tools.
• Perform quality control on data inputs, calculations, algorithms, and model outputs, and investigate associated data gaps or inconsistencies.
• Develop tools to facilitate the automation and dissemination of analyses.
• Prepare scheduled and ad-hoc reports, slideshows, and other visual reports incorporating narratives and graphic data, for both online and print formats.
• Manage timelines, project milestones, and communications with internal and external partners.
• Respond to each inquiry, whether from a customer, vendor, or coworker, in a courteous and professional manner consistent with the Authority’s quality standard.
• Work directly with Operations Leadership to identify the needs specific to the assigned division.
• Collaborate with other Analysts on the knowledge sharing, cross-training, and joint support of cross-division projects.
• Perform all other duties and projects that may be assigned.

Additional responsibilities may include a focus on one or more departments or locations. See applicable addendum for department or location specific functions.
Supervision

• No direct reports.

Qualifications

• A Bachelor’s degree from an accredited institution in business, finance, economics, computer science, data science, urban planning, engineering, or a related field.
• Two (2) years of experience in data science, business analytics, business intelligence, quantitative analysis, or other related fields.
• Proficiency with Microsoft Excel, Word, and PowerPoint. As part of the interview process, an Excel assessment may be required.
• Experience in at least one approach to advanced data analysis (e.g., SQL, Python, R, SPSS, GIS, or other).
• Ability to learn quickly, take direction, work independently, and use creative and collaborative approaches to resolve issues.
• Effective organizational, analytical, multi-tasking, and time management skills.
• Effective written and verbal communication skills.
• Possess strong statistics and data fundamentals.
• The ability to work effectively with a diverse workforce.

Supplemental information

• Experience with relational databases (e.g., Microsoft SQL Server, PostgreSQL, Oracle), including writing queries to obtain and manipulate data.
• Experience with Python, Excel VBA, or other programming languages, and/or data management and statistical analysis tools (R, SPSS, STATA, SAS, etc.).
• Experience with Tableau or other visualization software.
• Familiarity with transportation planning and transit systems, particularly the MBTA subway and bus network

Substitutions

• A High School Diploma or GED with an additional seven (7) years of directly related experience substitutes for the bachelor’s degree requirement.
• An associate degree from an accredited institution and an additional three (3) years of directly related experience substitutes for the bachelor’s degree requirement.
• A master’s degree in a related subject substitute for two (2) years of general experience.
• A nationally recognized certification, or statewide/professional certification in a related field substitutes for one year of experience.