Power BI & Microsoft Fabric Architect – Supply Chain Data Modeling

Cartol; United States; Remote; USD 88,000 - 221,000; Full time

Job summary

A leading company is looking for a skilled Power BI & Microsoft Fabric Architect to drive analytics initiatives focused on supply chain data modeling. This role requires deep expertise in data architecture, visualization techniques, and collaboration with stakeholders to enhance analytics capabilities through innovative data solutions. Candidates should possess 10+ years of relevant experience and a strong foundation in Microsoft tools and methodologies.

Qualifications

• 10+ years in data analytics and BI architecture roles.
• Deep expertise in Microsoft Power BI and DAX.
• Experience with Microsoft Fabric components.

Responsibilities

• Architect robust data models for supply chain analytics.
• Design scalable data pipelines and Fabric Lakehouse tables.
• Collaborate to define KPIs and performance tuning best practices.

Skills

Snowflake

Dimensional Modeling

Microsoft Fabric

Power BI

SQL

Data Security Models

Agile

Data Visualization

Tools

Azure Synapse

Databricks

dbt

Job description

Power BI & Microsoft Fabric Architect – Supply Chain Data Modeling

Job Title: Power BI & Microsoft Fabric Architect – Supply Chain Data Modeling

Location: Remote

Job Type: Contract

Job Description

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.
  
  

Skills: snowflake,databricks,schema,dbt,dimensional modeling,microsoft fabric,azure synapse,rls,power query,microsoft,sql,agile,power bi,data security models,dax,data visualization,star,star schema,data engineering

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Business Development and Sales

• Industries

  Software Development

Referrals increase your chances of interviewing at Cartol by 2x

Get notified about new Business Intelligence Specialist jobs in United States.

United States $121,800 - $220,300 3 weeks ago

United States $88,000 - $144,000 1 week ago

United States $130,000 - $150,000 1 week ago

Business Intelligence Analyst - Qlik Sense

United States $80,000 - $100,000 12 hours ago

Washington, DC $62,000 - $141,000 11 hours ago

Reporting & Insights Analyst - Commercial

United States $64,000 - $90,000 2 weeks ago

United States $75,000 - $100,000 1 week ago

United States $150,000 - $213,000 6 days ago

United States $81,000 - $102,000 5 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.