Business Intelligence Analyst

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

Job summary

Massachusetts Bay Transportation Authority (MBTA) seeks a Business Intelligence Analyst to turn data into actionable insights for the Capital Investment Program. You will build dashboards, write SQL, govern data, and partner with CFA and IT teams to enhance reporting and analytics.

Responsibilities include developing Tableau visualizations, leading data preparation, and supporting the CMS-to-ERP transition while ensuring accuracy and adherence to MBTA policies.

Qualifications

• Bachelor’s degree or higher is required.
• Two years of experience developing and maintaining data models, databases, data warehouses, data lakes and/or SQL scripts.
• Experience with data analysis, cleansing, extraction, conversion, and data governance.
• Experience with report development, data visualization, and storytelling.
• Advanced expertise in Tableau Desktop, Tableau Cloud, Tableau Prep Builder, Excel, and PowerPoint.
• Strong analytical and communication skills.
• Experience with agile methodology.

Responsibilities

• Develop complex visualizations using Tableau Desktop for stakeholder groups.
• Prepare capital reports using Excel and various systems.
• Implement, optimize data extraction, cleansing, consolidation, and conversion processes with a data governance framework.
• Analyze data relationships across sources; write SQL to extract, consolidate, and publish data to reports and visualizations.
• Write advanced SQL for ad-hoc reporting and maintain data models, data warehouses, and related SQL processes.
• Support transition from legacy CMS to a new ERP system (Oracle/PeopleSoft) and Tableau Cloud integration.
• Evaluate future reporting solutions and assist in design and implementation of the solution.
• Structure data for optimal presentation, access, performance, and integration.
• Set standards for technical documentation and BI objects.
• Perform data profiling to identify anomalies and work with data modelers and developers.
• Adhere to MBTA policies and procedures.
• Perform additional duties as assigned.

Skills

Tableau Desktop

Tableau Cloud

Tableau Prep Builder

SQL

Data modeling

Data warehouses

Data governance

Data visualization

Storytelling

Agile

Excel

PowerPoint

Data extraction

Data cleansing

Education

Bachelor’s degree in computer science, engineering or related field

Tools

PeopleSoft

Job description

The Business Intelligence Analyst will bring experience in data visualization, data analytics, and storytelling to assist the MBTA to use data and performance metrics to drive decision making and to measure the health of its Capital Investment Program (CIP). The Capital Finance and Accounting (CFA) department is responsible for enterprise-wide capital program reporting across projects and departments for presentations to Senior Management and the Board of Directors. The Business Intelligence Analyst conducts deep data analysis using data management, data conversion and data governance, and is responsible for understanding, developing, enhancing, and maintaining the technical components to all the relevant data sources that inform reports and dashboards. This position is in the CFA Department and will work closely with various CFA staff as well as Capital Departments and respective IT stakeholders.

**This requisition will close once the posting exceeds 200 applicants.*

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

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.

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

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 an additional three (3) years of directly related experience substitutes for the bachelor’s degree requirement.
• A master’s degree in a related subject substitutes 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.

Preferred Experience and Skills

• Experience with PeopleSoft.
• Knowledge of government and transit industry.
• Understanding of project financials: budgets, funding, commitments, and expenditure.