About Us
Billor is building the largest Trucking Ecosystem in the United States, combining Freight and Technology for Truck Drivers, Freight Brokers, and Autonomous Trucks, creating higher efficiency, stronger margins, and a more connected supply chain.
About the role
We are looking for a Data Analyst to join the Data Team at Billor Technology. This is an analytical role first and foremost: you will investigate data, surface insights, and deliver recommendations that drive business decisions across the organization.
You will work closely with stakeholders in Operations, Finance, Commercial, and other departments, but your primary output is not requirement gathering: it is analysis. That means writing SQL to explore hypotheses, building dashboards that tell a clear story, monitoring data quality, and proactively flagging anomalies or opportunities before someone asks.
The ideal candidate is strong in SQL and BI tooling, comfortable navigating a medallion architecture (bronze/silver/gold), and has the statistical intuition to know when a number doesn’t make sense. You should be able to go from a vague business question to a structured analysis with clear takeaways.
Key Responsibilities
- Conduct exploratory and ad-hoc analyses to answer business questions, test hypotheses, and deliver actionable recommendations with clear data storytelling
- Build and maintain dashboards in Looker Studio and Looker Enterprise with self-service in mind, training stakeholders to reduce dependency on the data team
- Write and optimize SQL queries in BigQuery across the medallion architecture (bronze/silver/gold), creating gold-layer views that serve as single sources of truth
- Monitor data freshness, completeness, and consistency; proactively flag anomalies and validate outputs against business expectations
- Document metric definitions, business rules, and transformation logic to ensure consistency and reproducibility across the organization
- Collaborate cross-functionally with Operations, Finance, and Commercial to translate business questions into structured analytical approaches
Examples of Day-to-Day Activities
- A director asks why dispatcher margins dropped: you segment by dispatcher/lane/client, identify the root cause, and present the finding with a recommendation
- You notice fuel cost per mile trending up: without being asked, you run a breakdown by network, region, and driver, then share the analysis with Finance
- A report shows wrong numbers: you trace the query through bronze/silver/gold layers, find a join producing duplicates from overlapping contract dates, and fix it
- Leadership defines a new KPI: you document the business logic, validate data sources, implement the metric in SQL, and surface it in a Looker dashboard
- Multiple teams keep requesting similar data: you propose a gold-layer standardized view and enable self-service access through Looker explores