MBTA · 15 hours ago
Business Intelligence Analyst
Boston, MA
Full-time
Onsite
Entry, Mid Level
2+ years expMBTA is dedicated to providing safe, reliable, and accessible transportation. The Business Intelligence Analyst will utilize data visualization and analytics to inform decision making and measure the health of the Capital Investment Program, working closely with various departments and stakeholders.
TravelTransportationAutomotiveLogisticsPublic Transportation
No H1B
Responsibilities
Develop complex visualizations using Tableau Desktop for consumption by the respective stakeholder groups dependent on the reporting needs, ensuring data is used correctly to explain narratives and storytelling
Prepare capital reports utilizing several sources including Microsoft Excel spreadsheets and various systems
Implement, execute, and optimize data extraction, cleansing, consolidation, and conversion processes and utilities, including the development of a data governance framework
Analyze data and data models to understand data relationships and how they co-exist in different sources, writing SQL scripts to extract, consolidate and publish data to reports and data to visualization tools, e.g., Microsoft Excel and Tableau
Write advanced SQL scripting to support ad-hoc reporting needs and to extract, consolidate, and publish data for reporting and visualization tools such as Tableau, and develop and maintain data models, databases, data warehouses, and related SQL processes
Support the transition of our legacy Capital Management System (CMS) to a new Enterprise Resource Planning (ERP) system based in Oracle/Peoplesoft and conversion to Tableau Cloud as well as leveraging AI capabilities
Evaluate potential future reporting solutions and dashboards for the capital program and facilitate and participate in the design and implementation of the solution
Structure data for optimal presentation, access, performance, and integration
Set standards for technical documentation and maintain business intelligence (BI) objects
Perform data profiling to identify and understand anomalies
Work closely with data modelers and developers
Adhere to rules, regulations, collective bargaining agreements (if applicable) and policies of the MBTA including the EEO, anti-discrimination, anti-harassment, and anti-retaliation policies
Perform all other duties and projects that may be assigned
Qualification
Required
Bachelor's Degree from an accredited institution in computer science, engineering or related field
Two (2) years of experience with development and maintenance of data models, databases, data warehouses, data lakes and/or SQL scripts
Experience with data analysis, data cleansing, data extraction, data conversion, and data governance
Experience with report development, data visualization, and storytelling
Advanced expertise in Tableau Desktop, Tableau Cloud, Tableau Prep Builder, Microsoft Excel, and Microsoft PowerPoint
Analytical and synthesis skills
Flexibility and diplomacy in interpersonal relationships
Organizational skills and ability to multitask (work on several projects at once)
Able to operate beyond policies and high-level business processes to define and document supporting standards and procedures
Experience gathering requirements and developing reports that match those requirements
Strong communication skills
Implementation experience in agile methodology
Preferred
Experience with PeopleSoft
Knowledge of government and transit industry
Understanding of project financials: budgets, funding, commitments, and expenditure
Benefits
Accrued paid sick leave
Monthly transportation pass, based on the city from which the intern / co-op commutes to work, at no cost
Company
MBTA
The Massachusetts Bay Transportation Authority, often referred to as the MBTA or simply The T, is the public operator of most bus, subway, commuter rail and ferry systems in the greater Boston, Massachusetts, area.
5001-10000 employees
Funding
Current Stage
Late StageLeadership Team
Barbara Bates
Deputy CFO Capital
Mary Ann O'Hara, CPA
Chief Financial Officer
Recent News
Boston Herald
2026-01-03
2025-12-30
Company data provided by crunchbase