Fabric Data Analyst: Power BI, DAX & AI Reporting

Arrivia, Inc.; Salt Lake City (UT); On-site; USD 65,000 - 95,000; Full time

Benefits offered by this job

Unlimited PTO

Exclusive travel rates

Travel discounts through Arrivia

Medical, dental, and vision insurance

401(k) with company participation

Job summary

Arrivia, Inc. in Salt Lake City, UT is seeking a Microsoft Fabric Data Analyst to design, build, and publish Power BI reports that leverage Fabric semantic models, with DirectLake and Import modes.

You will translate business questions into data models, write DAX measures, set row- and object-level security, and validate reports against source data while creating reusable datasets and templates. This onsite role emphasizes governance, AI-assisted analysis, and collaboration across teams to drive

Qualifications

• 1–3 years building Power BI reports and dashboards in a professional setting.
• Hands-on Microsoft Fabric experience, including data modeling.
• AI experience with tools in day-to-day work.
• Working knowledge of DAX for measures and time-intelligence functions.
• Strong data modeling fundamentals: star schema, relationships, cardinality.
• SQL experience to query relational sources and validate data behind reports.
• Power Query and M for Import-mode transformations.
• Clear communication and cross-team collaboration.
• Bachelor’s degree or equivalent experience.

Responsibilities

• Design, build, and publish Power BI reports that consume Fabric semantic models using DirectLake and Import modes.
• Turn business questions into logical data models and clearly labeled report layouts.
• Write and optimize DAX measures to support KPIs.
• Gather, document, and refine reporting requirements with business partners.
• Implement row-level and object-level security within semantic models for governance.
• Validate reports against source data to ensure accuracy.
• Create certified datasets and reusable templates for self-service insights.
• Participate in peer reviews of reports, DAX logic, and model design.
• Present findings and translate insights into action across teams.
• Use AI tools to sharpen analysis, streamline work, and accelerate delivery.

Skills

Power BI

DAX

Data modeling

SQL

Power Query

M

AI tools

Communication

Collaboration

Education

Bachelor’s degree or equivalent experience

Tools

Microsoft Fabric

DirectLake

Import mode

Power BI

DAX

Power Query

M

DP-600 certification

Job description

Arrivia, Inc. in Salt Lake City, UT is seeking a Microsoft Fabric Data Analyst to design, build, and publish Power BI reports that leverage Fabric semantic models, with DirectLake and Import modes.

You will translate business questions into data models, write DAX measures, set row- and object-level security, and validate reports against source data while creating reusable datasets and templates. This onsite role emphasizes governance, AI-assisted analysis, and collaboration across teams to drive