MacroSys partners with the Federal Transit Administration (FTA) to help more than 3,000 public transportation agencies nationwide produce and report reliable transit data. Behind every published data product is a steady rhythm of communication, coordination, and problem solving. By combining a dedicated team with effective tools and resources, we ensure that even within this complex data program, the public consistently receives timely and trustworthy information.

Each analyst carefully reviews hundreds of report submissions each year, working directly with their assigned agencies to resolve issues, stay aligned, and keep the entire team informed through consistent communication. With regular outreach, we make it easy for agencies to stay connected and understand what’s needed while giving them access to in-depth training and a wide range of helpful resources. By providing clear, standardized guidance through annually updated NTD policy manuals, the NTD Uniform System of Accounts, and step-by-step instructions for navigating Appian, we help agencies confidently complete monthly and annual reports. Depending on the size of the agency, these reports can include anywhere from fewer than 10 forms to more than 100. After multiple rounds of collaboration and quality assurance, the final data are published, ensuring decision-makers have accurate, high-quality information each year.

Throughout the year-long journey from data collection to final publication, MacroSys focuses on making every step more efficient. We streamline workflows, simplify operations, and strengthen team productivity with the goal of driving contract growth. An analyst’s success in managing their caseload really comes down to the strength of the team behind them. Our internal tools and reference materials—built with SQL, Power BI, and Microsoft 365, and maintained and organized through SharePoint—play a major role in supporting rigorous validation across hundreds of data points. Real-time collaboration keeps everyone aligned through task tracking in JIRA and a detailed, always-current caseload sheet, that keeps the validation process progressing seamlessly. Structured annual training, regular check-ins and meetings, and the support of the NTD Help Desk ensure continuous learning, open communication, and a more connected team.