Senior Data Analyst

## Description
**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
**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.