> Markdown version of [/jobs/ext/2118455-power-bi-architect](https://www.wearedevelopers.com/jobs/ext/2118455-power-bi-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Power BI Architect - **Company:** Hitachi, Ltd. - **Location:** Wilmington, DE, United States - **Experience:** Expert - **Salary:** $142,500.0 - $190,000.0 - **Contract:** Permanent contract - **Skills:** Third Normal Form, Application Programming Interfaces (APIs), Airflow, Amazon S3, Business Analytics Applications, Data Analysis, Microsoft Azure, Cloud Computing, Continuous Integration, Data Architecture, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Vault Modeling, Desktop Computing, Metadata, Performance Tuning, Reference Data, Power BI, Data Streaming, Parquet, Data Logging, Data Ingestion, Sql Optimization, Delivery Pipeline, Indexer, Collibra, Enterprise Integration, Integration Frameworks, Data Management, Physical Data Models, Api Design, Stream Analytics, Data Pipelines - **Published:** August 19, 2026 - **Apply:** https://www.careerjet.com/job/use109cfb34cf89074786f1cb9f1c9cc1a/eaa ## About the Role * 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 ## Description Imagine the sheer breadth of talent it takes to bring a better tomorrow closer to today. We don't expect you to 'fit' every requirement - your life experience, character, perspective, and passion for achieving great things in the world are equally as important to us. 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., 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. 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 ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Stephan Gillich - Bringing AI Everywhere](https://www.wearedevelopers.com/magazine/489-stephan-gillich-bringing-ai-everywhere) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)