Senior BI Reporting Developer

Senior BI Reporting Developer

6- 9 Months Contract possible extension

Location: Onsite Vienna, VA

Work Arrangement: Onsite
Local candidates required within 40 miles
Onsite interview required

Job description:

Needs Senior BI Reporting Developer, Supply Chain and Manufacturing, This person builds operational compliance dashboards on warehouse management data for a client.

Key responsibilities

• Run discovery workshops with operations leadership, DC managers, inventory control, food safety and finance.
• Turn them into a signed-off metric catalogue with definitions, thresholds, targets and audiences.
• Profile warehouse data across live sites (inventory ledger, movements, counts, discrepancies, in-process logs) and write a data readiness report that flags gaps.
• Design and build a dimensional reporting model with conformed user, shift, site, item, lot, location and transaction-type dimensions.
• Build Power BI dashboards and reports: supervisor views by user and shift, DC scorecards, an enterprise roll-up, and exception lists that drill down to the individual transaction.
• Write performant SQL and DAX for metrics with time windows, aging and ratios (for example, quantity auto-created as a share of quantity shipped).
• Set up refresh, row-level security and workspace deployment on the client's reporting platform.
• Validate the numbers with DC operations, tune thresholds and support user acceptance testing.
• Hand over metric definitions, technical documentation and training for supervisors and managers.
• Report progress and hours burned against the agreed bucket to the ESF Delivery Manager each week.

Required skills and experience

• 10+ years of professional experience, including 6+ years in business intelligence, reporting or analytics engineering
• 3+ years building production Power BI solutions: data modelling, advanced DAX, Power Query, row-level security, incremental refresh and workspace deployment
• Strong SQL on Azure SQL or SQL Server: complex joins, window functions, query tuning
• Dimensional modelling (star schemas, conformed dimensions, slowly changing dimensions)
• Hands-on Microsoft Fabric or Azure data stack (Lakehouse or Warehouse, Data Factory or Synapse pipelines)
• Has led requirements or KPI-definition workshops with business users and turned them into signed-off metric definitions
• Experience with operational or transactional data, ideally warehouse, supply chain, manufacturing or retail
• Clear written and spoken English for working directly with US and Canadian operations stakeholders

Nice to have

• Warehouse management system data (Blue Yonder / JDA, Manhattan, SAP EWM or a custom WMS): receiving, putaway, picking, cycle counts, adjustments, holds
• Familiarity with distribution centre KPIs such as dock-to-stock time, inventory record accuracy and order picking accuracy (for example, WERC DC Measures)
• Food or fresh produce supply chain, including lot traceability (FEFO / FIFO, FSMA 204)
• Microsoft Dynamics NAV / Business Central data
• Azure DevOps, Git and deployment pipelines for Power BI or Fabric
• Microsoft certifications: PL-300 (Power BI Data Analyst) or DP-600 (Fabric Analytics Engineer)