Job Role : Power BI Architect

Location : Wilmington, Delaware, United States (Onsite Hybrid) , _ Look for Locals as Primary and also the near by states candidates will work out here who can relocate.

Job description

Roles & Responsibilities: 

•   Masters in PowerBI, Finance Solution Data Architect with deep expertise in Supply Chain data and its intersection with Finance (Procure-to-Pay, Inventory Accounting, Costing, CapEx/OpEx, Vendor Spend Analytics).

•   The architect will lead the design of scalable data solutions that unify supply chain and finance data across ERP, procurement, logistics, inventory, and billing systems—enabling accurate reporting, forecasting, compliance, and operational insights. Data Architecture & Solution Design 

•   Own end-to-end data architecture for finance + supply chain analytics, reporting, and operational use-cases.

•   Define target-state architecture (lake house/warehouse, streaming, APIs, metadata) aligned to enterprise standards.

•   Design robust data ingestion and integration patterns (batch/stream, CDC, API-based, file-based).

•   Ensure architecture supports auditability, reconciliation, and financial controls (traceability from source to report). 

Supply Chain + Finance Domain Alignment 

•   Architect domain-aligned datasets for:

•   Procure-to-Pay (P2P): requisitions, purchase orders, invoices, payments

•   Inventory & Warehousing: receipts, transfers, adjustments, stock valuation

•   Costing: standard/actual costing, landed cost, freight, BOM where relevant

•   Vendor & Spend: vendor master, contracts, pricing, spend categorization

•   Logistics: shipment tracking, carrier costs, delivery performance

•   Enable integration between supply chain events and finance outcomes (e.g., GR/IR, accruals, capitalization, write-offs). Data Modeling & Semantics 

•   Create and maintain conceptual, logical, and physical data models (3NF, dimensional, Data Vault as applicable).

•   Define canonical models and enterprise semantic layers for KPI consistency.

•   Establish best practices for:

•   Master data (vendors, materials/items, locations, cost centers)

•   Reference data (currency, UOM, fiscal calendar, shipping terms)•   Hierarchies (product, supplier, org, region) 

Platform & Engineering Collaboration 

•   Partner with data engineering teams to implement:

•   ETL/ELT pipelines, orchestration, CI/CD, environment management

•   Performance tuning, partitioning, indexing, clustering strategies

•   Observability (logging, monitoring, SLA/SLI, cost optimization)

•   Enable governed self-service analytics through reusable datasets and thin-report architecture.  

Must Have Technical/Functional Skills: 

•   10+ years in data/solution architecture with strong ownership of enterprise-scale implementations.

•   Strong experience designing data warehouses/lake houses, enterprise integration, and analytics platforms.

•   Strong in data modeling (dimensional + normalized) and semantic layer design.

•   Strong understanding of business processes and data:Commercial operations , Logistics: shipment tracking, carrier costs, delivery performanceprocurement, inventory, logistics, supplier management, costing

•   Cloud & Data Tech Stack (choose based on your environment)

•   Cloud: Azure 

•   Data platforms: Fabric / Synapse

•   Data integration: Informatica / ADF / Fivetran / dbt / Airflow (any relevant)

•   Storage & formats: Parquet/Delta/Iceberg; S3/ADLS/GCS

•   Querying: advanced SQL; performance tuning; data partition strategies

•   Data governance: Collibra / Purview / Alation (or equivalent)