Power BI & Microsoft Fabric Architect REMOTE

Power BI & Microsoft Fabric Architect REMOTE

Posted 2 weeks ago by 1750934434

Apply
Negotiable
Outside
Remote
USA
Apply
Business Intelligence Architecture Business Intelligence Tools Business Requirements Continuous Integration and Continuous Delivery Customer Demand Planning Data Architecture Data Engineering Data Masking Datamodel Data Modeling Data Security Data Visualisation DevOps Dimensional Modeling Key Performance Indicators (KPIs) Microsoft 365 Microsoft Azure Performance Tuning Power BI Powerquery Snowflake (Data Warehouse) Snowflake Schema SQL (Programming Language) Stakeholder Management Star Schema Workflows

Summary: We are looking for a Power BI and Microsoft Fabric Architect to spearhead enterprise-level analytics initiatives centered on supply chain data modeling. The candidate should possess extensive experience in Snowflake, star schema modeling, and the development of scalable data models and dashboards using Power BI and Microsoft Fabric. This role requires collaboration with business stakeholders and data engineering teams to optimize data analytics processes. The ideal candidate will also provide architectural leadership and mentorship to junior developers and analysts.

Key Responsibilities:

  • Architect and implement robust end-to-end data models for complex supply chain use cases using Microsoft Fabric and Power BI.
  • Build semantic layers and star schemas to enable intuitive and high-performance analytics.
  • Snowflake schema or Star Schema, other cloud/on-prem data sources, and Microsoft Fabric Lakehouses.
  • Design and manage scalable data pipelines, dataflows, and Fabric Lakehouse tables for structured and semi-structured data.
  • Collaborate with business stakeholders and data engineering teams to define KPIs, dimensions, and fact tables for supply chain analytics.
  • Develop optimized Power BI reports, dashboards, and paginated reports that deliver actionable business insights.
  • Define and enforce best practices for data modeling, governance, security (Row-Level Security), and performance tuning.
  • Provide architectural leadership and mentorship to Power BI developers and data analysts.

Key Skills:

  • 10+ years of experience in data analytics and BI architecture roles.
  • Deep expertise in Microsoft Power BI including DAX, Power Query, and data visualization techniques.
  • Hands-on experience with Microsoft Fabric components (Lakehouse, Data Factory, Synapse, Pipelines).
  • Strong background in Snowflake schema or Star Schema data architecture, performance tuning, and integration with analytics tools.
  • Expert in star schema design, dimensional modeling, and supply chain domain knowledge (inventory, procurement, demand planning, logistics, etc.).
  • Strong SQL skills and experience working with large datasets and distributed systems.
  • Experience implementing data security models, including RLS and data masking in BI tools.
  • Ability to translate complex business requirements into scalable technical solutions.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

We are seeking a highly skilled and strategic Power BI and Microsoft Fabric Architect to lead enterprise-level analytics initiatives focused on supply chain data modeling. The ideal candidate will have deep expertise in Snowflake, star schema modeling, and building scalable, performant data models and dashboards using Power BI and Microsoft Fabric.

Key Responsibilities:

  • Architect and implement robust end-to-end data models for complex supply chain use cases using Microsoft Fabric and Power BI.
  • Build semantic layers and star schemas to enable intuitive and high-performance analytics.
  • Snowflake schema or Star Schema, other cloud/on-prem data sources, and Microsoft Fabric Lakehouses.
  • Design and manage scalable data pipelines, dataflows, and Fabric Lakehouse tables for structured and semi-structured data.
  • Collaborate with business stakeholders and data engineering teams to define KPIs, dimensions, and fact tables for supply chain analytics.
  • Develop optimized Power BI reports, dashboards, and paginated reports that deliver actionable business insights.
  • Define and enforce best practices for data modeling, governance, security (Row-Level Security), and performance tuning.
  • Provide architectural leadership and mentorship to Power BI developers and data analysts.

Required Skills and Experience:

  • 10+ years of experience in data analytics and BI architecture roles.
  • Deep expertise in Microsoft Power BI including DAX, Power Query, and data visualization techniques.
  • Hands-on experience with Microsoft Fabric components (Lakehouse, Data Factory, Synapse, Pipelines).
  • Strong background in Snowflake schema or Star Schema data architecture, performance tuning, and integration with analytics tools.
  • Expert in star schema design, dimensional modeling, and supply chain domain knowledge (inventory, procurement, demand planning, logistics, etc.).
  • Strong SQL skills and experience working with large datasets and distributed systems.
  • Experience implementing data security models, including RLS and data masking in BI tools.
  • Ability to translate complex business requirements into scalable technical solutions.

Preferred Qualifications:

  • Microsoft certifications (Power BI, Azure Data Engineer, or Fabric Architect).
  • Experience with additional tools such as Azure Synapse, Databricks, or dbt.
  • Familiarity with Agile methodologies, DevOps for data/BI workflows, and CI/CD pipelines.

Apply
Similar Jobs
Loading data...