Power BI Architect-67189

Hitachids; Dover (DE); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Industry-leading benefits

Flexible arrangements

Support for health and wellbeing

Job summary

Hitachids is seeking a Finance Solution Data Architect in Dover, Delaware. The role focuses on designing scalable data solutions that integrate supply chain and finance data, enabling accurate reporting and operational insights. Candidates should have over 10 years of data architecture experience and strong expertise in Power BI.

Key responsibilities include leading architecture design, establishing data governance, and creating robust data models. The position offers a supportive environment with industry-leading benefits and flexible arrangements.

Qualifications

• 10+ years in data/solution architecture with strong ownership.
• Strong experience designing data warehouses/lake houses.
• Strong understanding of business processes in logistics and procurement.

Responsibilities

• Lead design of scalable data solutions for finance and supply chain.
• Define target-state architecture and integration patterns.
• Create and maintain conceptual, logical, and physical data models.

Skills

Data/Solution Architecture

Strong experience in data modeling

Advanced SQL performance tuning

BI/Analytics: Power BI

Cloud & Data Tech Stack

Education

Bachelor of Engineering/Computers

Tools

Power BI

Azure

Informatica

Job description

Dover, Delaware, United States of America

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.
• 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 (requisitions, purchase orders, invoices, payments).
• Architect domain‑aligned datasets for Inventory & Warehousing (receipts, transfers, adjustments, stock valuation).
• Architect domain‑aligned datasets for Costing (standard/actual costing, landed cost, freight, BOM where relevant).
• Architect domain‑aligned datasets for Vendor & Spend (vendor master, contracts, pricing, spend categorization).
• Architect domain‑aligned datasets for Logistics (shipment tracking, carrier costs, delivery performance).
• 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 (vendors, materials/items, locations, cost centers).
• Establish best practices for reference data (currency, UOM, fiscal calendar, shipping terms).
• Establish best practices for hierarchies (product, supplier, org, region).
• Partner with data engineering teams to implement ETL/ELT pipelines, orchestration, CI/CD, environment management.
• Partner with data engineering teams to implement performance tuning, partitioning, indexing, clustering strategies.
• Partner with data engineering teams to implement 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 experience in data modeling (dimensional + normalized) and semantic layer design.
• Strong understanding of business processes and data in commercial operations, logistics, procurement, inventory, supplier management, costing.
• Cloud & Data Tech Stack (choose based on your environment): Azure; Fabric / Synapse; 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).
• 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.

How we look after you

We help take care of your today and tomorrow with industry‑leading benefits, support, and services that look after your holistic health and wellbeing. We're also champions of life balance and offer flexible arrangements that work for you (role and location dependent). We're always looking for new ways of working that bring out our best, which leads to unexpected ideas. So here, you'll experience a sense of belonging, and discover autonomy, freedom, and ownership as you work alongside talented people you enjoy sharing knowledge with.

We're proud to say we're an equal opportunity employer and welcome all applicants for employment without attention to race, colour, religion, sex, sexual orientation, gender identity, national origin, veteran, age, disability status or any other protected characteristic. Should you need reasonable accommodations during the recruitment process, please let us know so that we can do our best to set you up for success.