Note: The job is a remote job and is open to candidates in USA. Radiant Digital is seeking a Road Maintenance Operations Subject Matter Expert to support winter road maintenance data, reporting, and decision-support initiatives. The role focuses on reviewing operational survey metrics, developing validation logic, building interactive Power BI or Esri dashboards, engaging transportation stakeholders, ensuring accessibility compliance, and validating and demonstrating the final solution.
Responsibilities
- Survey Instrument & Metrics Review: Review the historical ASSWMD multi-tabbed spreadsheets (2014–2025). Collaborate with the Project Manager to formulate targeted survey questions for Clear Roads member states that capture operational metrics while eliminating survey fatigue and ambiguity
- Operational Business Logic & Validation Engine: Define realistic validation constraints, bounding limits, and automated warning triggers for the web-based data collection portal (e.g., flagging salt application volumes that deviate significantly from reported lane miles or identifying unnormalized contract-labor costs) before submissions hit the database
- Dashboard UX & Interactive Map Architecture: Design and build the interactive choropleth maps, comparison charts, and multi-year trend dashboards in Power BI or Esri. Ensure the layout reproduces and enhances key views from legacy Excel tabs (e.g., 5-year running averages, year-over-year deltas, and state-to-state peer comparisons)
- Stakeholder Discovery & TAC Engagement: Participate in the Kick-off teleconference, quarterly check-in meetings, and beta testing review calls with the Clear Roads Technical Advisory Committee (TAC). Directly engage state maintenance directors to refine visual filters, operational definitions, and comparative metrics
- Accessibility Compliance: Implement accessible dashboard design patterns (colorblind-safe palettes, keyboard navigation, companion structured data tables) to fulfill State of Minnesota WCAG 2.0 Level AA accessibility standards
- Testing, Training, and Demonstration: Validate migrated historical survey data (2014–present) against legacy Excel tables to ensure zero data corruption. Author operational workflow sections of the User’s Guide and co-lead the final virtual demonstration webinar for Clear Roads member states
Skills
- Bachelor's degree in Civil Engineering, Transportation Engineering, Geographic Information Systems (GIS), Computer Science, Data Analytics, or Construction/Public Works Management
- An equivalent combination of an Associate degree with 7+ years of documented experience in state highway maintenance operations, maintenance decision support systems (MDSS), or transportation GIS data architecture will be considered
- Past working experience with the Department of Transportation / Clear Roads related to winter road maintenance operations
- Minimum 7 years blending transportation highway, winter road maintenance operations, and business intelligence reporting/data analysis
- Direct hands-on experience working with state, county, or municipal winter maintenance programs, fleet operations, or transportation research initiatives (e.g., Clear Roads, AASHTO Committee on Maintenance)
- Working familiarity with winter operations metrics: lane miles cleared, salt/sand storage, brine production/application rates, plow route cycle times, and maintenance budget structures
- Experience interpreting and correlating weather severity data (e.g., AWSSI indices) with material expenditures and staffing overtime
- Experience architecting, building, and deploying interactive, web-based reporting dashboards using Microsoft Power BI Embedded, ArcGIS Dashboards, or Esri Experience Builder
- Demonstrated ability to create choropleth maps, multi-variable trend charts, running multi-year averages, and comparative peer benchmarking displays
- Experience with data modeling, relational schemas, handling longitudinal survey datasets, and building automated export pipelines
Company Overview
Company H1B Sponsorship