Power BI & Microsoft Fabric Architect – Supply Chain Data Modeling

Falcon Smart IT (FalconSmartIT); United States; Remote; USD 88,000 - 144,000; Full time

Job summary

A leading company is seeking a skilled Power BI & Microsoft Fabric Architect specializing in supply chain data modeling. The role requires extensive expertise in data analytics, with key responsibilities including the design of robust data models and collaboration with stakeholders. Ideal candidates will have significant experience with Microsoft Power BI, Snowflake schemas, and the ability to create intuitive analytics solutions. This is a contract position offering competitive salaries based on experience and qualifications.

Qualifications

• 10+ years of experience in data analytics and BI architecture.
• Deep expertise in Power BI including DAX and Power Query.
• Strong SQL skills and experience with large datasets.

Responsibilities

• Architect and implement data models for supply chain analytics.
• Collaborate with business stakeholders to define KPIs.
• Develop optimized Power BI reports and dashboards.

Skills

Power BI

Data Analytics

SQL

Data Modeling

Snowflake Schema

DAX

Data Visualization

Education

Microsoft Certifications (Power BI, Azure Data Engineer, Fabric Architect)

Tools

Microsoft Fabric

Azure Synapse

Databricks

Job description

Power BI & Microsoft Fabric Architect – Supply Chain Data Modeling

3 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Falcon Smart IT (FalconSmartIT)

Talent Acquisition | Hiring Technical Experts |Let's turn your resume into your strongest advocate. Send it my way ([e-mail]) and…

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

Location: Remote

Job Type: Contract

Job Description:

Job Summary:

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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Falcon Smart IT (FalconSmartIT) by 2x

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

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

United States $121,800 - $220,300 1 day ago

Business Intelligence Analyst - Qlik Sense

United States $80,000 - $100,000 1 day ago

United States $130,000 - $150,000 2 weeks ago

Washington, DC $62,000 - $141,000 1 day ago

United States $106,500 - $156,925 2 weeks ago

Senior Business Intelligence Analyst (Remote - US)

Business Intelligence Reporting Analyst / Remote / PowerBI / SQL

PowerBI Technical Administrator (Remote)

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

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