Power BI Architect

Cloud & Data Engineering

Job Description:

Function

Roles & Responsibilities:

• Masters in Power
  
  BI, Finance Solution Data Architect with deep expertise in Supply Chain data and its intersection with Finance (Procure-to-Pay, Inventory Accounting, Costing, Cap Ex/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.
• 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).
• Architect domain‑aligned datasets for Procure‑to‑Pay, Inventory & Warehousing, Costing, Vendor & Spend, Logistics.
• Enable integration between supply chain events and finance outcomes (e.g., GR/IR, accruals, capitalization, write‑offs).
• 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, reference data, hierarchies.
• Partner with data engineering teams to implement ETL/ELT pipelines, orchestration, CI/CD, environment management.
• Perform performance tuning, partitioning, indexing, clustering strategies.
• Set up 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, procurement, inventory, supplier management, costing.
• Cloud & Data Tech Stack:
  Azure, Fabric/Synapse, Informatica/ADF/Fivetran/dbt/Airflow.
• 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).
• 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.

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.