Ensuring the right engineer arrives with the right skills, every time
Field service organisations live and die by their first-time fix rate. When an engineer arrives at a customer's door without the right qualifications or equipment, everybody loses: the customer is frustrated, the engineer's time is wasted, and the business absorbs the cost of a return visit. I built a real-time validation system that eliminates this problem at its root by automatically matching engineer qualifications against service requirements before any appointment is confirmed. The solution integrates Azure Maps for intelligent, location-based routing alongside a comprehensive skills matrix validated against live certification databases.
The system was designed to be both preventative and proactive. Rather than simply flagging mismatches after the fact, it intercepts scheduling decisions in real time, presenting dispatchers with only qualified and geographically optimal engineers for each job. Automated alerts notify management when certifications are approaching expiry, ensuring the workforce remains compliant without manual tracking. This combination of validation, routing, and compliance monitoring transformed how the organisation managed its field operations.
The results speak for themselves: a 95% first-time fix rate (up from 68%), a 70% reduction in failed appointments, and a 35% uplift in customer satisfaction scores. By ensuring that the right engineer with the right skills arrives at the right location every time, the business dramatically reduced operational waste, improved regulatory compliance, and delivered a consistently better customer experience.
The client was a mid-sized field service company managing a fleet of engineers across multiple disciplines, including gas safety, electrical, plumbing, and general maintenance. The scheduling process was almost entirely manual, relying on a small team of dispatchers who used spreadsheets and personal knowledge to assign engineers to jobs. This approach had worked when the company was smaller, but as the business grew, cracks began to appear.
Engineers were regularly being sent to jobs they were not qualified for. A plumbing engineer might arrive at a gas safety inspection, or an electrician whose certification had lapsed would be assigned to a compliance-critical job. These mismatches resulted in failed appointments that required costly return visits, and in some cases, exposed the company to regulatory violations and potential fines. The dispatchers knew the rules, but with dozens of engineers and hundreds of daily appointments, human error was inevitable.
Travel time was another major pain point. Without route optimisation, engineers were frequently criss-crossing service areas, burning fuel and losing productive hours. Customers were given vague arrival windows, and when engineers ran late due to poor routing, satisfaction scores suffered. The company was receiving an increasing volume of complaints, and repeat business was declining. Leadership recognised that a systematic, technology-driven approach was needed to restore operational discipline, ensure compliance, and rebuild customer trust.
The project followed a structured, stakeholder-driven methodology designed to capture domain expertise early and validate assumptions continuously throughout development.
1. Requirements Gathering — I conducted in-depth workshops with dispatchers, field engineers, and the compliance team to map every qualification rule in the business. This wasn't just about documenting what existed; it was about understanding the nuances that dispatchers carried in their heads. For example, certain gas safety inspections required not only a Gas Safe registration but also a specific appliance endorsement. These subtleties were critical to building a validation engine that dispatchers would actually trust.
2. Skills Matrix Design — With the rules documented, I designed a comprehensive data model in Dataverse that linked certifications, job types, and engineer profiles. Each engineer record captured their qualifications, certification expiry dates, competency levels, and geographic preferences. Each job type defined its mandatory and desirable qualifications, creating a flexible matching framework that could accommodate the full range of service scenarios.
3. Validation Engine — The core matching logic was implemented in Power FX within the Power Apps canvas app, handling the majority of qualification checks with minimal latency. For more complex validation rules, such as cross-referencing multiple certifications or checking regulatory database lookups, I built Azure Functions that the app called asynchronously. This hybrid approach kept the user experience responsive while supporting sophisticated business logic.
4. Map Integration — Azure Maps was integrated to provide geocoding of customer addresses, real-time route calculation between engineer locations and job sites, and travel time estimation that factored in traffic conditions. This data fed directly into the scheduling interface, enabling dispatchers to make informed decisions about which engineer could reach a customer quickest without sacrificing qualification compliance.
5. UI Development — I built a Power Apps canvas application that served as the dispatchers' primary scheduling tool. The interface featured a split-screen layout with the day's appointments on the left and an interactive map view on the right. Colour-coded indicators showed each engineer's qualification status at a glance: green for fully qualified, amber for approaching certification expiry, and red for disqualified. The design was intentionally simple, because the best validation system is one that dispatchers actually use.
6. Testing & Validation — Before go-live, I validated the system against six months of historical scheduling data to prove its accuracy. This back-testing identified appointments that would have been flagged as non-compliant, providing the compliance team with concrete evidence of the system's value. A two-week parallel running period ensured dispatchers were confident in the new tool before the legacy process was retired.
The solution architecture was designed for reliability, performance, and extensibility. At the front end, a Power Apps canvas application provides dispatchers with an intuitive scheduling interface featuring real-time map visualisation and qualification status indicators. Dataverse serves as the central data store, housing the skills matrix, engineer profiles, certification records, and appointment data with full relational integrity.
Azure Functions handle the heavier computational tasks: complex multi-factor validation logic, batch certification checks against external regulatory APIs, and route optimisation calculations that factor in multiple stops per engineer per day. Azure Maps provides geocoding, route planning, and real-time travel time estimation, with results cached to reduce API costs. Power Automate orchestrates the notification layer, sending automated alerts when certifications approach expiry, when a scheduling conflict is detected, or when a customer needs to be notified of their engineer's details and estimated arrival time.
The transformation was measurable within the first month of go-live. The first-time fix rate jumped from 68% to 95%, meaning that for every twenty appointments, nineteen were now resolved on the first visit. Failed appointments dropped by 70%, directly eliminating the cost of return visits and freeing up engineer capacity for revenue-generating work. Customer satisfaction scores improved by 35%, driven by both the reliability of the service and the transparency of the automated notifications that kept customers informed throughout the day.
What worked well: The Azure Maps API proved to be an excellent choice for route optimisation, providing reliable geocoding and travel time estimates that dispatchers quickly came to trust. Power FX handled the vast majority of the validation logic without needing to call out to Azure Functions, which kept the user experience snappy and reduced operational costs. Most importantly, working closely with dispatchers from day one ensured that the solution reflected how they actually worked, not how we assumed they worked. This collaborative approach was the single biggest factor in achieving high adoption rates from the first week.
What we would improve: The system currently requires a stable internet connection, which can be a limitation for engineers working in low-signal areas who need to check their schedules or update job statuses. Building offline capability with background sync would make the solution more resilient. We would also look to implement predictive scheduling using historical data and machine learning, allowing the system to anticipate demand patterns and pre-position engineers in high-activity areas before jobs are even booked. Finally, adding a customer self-service rebooking portal would reduce the administrative burden on dispatchers when appointments need to be rescheduled, putting control back in the customer's hands while maintaining all the qualification validation rules.
The return on investment for this project was both immediate and compounding. By eliminating costly return visits, the organisation saved an estimated several thousand pounds per month in wasted engineer time, fuel, and administrative overhead. Each failed appointment had previously cost the business not only the direct expenses of a second visit but also the opportunity cost of an engineer who could have been completing a revenue-generating job instead.
The compliance improvements were equally significant. With automated certification validation, the company moved from a reactive posture of discovering expired certifications after the fact to a proactive one where no unqualified engineer could be assigned to a regulated job. This dramatically reduced the risk of regulatory fines and audit failures, protecting both the business's licence to operate and its professional reputation.
Customer retention and referral rates improved measurably as a result of the higher first-time fix rate and the transparency of the automated notification system. Happier customers stayed longer and recommended the service more frequently, contributing to organic revenue growth. Engineers themselves reported higher job satisfaction, as they were no longer being sent to jobs they could not complete. Finally, the data captured by the system provided management with actionable insights into workforce planning, enabling targeted training investment and more informed hiring decisions based on actual skills gaps rather than guesswork.
I help field service organisations optimise their scheduling and ensure compliance through intelligent automation. Let's discuss how I can improve your first-time fix rate.
Get in Touch