Full Job Description
Location: USA - Walton, Final Mile Blvd
Division: Solutions
Job Posting Title: Senior Manager, Business Analytics
Time Type: Full Time
25% travel is required for this role
POSITION SUMMARY
The Senior Manager, Business Analytics owns the reporting and analytics products for the High Tech 2 vertical of DSV Contract Logistics, supporting multiple client accounts and warehouse buildings across the Americas, and leading a team of Business Analysts. This role is the vertical's Power BI expert, building executive-level reports for directors and senior leadership, and operational tools that site teams use every day to manage SLAs, productivity, labor, inventory, and building performance.
Beyond reporting, the role works at the data layer: building and maintaining data pipelines, data models, and a single source of truth from WMS, LMS, TMS, and client data. The Senior BI Analyst sets the reporting standards for the vertical and turns operational data into insights that drive decisions.
ESSENTIAL DUTIES AND RESPONSIBILITIES
• Design, build, and maintain Power BI reports and dashboards for directors and senior leadership, focused on vertical-level performance, client SLAs, financial results, and trends.
• Build operational tools for 3PL site teams: daily and shift performance boards, backlog and wave visibility, labor planning, productivity (UPH) tracking, and exception reports.
• Own SLA and KPI reporting by client and building (on-time shipping, dock-to-stock, order accuracy, inventory accuracy, cycle count, receiving and putaway times), including scorecards for customer QBRs.
• Develop building performance scorecards that compare sites on safety, service, productivity, quality, inventory, and cost.
• Define and document KPI definitions, business logic, and calculation standards so every building measures performance the same way.
• Build and maintain data pipelines (ETL/ELT) from WMS, LMS, TMS, timekeeping, ERP, and client portals into a central data model, using Power Query, Dataflows, SQL, and Python.
• Design star-schema semantic models in Power BI with optimized DAX measures, incremental refresh, and composite models; tune performance on large datasets.
• Write and optimize SQL queries, views, and stored procedures; work in data warehouse or lakehouse environments (Azure SQL, Microsoft Fabric, Synapse, Snowflake, or similar).
• Administer Power BI Service: workspaces, deployment pipelines, gateways, scheduled refresh, row-level security, and access governance.
• Implement data quality checks, validation rules, and refresh monitoring; investigate and resolve data issues with site teams and IT.
• Automate recurring reports and manual processes (Power Automate, Python, scheduled queries) to free up time for site teams and leadership.
• Partner with Operations, Finance, Continuous Improvement, and Solutions Design on ad hoc analysis: root cause, capacity, labor, cost-to-serve, and client profitability.
• Support system migrations and new client launches by mapping data sources, rebuilding reports, and validating data accuracy.
• Translate business questions from directors and General Managers into clear requirements, data solutions, and actionable insights.
• Maintain documentation: data dictionary, data lineage, report catalog, and user guides.
• Train and support report users; mentor junior analysts and data clerks on Power BI, SQL, and reporting best practices.
• Follow DSV data governance, information security, and client confidentiality policies.
• Perform other duties as assigned.
REQUIRED SKILLS & COMPETENCIES
Education & Experience:
• Bachelor's degree in Industrial Engineering, Information Systems, Computer Science, Data Analytics, Supply Chain, or related field.
• 5+ years of experience in business intelligence, data analytics, or reporting, including at least 3 years building Power BI solutions in a production environment.
• 5+ years managerial experience
• Experience in 3PL, warehousing, contract logistics, or distribution operations strongly preferred.
• Proven experience building reports for director and executive audiences.
• Experience working with data from WMS, LMS, or TMS systems.
Computer Skills:
• Expert in Power BI Desktop and Service: DAX, Power Query (M), data modeling, row-level security, deployment pipelines, and incremental refresh.
• Advanced SQL (joins, CTEs, window functions, query tuning).
• Working knowledge of Python for data processing and automation (pandas).
• Experience with Microsoft Fabric, Azure Data Factory, Synapse, Databricks, or Snowflake a plus.
• Advanced Excel; Power Automate and SharePoint.
• Familiarity with WMS platforms (Manhattan, Blue Yonder, SAP EWM, or similar).
• Version control (Git) and DevOps practices for BI a plus.
Certificates & Licenses:
• Microsoft Certified: Power BI Data Analyst Associate (PL-300) preferred.
• Microsoft Certified: Fabric Analytics Engineer (DP-600) or Azure data certification a plus.
Language Skills
• English (reading, writing, verbal), Bilingual English/Spanish preferred.
Mathematical Skills
• Strong analytical and statistical skills: averages, variance, trends, forecasting, and outlier detection.
• Ability to calculate productivity, utilization, capacity, SLA attainment, and cost-per-unit metrics.
• Ability to build financial and operational models (cost-to-serve, labor, ROI).
Other Skills
• Data storytelling: turns complex data into clear, simple visuals and messages for directors.
• Strong business understanding of 3PL operations and client SLAs.
• High attention to detail and commitment to data accuracy.
• Works independently and manages multiple requests and priorities at once.
• Communicates clearly with both technical and non-technical audiences.
• Proactive in finding data issues before they reach leadership or the customer.
WORK ENVIRONMENT
Working Conditions Mixed office and operational environment
Physical Effort Sedentary: Primarily remaining in a stationary position (sitting or standing) for >50% of the time.
Mental Effort Sustained concentration and analytical effort
Other Regular Travel or Weekend/Overnight Shifts
For this position, the expected base pay range is $113,040.00 - $141,300.00 Annual. Actual compensation will be determined based on job-related factors such as relevant experience, skills, education, certifications, and geographic location, in accordance with applicable laws and company policy.
Information regarding DSV's benefits offerings, including eligibility, coverage options, and plan
details, is available through the DSV Benefits Showcase. Benefits, programs, and eligibility may vary by location and division in accordance with applicable state and local laws.