Route Genie Transportation Analytics Lead

Colonial Group; Trevose (PA); Remote; USD 70,000 - 100,000; Full time

Job summary

Active Day is hiring a Transportation Technology Business Analyst to serve as the Route Genie SME, owning system configuration, data, and reporting for the enterprise transportation network. You will support ongoing rollout, training, and user adoption across Transportation Operations, Centers, IT, Finance, and Data/Analytics.

The role requires strong data analysis skills, Excel expertise, and experience with Route Genie, Power BI, SQL, and APIs.

Qualifications

• HS Diploma required; Bachelor’s strongly preferred in Business, IS, Analytics, Supply Chain, Transportation, Operations, or related field.
• Minimum 3 years in business/ systems analysis, transportation tech, logistics, or related field.
• Strong Excel skills and experience with data analysis, reporting, and presenting to leadership.

Responsibilities

• Own Route Genie system as SME; manage configuration, data, reporting, and user support.
• Support enterprise rollout; develop plans, readiness, data needs, testing, training, go‑live checklists.
• Develop standardized role‑based training for coordinators, dispatchers, drivers, and directors.
• Ensure data integrity; establish enterprise data standards and conduct routine audits.
• Create recurring reports and dashboards on performance, utilization, and cost.
• Analyze routes, capacity, and utilization to improve efficiency while maintaining service quality.
• Monitor adoption and compliance; recommend retraining and establish minimum standards.
• Collaborate with Transportation, Operations, IT, Data/Analytics, Finance, Safety, and HR.

Skills

Analytical skills

Excel proficiency

Data analysis & reporting

Communication skills

Project management

Training users

Detail oriented

Systems thinking

SQL

Power BI

APIs

Education

HS Diploma

Bachelor’s degree in Business/Information Systems/Analytics/Supply Chain/Transportation/Operations

Tools

Route Genie

Power BI

SQL

APIs

Job description

Active Day is hiring a Transportation Technology Business Analyst to serve as the Route Genie SME, owning system configuration, data, and reporting for the enterprise transportation network. You will support ongoing rollout, training, and user adoption across Transportation Operations, Centers, IT, Finance, and Data/Analytics.

The role requires strong data analysis skills, Excel expertise, and experience with Route Genie, Power BI, SQL, and APIs.