Sr Business Analyst

ID Logistics US•Remote,

5d•$92,000 - $120,000•Remote

About The Position

The Senior Business Analyst builds reports, Power BI dashboards, and analyses to improve performance across complex warehouse and eCommerce operations. Working with Operations, Continuous Improvement, Finance, IT, and Data Engineering, the role turns operational data into reliable visibility and actionable recommendations that improve productivity, labor efficiency, capacity utilization, service, and overall operational performance. The position owns Power BI reporting solutions from requirements gathering and data preparation through modeling, visualization, testing, deployment, and ongoing support. It analyzes operational performance, investigates root causes, develops labor and capacity analyses, and works with business partners to recommend actions and validate results. The role also writes SQL, prepares reporting-ready datasets, establishes KPI definitions and data lineage, reconciles reporting to source systems, automates recurring reporting, and maintains refresh monitoring, documentation, testing, and change controls. The role supports daily, weekly, and monthly operational reviews; translates leadership questions into analytical requirements; develops understanding of warehouse processes; communicates findings to technical and non-technical audiences; and trains report users. It is remote, with a first-shift Monday–Friday schedule and flexibility based on business and operational needs. Periodic domestic site travel may be required, depending on business needs.

Requirements

Bachelor’s degree in Business Analytics, Information Systems, Supply Chain, Industrial Engineering, Computer Science, or a related field, or equivalent relevant experience.
At least 4 years of experience in business intelligence, operations analytics, or a related analytical role, including substantial hands-on development of reporting solutions used by business stakeholders.
Direct experience supporting 3PL, forward logistics, warehouse, distribution, or fulfillment operations.
Strong understanding of how material flow, labor deployment, activity mix, productivity, capacity, and service requirements affect operational performance.
Demonstrated ability to build production-quality reporting solutions from scratch using Power BI Desktop and Power BI Service.
Advanced experience with DAX, Power Query/M, semantic modeling, publishing, scheduled refresh, row-level security, and Power BI performance troubleshooting.
Strong SQL skills, including multi-table joins, common table expressions (CTEs), window functions, aggregations, and query troubleshooting.
Strong understanding of data grain, relational keys, fact and dimension models, filter behavior, and methods for preventing double-counting or misleading KPI calculations.
Ability to frame business questions, validate assumptions, investigate root causes, and translate analytical findings into practical business recommendations.
Strong communication skills and ability to explain technical findings and complex data to non-technical operational leaders and business partners.
Ability to work independently, manage competing priorities, self-review deliverables, and follow through on data or reporting issues.
Strong attention to accuracy and ability to handle company, customer, and employee information responsibly in accordance with established access and security requirements.
Strong Microsoft Excel skills for data validation, analysis, and ad hoc reporting.

Nice To Haves

Experience supporting high-volume eCommerce, fulfillment, distribution, or multi-site logistics operations.
Experience with Snowflake or comparable cloud-based data platforms.
Experience working with Warehouse Management Systems (WMS), Labor Management Systems (LMS), timekeeping systems, or other warehouse and operational technologies.
Experience with Power Automate, Python, or similar tools used to automate reporting and analytical processes.
Experience with labor planning, productivity improvement, process mapping, root-cause analysis, or continuous improvement initiatives.
Experience developing analytics and reporting for large-scale, complex fulfillment operations.
Microsoft Certified: Power BI Data Analyst Associate (PL-300) certification.

Responsibilities

Own Power BI reports and dashboards from requirements gathering and data preparation through modeling, visualization, testing, deployment, and ongoing support.
Build reusable reporting solutions that provide site-level visibility and consistent reporting across assigned operations.
Develop DAX measures, Power Query transformations, and efficient semantic models; manage report refresh, access, navigation, drill-down capabilities, and performance within established IT standards.
Analyze operational performance across volume, inbound and outbound activity, labor hours, productivity, overtime, staffing coverage, backlog, quality, capacity, and service levels.
Investigate performance drivers and root causes, distinguishing operational changes from data issues, activity-mix changes, and reporting inconsistencies.
Analyze labor requirements, capacity constraints, productivity opportunities, and operational improvements, including potential benefits and trade-offs.
Partner with Operations and Finance to recommend actions and validate results after implementation.
Write and optimize SQL to combine, transform, and validate approved data from warehouse, labor, timekeeping, and other relevant systems.
Build reporting-ready datasets and coordinate upstream data requirements with IT and Data Engineering.
Establish and document KPI definitions, source lineage, calculation logic, and reporting cutoffs.
Reconcile reporting to source systems and identify and resolve duplicate records, missing data, inconsistent mappings, and discrepancies in volume or labor-hour definitions before publication.
Automate recurring reporting by replacing avoidable manual data extraction, spreadsheet manipulation, and report distribution with repeatable, maintainable workflows.
Implement refresh monitoring, validation checks, and exception handling to help users identify stale, incomplete, or inaccurate information.
Maintain reporting documentation, testing, and change controls, and improve reports based on user feedback and business value.
Support reliable daily, weekly, and monthly operational reviews and retire redundant or low-value reporting when appropriate.
Translate questions from site and regional leaders into clear analytical requirements and prioritized reporting or analysis plans.
Develop an understanding of warehouse processes and validate analytical interpretations with the teams performing and managing the work.
Communicate findings, recommendations, risks, and limitations clearly to technical and non-technical audiences.
Train report users, support internal and customer-facing business reviews as needed, and partner with Finance and IT to promote consistent metrics and avoid duplicate reporting solutions.