Power BI Architect

Job Title : Power BI Architect
Location: Wilmington DE
Duration: Long Term

Job Description

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 performance
procurement, 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)
BI/Analytics: Power BI (data modeling, DAX, performance tuning, semantic layer design, governance, deployment pipelines)
This role requires strong data architecture, data modeling, integration design, governance, and hands-on experience with modern cloud data platforms and analytics.
Design semantic models in Power BI for enterprise-wide reuse, ensuring consistent KPI definitions.
Hands-on experience in DAX optimization, performance tuning, composite models, and security (RLS/OLS).
Implement workspace architecture, deployment pipelines, and governance best practices in Power BI.
Experience with real-time analytics, event streams, and near real-time dashboards for operational insights.

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.

Generic Managerial Skills, If any
Stakeholder Management & Delivery
Engage Finance, Supply Chain, Procurement, and IT stakeholders to translate needs into architecture.
Lead architecture reviews, technical documentation, and implementation roadmaps.
Work with program/product managers to define scope, milestones, dependencies, and risk mitigation

Education
Bachelor of Engineering/Computers