Senior Data Analyst

ESSENTIAL DUTIESReporting & Dashboard DevelopmentDesign, 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 CollaborationPartner 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 & ProcessRecommend 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.QUALIFICATIONSEducationBachelor’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.ExperienceRequired- 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, & AbilitiesAbility 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. #J-18808-Ljbffr