Power BI Solution Architect / Sr. Data Solution Architect

Power BI Solution Architect / Sr. Data Solution Architect/Consultant

Remote

Long Term Full Time Permanent Role

Onsite from Day 1

Must Have Technical/Functional Skills

• 15+ years in data/solution architecture with strong ownership of enterprise-scale implementations.
• Strong experience designing data warehouses/lakehouses, enterprise integration, and analytics platforms.
• Expert in data modeling (dimensional + normalized) and semantic layer design.
• Strong understanding of supply chain business processes and data:
• procurement, inventory, logistics, supplier management, costing
• Solid finance integration knowledge:
• GL mapping, accrual logic, inventory valuation, cost allocations, reconciliation
• Cloud & Data Tech Stack (choose based on your environment)
• Cloud: Azure / AWS / GCP (any one strong; multi-cloud is a plus)
• Data platforms: Snowflake / Databricks / BigQuery / Redshift / 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 / Tableau / Looker (semantic + KPI definitions)
• This role requires strong data architecture, data modeling, integration design, governance, and hands-on experience with modern cloud data platforms and analytics.

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 (lakehouse/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

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

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)

4) Data Governance, Quality & Controls

• Define and implement data governance: data ownership, stewardship, definitions, lineage, retention.
• Build data quality frameworks: rules, profiling, anomaly detection, completeness and reconciliation checks. Ensure compliance with privacy and security standards (PII/PCI/SOX-like controls where applicable). Drive processes for data issue management, root cause analysis, and remediation.

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)
• Guide design for self-service analytics and reusable data products.

Generic Managerial Skills, If any

6) 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/Computer

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.