Senior Data Analyst

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.