Senior Data Analyst

Support the Director of Transportation in Railroad Operations in developing, analyzing, and reporting key material and service usage patterns in Commuter Rail, as well as develop and maintain key data infrastructure used by teams across the MBTA. Support the compliance review of operational deliverables by the commuter rail operator. Assist in developing a data culture both in the immediate team and across business and tech stakeholders.Manage internal and external reporting assigned by Management.Review and export operational data from TRMS.Understand MBTA rail operations, as well as that of Amtrak and tenant railroads on commuter rail.Develop, maintain, and innovate on critical data infrastructure for increasing data complexity, scale, and availability to support operational and executive decision making, and provide subject matter expertise.Understand stakeholder needs and develop data solutions and reporting to complex business questions, educating stakeholders on the meaning and implications of analysis.Address and root cause data warehouse and pipeline issues with a focus on sustainability of solutions and opportunities for automation.Explore strategies to improve efficiency and consistency of existing data structure and develop a plan to implement while minimizing effects to stakeholders.Partner with business leaders for data product design, KPI development, data simplification and ultimately aiding in achieving measurable business outcomes. Build trust in data integrity and reporting correctness.Perform analysis to support Operations decisions.Apply expertise in quantitative analysis, data mining, and the presentation of data. Capability to comply and explain complex information in easy-to-understand observations, reports, etc. with management.Adhere to the rules, regulations, collective bargaining agreements and policies of the Authority including the EEO, Anti-Discrimination and Anti-Harassment and Anti-Retaliation policies.Perform all other duties and projects that may be assigned.Bachelor's degree from an accredited institution in Mathematics, Statistics, Computer Science, Information Management, Industrial Engineering, or an analytical discipline.Four (4) years of experience in data analysis.Advanced use of basic office software, especially MS Excel and MS PowerPoint.Ability to use database and reporting packages (SQL, R, Python).Experience with data preparation and wrangling for use in visualization software (e.g., Python, Tableau Prep).Experience with organizing and visualizing data for efficient and effective storytelling to non-data stakeholders; experience working cross-functionally a plus.Experience working with, training, and mentoring other data analysts.Ability to quickly understand root business need of stakeholder requests, identify available data, and develop workable solution to proposed business question and communicate it to non-data stakeholders.Strong working knowledge of dimensional modeling principles, data warehousing and data vaults.Experience with code development and quality assurance testing concepts.General business concepts including operations, procurement, finance, engineering.Strong writing and communication skills; ability to present ideas clearly and concisely in both written and oral settings.Handle sensitive and confidential information in an appropriate manner.The ability to provide internal and external customers with a courteous and professional experience.The ability to work effectively with a diverse workforce.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 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.#J-18808-Ljbffr