Power BI Migration Engineer

FEDRUS GLOBAL LLC; Phoenix (AZ); Hybrid; USD 110,000 - 160,000; Full time

Job summary

FEDRUS GLOBAL LLC is seeking a Power BI Migration Engineer to lead a strategic migration from SSRS to the cloud-based Power BI service and the Microsoft Fabric platform. You will redesign data models for cloud readiness, convert paginated outputs, and implement modern dashboards that maximize Fabric investments.

You will evaluate legacy reports, build enterprise-grade semantic models, and ensure secure, scalable data access across environments while coordinating with stakeholder teams during

Qualifications

• Bachelor's degree in a technical field is required.
• Proven track record migrating SSRS to Power BI Cloud / Fabric.
• Strong SQL, DAX, and Power Query (M) skills; data warehousing concepts understood.

Responsibilities

• Assess and plan SSRS to Power BI migration strategy.
• Convert SSRS reports to Power BI Paginated Reports and rebuild dashboards.
• Design and optimize Power BI semantic models using DAX and M.
• Deploy assets in Microsoft Fabric and manage cloud-based data sources.
• Ensure data security and governance with Fabric RBAC and RLS implementations.

Skills

Power BI

SSRS

DAX

Power Query (M)

SQL

Data warehousing

Education

Bachelor's degree in Computer Science / Information Systems / BI or related field

Tools

SSMS

Report Builder

Power BI Desktop

Job description

Job Title: Power BI Migration Engineer

Location: Remote with Occasional travel to Phoenix, AZ

First preference in Phoenix, AZ.

Job Summary

We are seeking a specialized Power BI Migration Engineer to lead the modernization of our legacy reporting infrastructure. In this role, you will drive the end-to-end migration of paginated reports from SQL Server Reporting Services (SSRS) to the cloud-based Power BI service / Microsoft Fabric platform. You will be responsible for evaluating legacy reports, redesigning data models for cloud compatibility, converting paginated outputs, and implementing modern interactive dashboards that maximize our Microsoft Fabric investment.

Key Responsibilities

• Migration Assessment: Evaluate the existing SSRS reporting catalog to catalog dependencies, identify redundancies, and plan the migration wave strategy.
• Report Conversion: Convert legacy SSRS RDL files into Power BI Paginated Reports and rebuild standard reports into interactive Power BI dashboards.
• Semantic Modeling: Design, build, and optimize enterprise-grade Power BI Semantic Models using DAX and Power Query (M formula language).
• Fabric Cloud Integration: Deploy and manage report assets within the Microsoft Fabric SaaS environment, utilizing Fabric workspaces, capacities, and deployment pipelines.
• Data Source Modernization: Transition legacy SQL queries and stored procedures into cloud-optimized data connections, leveraging Fabric Shortcuts, Lakehouses, or Data Warehouses where applicable.
• Security & Governance: Implement cloud-based data security standards, including Row-Level Security (RLS), Object-Level Security (OLS), and Fabric RBAC configurations.
• Gateway Management: Configure and maintain On-Premises Data Gateways to ensure secure, automated data refreshes between on-prem sources and the Fabric cloud.
• Testing & Validation: Conduct rigorous parallel testing between SSRS and Power BI to guarantee absolute data accuracy, alignment, and formatting consistency.

Required Skills & Qualifications

• Education: Bachelor's degree in Computer Science, Information Systems, Business Intelligence, or a related technical field.
• Migration Expertise: Proven track record of successfully executing at least one large-scale SSRS to Power BI Cloud / Fabric migration.
• Tech Stack Mastery:
• Legacy Stack: Deep expertise in SSRS, Report Builder, T‑SQL, stored procedures, and SQL Server Management Studio (SSMS).
• Cloud Stack: Advanced knowledge of the Power BI Service, Power BI Desktop, Power BI Paginated Report Builder, and Microsoft Fabric.
• Languages: Expert-level SQL and advanced proficiency in DAX and Power Query (M).
• Architecture Understanding: Strong grasp of standard data warehousing principles, star schemas, dimensional modeling, and cloud data platform architecture.
• Soft Skills: Strong analytical thinking, attention to detail, and the communication skills required to manage business stakeholder expectations during downtime or report layout changes.