ESSENTIAL DUTIES

Reporting & Dashboard Development

• Design, build, and maintain Power BI dashboards and reports for operations, finance, sales, and executive stakeholders.


• Develop and manage semantic data models in Power BI using DAX, including measures, calculated columns, and row-level security (RLS).


• Analyze and tune underperforming reports and queries to improve load times and reliability.


• Establish and document self-service BI standards and a shared metrics catalog.

Data & SQL

• Write complex T-SQL queries, CTEs, window functions, multi-table joins against Azure SQL and Microsoft Fabric.


• Collaborate with data engineers to define data requirements, validate pipeline outputs, and ensure data quality upstream of reporting.


• Identify data anomalies and inconsistencies; work upstream to resolve at the source rather than patching in reports.

Stakeholder Collaboration

• Partner with department leaders across operations, finance, and customer experience to translate business questions into measurable data products.


• Lead requirements-gathering sessions and translate ambiguous requests into defined scopes with clear deliverables and timelines.


• Communicate findings clearly to non-technical audiences — written, visual, and verbal.


• Contribute to special projects, operational improvement initiatives, and data-driven strategy efforts.

Team & Process

• Recommend and implement process improvements within the analytics function.


• Uphold data governance, security, and confidentiality standards across all reporting environments.


• Participate in sprint planning and contribute to team workflows using Azure DevOps or equivalent tooling.

Qualifications

Education

• Bachelor’s degree preferred in a quantitative field (Computer Science, Statistics, Mathematics, Information Systems).


• Equivalent professional experience (4+ years) accepted in lieu of degree.


• Transportation or logistics industry background is a strong plus.

Experience

• Required- 4+ years of hands-on experience in a BI, data analytics, or reporting analyst role.


• Required- Expert-level Power BI — semantic modeling, DAX (measures vs. calculated columns), RLS, gateways, and deployment pipelines.


• Required- Strong T-SQL — complex queries, CTEs, window functions, query optimization; experience with Azure SQL Database.


• Required - Proven ability to work with messy, multi-source operational data — not just clean, pre-modeled datasets.


• Preferred - Experience with Microsoft Fabric, Azure Synapse Analytics, OneLake architecture and Fabric lakehouses or warehouses or comparable cloud data platform.


• Preferred - Direct experience with McLeod TMS data preferred (orders, loads, lanes, drivers, invoicing).


• Preferred - Experience in logistics, transportation, supply chain, or a similarly operations-heavy industry.

Knowledge, Skills, & Abilities

• Ability to communicate complex data findings to non-technical stakeholders clearly and confidently.


• Ability to adapt and work in a fast-paced, operations-heavy environment.


• Strong problem-solving skills; comfortable working with ambiguous or incomplete requirements.


• Experience with ADF or analytics engineering practices for building and testing data models preferred.


• Python or R for exploratory analysis and data prep preferred.


• Azure DevOps or Git-based version control for BI asset deployment preferred.


• Power BI Premium / Fabric capacity management, workspace governance, and admin experience preferred.