Microsoft Fabric Data Analyst

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

Join Arrivia, Inc. as a Microsoft Fabric Data Analyst in Salt Lake City, UT (onsite) and help teams move from data to decisions with governed, AI-enabled reporting. This role focuses on building trusted Power BI experiences on top of Microsoft Fabric data platform semantic models, so stakeholders get clear answers quickly and securely.

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 intuitive, clearly labeled report layouts.
• Write and optimize DAX measures that support the KPIs the business depends on.
• Gather, document, and refine reporting requirements in collaboration with business partners.
• Implement row-level and object-level security within semantic models to meet governance standards.
• Validate reports against source data to ensure accuracy and consistency.
• Create certified datasets and reusable templates so teams can answer their own questions.
• Participate in peer reviews of reports, DAX logic, and model design, and share improvements and learnings.
• Present findings and partner across teams to translate insights into action.
• Use AI tools to sharpen analysis, streamline work, and accelerate delivery.

Requirements

• 1 to 3 years building Power BI reports and dashboards in a professional setting.
• Hands-on Microsoft Fabric experience, including data modeling.
• AI experience with a demonstrated track record of using AI tools in day-to-day work.
• Working knowledge of DAX for measures, calculated columns, and time-intelligence functions.
• Strong data modeling fundamentals, including star schema, relationships, and cardinality.
• SQL experience to query relational sources and validate the data behind reports.
• Power Query and M for Import-mode transformations.
• Clear communication skills and the ability to collaborate across teams to present data and resolve issues.
• Bachelor’s degree in a related field (or equivalent experience).
• Experience aligned with membership or loyalty programs is a plus.
• DP-600 Microsoft Fabric Analytics Engineer Associate certification preferred and required within 12 months of hire.

Benefits

• Unlimited PTO
• Exclusive employee travel rates
• Travel discounts through Arrivia programs
• Medical, dental, and vision insurance
• 401(k) with company participation

Technologies: Microsoft Fabric, Power BI, Fabric semantic models, DirectLake, Import mode, DAX, SQL, Power Query, M, AI tools