Power BI Architect
DE/Wilmington- client site 5 days wk at client site

Solution Architecture
Cloud & Data Tech Stac

Do you have 10+ years in data/solution architecture with strong ownership of enterprise-scale implementations?
Do you have Strong experience designing data warehouses/lake houses, enterprise integration, and analytics platforms?

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).

2) Supply Chain + Finance Domain Alignment
• rchitect 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).

3) 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)

5) 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