Data Warehouse Engineer

Job Title: Data Warehouse Engineer
Overview
We are looking for a Data Warehouse Engineer to build and maintain a Snowflake-based analytics platform that supports operational and financial reporting. This role will work closely with business stakeholders to turn complex data into reliable, analytics-ready datasets.
What You'll Do
Design, build, and maintain fact and dimension tables (routes, services, revenue, costs)
Develop and manage dbt models following best practices (raw → staging → marts), including tests and documentation
Integrate and transform data from multiple sources such as Navusoft, Samsara, Salesforce, and AVP
Model and maintain key business KPIs, including:
Route performance
Service completion
Revenue and margins
Fuel and operational costs
Create and optimize analytics-ready datasets to support Power BI dashboards and reporting
Collaborate with stakeholders to translate business processes into scalable analytics models
Ensure dat...