Business Intelligence Analyst

At the MBTA, we envision a thriving region enabled by a best-in-class transit system. Our mission is to serve the public by providing safe, reliable, and accessible transportation. MBTA’s Core Values are built around safety, service, equity, sustainability, and culture. Each employee that works for the MBTA performs their roles based on our vision, mission, and values. This includes attendance, participation, and contribution in local safety committee meetings as needed.

Job Summary

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.

Duties \& 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.

Supervision

• No direct reports.

Minimum Requirements \& Qualifications

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

• 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’s 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 substitutes for two (2) years of general experience.
• A nationally recognized certification, or statewide/professional certification in a related field substitutes for one (1) 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.

Job Conditions:

• Ability to effectively read, comprehend, communicate, and respond to instructions, orders, signs, notices, inquiries, etc. in English.
• Be at least eighteen (18) years of age, except if participating in an approved high school internship / co-op program.
• Ability to commute to assigned work locations in the Boston, MA metro area, as required by the role.
• Ability to provide internal and external customers with courteous and professional experiences.
• Ability to work effectively, independently, and as part of a diverse workforce team (or supervise, if required).
• Ability to uphold the rights and interests of the MBTA while building and maintaining effective relationships with employees and co-workers.
• Ability to 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.
• Have a satisfactory work record for the two (2) years immediately prior to the closing date of this posting (unless if current student or recent graduate), including overall employment, job performance, discipline, and safety records (infractions and/or offenses occurring after the closing of the posting and before the filling of a vacancy may preclude a candidate from consideration for selection).
• Ability to pass a Criminal Offender Record Information (CORI) check, comprehensive background screening, and / or medical Clinic screening, potentially including physical examination and drug and alcohol screenings.
• Ability to work all shifts and / or locations assigned, directed, or necessary for this position, including (for some transit / operations roles) up to twenty-four (24) hours per day, seven (7) days per week as necessary to accommodate severe weather conditions, emergencies, or any other circumstances that may potentially impact service or the safety of service.
• Intern / co-op staff must be enrolled full or part-time in an accredited educational program and maintain a cumulative GPA of at least 2\.5 for the entire duration of the internship / co-op. Additionally, interns / co-ops must have valid work authorization and U.S. Social Security Number prior to starting pre-employment screenings / pre-boarding, working in their positions, and throughout the duration of their program.

Disclaimers and Definitions:

• General Disclaimer: The statements contained in this job description are intended to describe a summary, general nature, and complexity of typical job functions and do not represent an exhaustive list of all duties, tasks, and responsibilities required of staff assigned to this position.
• Application Completion: It is each applicant’s responsibility to ensure application details are entered completely and correctly, including updated work and education histories (past and current). Incomplete applications may not be considered. Attachments do not substitute for application fields. The recruitment team does not have access to existing employee data / history.
• Application Deadlines: Applicants should apply as soon as possible, as the MBTA may stop considering applicants after a sufficiently large applicant pool is established.
• Work Environment: The physical demands and work environment characteristics described here-in are representative of those an employee may encounter while performing the essential functions of this job. Reasonable accommodations can be made to enable individuals with disabilities to perform essential functions. See job description for role-specific requirements.
• Work Eligibility: All employees must be legally authorized to work in the United States and on an unrestricted basis. The MBTA does not have an employer work sponsorship program. However, if you have unrestricted work authorization, or are sponsored by a separate entity, you are welcome to apply. Further, all persons hired will require a U.S. Social Security Number prior to starting the position and employees will be required to complete a Form I-9 to verify their identity and eligibility to work in the U.S.
• Interviews: Candidates should ensure they arrive on time, are prepared, can remain for the duration, and if remote, are in a quiet place without distraction, for the interview. Candidates who do not attend their interview without advance authorization, including an email confirmation of a rescheduled time/date from Human Resources, will be considered a no-show and disqualified from consideration for the position. Related to rescheduling, on a one-time basis, and due to something emergent, you may be allowed to reschedule the interview. In addition, Human Resources may require documentation supporting the request. However, should you need to reschedule, you will need to contact your Recruiter directly by email.
• Safety Sensitive Positions: Employees working in this classification will be subject to periodic physical examinations plus random drug and alcohol testing.
• On-call or 24/7 Positions: Employees working in this classification must be available to respond to page / text / call and report to work as determined by assigned department or the Authority.
• Essential / Emergency Staff: During declared "states of emergency," employees working in this classification are required to report to work for their assigned work hours or as directed by management.
• ADA Accommodations: The MBTA makes reasonable accommodations for applicants with disabilities. If you require an accommodation during this process, please contact the MBTA's ADA Unit at 617-222-5751 or [email protected] .
• Diversity, Equity, and Inclusion: The MBTA is an Equal Employment Opportunity Employer . For terms, descriptions, and definitions related to diversity, equity, inclusion, veteran status, and immediate family members that you may find on the application form, please visit mbta.com/careers-app-definitions .
• Intern / Co-Op Benefits: Employees taking part in an internship or co-op at the MBTA are eligible to receive accrued paid sick leave as well as a monthly transportation pass, based on the city from which the intern / co-op commutes to work, at no cost. However, no additional benefits are currently offered for interns or co-ops.