Estrada Consulting Incorporated
Business Analyst / Transit Data SME (Ref: 5740)
Remote•United States•Contract
About the Job
Business Analyst / Transit Data SME (Ref: 5740)
Data Warehouse Modernization Project
Work Location: Remote, with availability during Pacific Time business hours
Employment Type: Part-Time or Full-Time Consultant, depending on project phase
Client Environment: Public-sector transportation / transit agency
Work Location: Remote, with availability during Pacific Time business hours
Employment Type: Part-Time or Full-Time Consultant, depending on project phase
Client Environment: Public-sector transportation / transit agency
Position Summary
Estrada Consulting, Inc. is seeking an experienced Business Analyst / Transit Data Subject Matter Expert to support a transportation data warehouse modernization project. This role will serve as the bridge between transit business stakeholders, technical data teams, reporting users, and project leadership.
The Business Analyst / Transit Data SME will help gather and validate business requirements, define transit data needs, document reporting and analytics use cases, support data mapping and data quality review, and ensure that the modernized data warehouse supports the agency’s operational, planning, ridership, performance, and executive reporting needs.
This position is ideal for a senior business analyst with strong transportation or transit agency experience, hands-on data project experience, and the ability to translate complex business processes into clear technical requirements for data warehouse, BI, dashboard, and analytics teams.
Key Responsibilities
Lead business analysis activities for transit data warehouse modernization, including requirements gathering, process analysis, stakeholder interviews, and documentation.
Work with transit agency stakeholders to understand business needs across areas such as ridership, fare collection, service planning, scheduling, operations, customer service, performance reporting, asset data, and executive dashboards.
Document business requirements, functional requirements, data requirements, report requirements, acceptance criteria, use cases, workflow diagrams, and data-related business rules.
Serve as a Transit Data SME by helping the technical team understand transit terminology, source systems, reporting expectations, operational processes, and key performance indicators.
Support data discovery and assessment activities, including review of current reports, dashboards, spreadsheets, source systems, data marts, legacy data structures, and manual reporting processes.
Assist with data mapping, source-to-target validation, business rule definition, and data quality review for transit-related data domains.
Help define and validate KPIs, measures, dimensions, filters, and reporting logic for dashboards and analytics deliverables.
Support data governance activities, including business glossary development, data ownership identification, data stewardship roles, metadata review, and lineage documentation.
Facilitate meetings and workshops with business users, technical teams, project leadership, and client stakeholders.
Review prototypes, dashboards, reports, data models, and requirements traceability to confirm alignment with business needs.
Support user acceptance testing by developing test scenarios, validating report outputs, documenting defects, and coordinating resolution with the technical team.
Assist with change management, training material input, user readiness, and operational handoff documentation.
Provide clear communication between business and technical teams to ensure the solution is usable, accurate, auditable, and aligned with the agency’s long-term data strategy.
Required Qualifications
Experience as a Business Analyst, Data Analyst, Transit Data SME, or similar role on transportation, transit, public-sector, or mobility-related projects.
Experience supporting data warehouse, business intelligence, reporting, dashboard, analytics, or data modernization projects.
Strong understanding of transit agency data and business processes, such as ridership, fares, routes, schedules, stops, service planning, operations, performance metrics, customer service, or transportation reporting.
Experience gathering and documenting business, functional, reporting, and data requirements.
Experience working with technical teams on data mapping, data validation, report logic, source system analysis, and data quality issues.
Ability to translate business needs into clear requirements for data engineers, architects, BI developers, and QA teams.
Experience supporting stakeholder workshops, interviews, requirement review sessions, and user acceptance testing.
Strong documentation skills, including requirements documents, meeting notes, decision logs, process flows, data dictionaries, report specifications, and test scenarios.
Ability to work independently and communicate effectively with executives, business users, technical staff, and project managers.
Mandatory Qualifications
Experience with transit data sources or standards such as fare collection systems, AVL/APC, CAD/AVL, GTFS, scheduling systems, route and stop data, passenger counts, service performance data, or ridership reporting.
Experience with Power BI, Tableau, SQL, data marts, cloud data platforms, or modern analytics environments.
Experience supporting data governance, metadata management, data cataloging, business glossaries, data lineage, or stewardship activities.
Experience working with public-sector transportation agencies, regional transportation authorities, transit districts, or mobility organizations.
Experience supporting modernization from legacy reporting environments, spreadsheets, manual reporting, or fragmented data sources into a centralized data warehouse or analytics platform.
Business Systems Analysis experience in gathering and documentation of technical and business requirements in Transportation
Business Systems Analysis experience in gathering and documentation of technical and business requirements in Transportation
Nice-to-Have Certifications
Certified Business Analysis Professional — CBAP
PMI Professional in Business Analysis — PMI-PBA
Agile / Scrum certification
Microsoft Certified: Power BI Data Analyst Associate — PL-300
DAMA Certified Data Management Professional — CDMP
ITIL Foundation
PMP or CAPM
PMI Professional in Business Analysis — PMI-PBA
Agile / Scrum certification
Microsoft Certified: Power BI Data Analyst Associate — PL-300
DAMA Certified Data Management Professional — CDMP
ITIL Foundation
PMP or CAPM
Key Skills
Business analysis
Transit data
Transportation reporting
Ridership analytics
Fare data
Service planning data
Operational reporting
Data warehouse modernization
BI and dashboard requirements
Data mapping
Source-to-target validation
Data quality
Data governance
Business glossary
Data lineage
Stakeholder facilitation
UAT support
Requirements traceability
KPI definition
Public-sector data projects
Transit data
Transportation reporting
Ridership analytics
Fare data
Service planning data
Operational reporting
Data warehouse modernization
BI and dashboard requirements
Data mapping
Source-to-target validation
Data quality
Data governance
Business glossary
Data lineage
Stakeholder facilitation
UAT support
Requirements traceability
KPI definition
Public-sector data projects
About Estrada Consulting Incorporated
Estrada Consulting, Inc. (ECI) delivers technology-enabled services and solutions to clients all over the USA and British Columbia. We provide system integration, custom application development, data warehouse and business intelligence, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters is in Sacramento, California, and was established in year 2000. Visit http://www.estradaci.com/ to learn about our projects, managed services, awards and certifications delivering value for a range of businesses and government agencies.