Transit Operations Data Analyst — Insights Drive Safety

Massachusetts Bay Transportation Authority; Boston (MA); On-site; USD 75,000 - 105,000; Full time

Job summary

The MBTA is seeking a Data Analyst on the Operations Analytics team to design, build, and maintain data and analytics tools for safer, more efficient service. You will collect, clean, analyze, and visualize large datasets from various operations systems, and translate findings into actionable recommendations for leadership.

This role emphasizes collaboration with Operations Leadership, development of automated analyses, and delivery of scheduled and ad-hoc reports in both online and print

Qualifications

• Bachelor’s degree in business, finance, economics, CS, data science, urban planning, engineering or related field.
• 2 years of full-time work or equivalent in data science, analytics, BI, or related area.
• Experience in advanced data analysis (SQL, Python, R, SPSS, GIS, etc.).
• Proven ability to learn quickly, work independently, and collaborate to resolve issues.
• Strong organizational, analytical, multitasking, and time-management skills.
• Excellent written and verbal communication skills.
• Solid statistics and data fundamentals.
• Ability to work with a diverse workforce.
• Proficient with Microsoft Excel, Word, and PowerPoint; Excel assessment may be required during interview.

Responsibilities

• Collect, clean, and validate data; perform statistical analyses using modern data analysis tools; communicate findings; and write technical documentation.
• Collaborate with team members on knowledge sharing and cross-division projects.
• Design dashboards, visualizations, graphs, charts, and tools to clearly communicate outcomes, findings, and trends.
• Build relationships with departments to analyze results, forecast needs, assess performance, and evaluate opportunities.
• Present project results and findings to executive leadership.
• Gather and interpret operational data using SQL, Excel, Python, and other tools.
• Quality control data inputs, calculations, algorithms, and model outputs; investigate data gaps or inconsistencies.
• Develop tools to automate and disseminate analyses.
• Prepare scheduled and ad-hoc reports and visuals for online and print formats.
• Manage timelines, milestones, and communications with internal and external partners.
• Respond professionally to inquiries from customers, vendors, or coworkers.
• Collaborate with Operations Leadership to identify department-specific needs.
• Perform other duties and projects as assigned.

Skills

SQL queries

Python

Statistics

Excel

Communication

Time management

Critical thinking

Education

Bachelor’s degree in a related field

Tools

Tableau

SQL Server

PowerPoint

Job description

The MBTA is seeking a Data Analyst on the Operations Analytics team to design, build, and maintain data and analytics tools for safer, more efficient service. You will collect, clean, analyze, and visualize large datasets from various operations systems, and translate findings into actionable recommendations for leadership.

This role emphasizes collaboration with Operations Leadership, development of automated analyses, and delivery of scheduled and ad-hoc reports in both online and print