Sr Business Analyst

Id-Logistics; United States; Remote; USD 92,000 - 120,000; Full time

Benefits offered by this job

401K with company match

Medical insurance

Dental insurance

Vision insurance

Generous PTO & holidays

Job summary

ID Logistics is seeking a Senior Business Analyst to own Power BI reports and dashboards from requirements gathering to modeling, visualization, testing and deployment, across warehouse and eCommerce operations. You will partner with Operations, Finance, IT and Data Engineering to transform data into reliable visibility and actionable recommendations that improve productivity and service levels.

Remote work with periodic travel, competitive salary ($92,000-$120,000) and a comprehensive benefits

Qualifications

• Bachelor’s degree or equivalent experience in a related field.
• 4+ years in BI or operations analytics with reporting solutions.
• Direct experience supporting 3PL/warehouse/logistics operations.
• Strong understanding of how labor, capacity, and service drive performance.
• Production-quality reporting from Power BI Desktop and Service.

Responsibilities

• Own Power BI reports and dashboards from requirements gathering through deployment and support.
• Build reusable reporting solutions with site-level visibility and consistent reporting.
• Develop DAX measures, Power Query transformations, and semantic models with efficient refresh and access controls.
• Analyze operational performance across volume, labor hours, productivity, capacity, and service levels.
• Translate analytical findings into practical business recommendations for Operations and Finance.

Skills

Power BI

SQL

DAX

Power Query

Semantic modeling

Excel

Education

Bachelor’s degree in Business Analytics, Information Systems, Supply Chain, Industrial Engineering, Computer Science, or related field

Job description

As the Senior Business Analyst, you will build the reports, Power BI dashboards, and analyses that help improve performance across complex warehouse and eCommerce operations. Partnering with Operations, Continuous Improvement, Finance, IT, and Data Engineering, you will transform operational data into reliable visibility and actionable recommendations that improve productivity, labor efficiency, capacity utilization, service, and overall operational performance.

Work Location: Remote

Work Schedule: First Shift: Monday–Friday, with flexibility based on business and operational needs.

Work Travel: Periodic domestic site travel depending on the needs of the business and subject to change.

Competitive Compensation: Attractive annual salary of $92,000-$120,000, performance-based bonus, and comprehensive benefits including medical, dental, and vision insurance, 401(k) with company match, generous PTO, sick time, and company holidays. Compensation is based on experience, skills, and education.

This position is not eligible for immigration sponsorship.

Key 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 while supporting consistent reporting across assigned operations.

Develop DAX measures, Power Query transformations, and efficient semantic models while managing 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 identify root causes by distinguishing true operational changes from data issues, activity-mix changes, or reporting inconsistencies.

Develop analyses of labor requirements, capacity constraints, productivity opportunities, and operational improvements, including quantifying potential benefits and trade-offs.

Partner with Operations and Finance to recommend actions and validate results following 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 consistent 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 information is published.

Automate recurring reporting by replacing avoidable manual data extraction, spreadsheet manipulation, and report distribution with repeatable and maintainable workflows.

Implement refresh monitoring, validation checks, and exception handling to help users quickly identify stale, incomplete, or inaccurate information.

Maintain reporting documentation, testing, and change controls while continuously improving 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 a strong understanding of warehouse processes and validate analytical interpretations with the teams performing and managing the work.

Communicate findings, recommendations, risks, and limitations in clear language that both technical and non-technical audiences can understand and use.

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.

#LI-SALARY

Requirements

Bachelor’s degree in Business Analytics, Information Systems, Supply Chain, Industrial Engineering, Computer Science, or a related field, or equivalent relevant experience.

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 impact 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 experience with 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 with the 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 the ability to responsibly handle company, customer, and employee information in accordance with established access and security requirements.

Strong Microsoft Excel skills for data validation, analysis, and ad hoc reporting.

Preferred Qualifications

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.

Total Rewards

ID Logistics offers a generous benefits package for eligible associates to include 401K with match, Health, Vision, Dental and vacation and sick time, among other competitive benefits. Compensation is determined based on several factors, including but no

Schedule

First Shift

SafetySensitive

No

undefined

Employer Privacy Policy

EEO is The Law - click here for more information

Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the number below.

1-888-773-5263

EEO is the Law

ADP Privacy Statement Artificial Intelligence Google Privacy Policy Google Terms of Service