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 & SQLWrite 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 Dev Ops 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, One Lake architecture and Fabric lake houses 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 Dev Ops or Git-based version control for BI asset deployment preferred.

Power BI Premium / Fabric capacity management, workspace governance, and admin experience preferred.
#J-18808-Ljbffr