SQL Reporting & Business Analytics Expert Needed (Operations & Field Services)

Advanced SQL expertise (complex joins, transformations, performance optimization) Experience building business analytics & operational dashboards Strong understanding of data modeling & reporting logic Ability to work with imperfect or fragmented data Experience in operations, logistics, or field services (big plus) Zoho Analytics / Zoho CRM / Zoho FSM experience (nice to have) Experience working with ERP or dispatch systems (nice to have)

Review existing datasets and reporting structure Redesign data models to support operational, financial, and performance metrics Write optimized SQL queries to pull, join, and transform data Build dashboards reflecting operational performance Create metrics for job volume, technician productivity, revenue, and costs Ensure reports are accurate, consistent, and automation-ready Identify missing fields, broken joins, and incorrect calculations Normalize data coming from multiple systems Validate outputs with real operational scenarios Ensure reporting structure supports growth and higher volume Improve query performance and refresh reliability Reduce manual reporting dependency