Power BI Migration Architect: SSRS to Fabric

Prodapt Solutions Private Limited; Richardson (TX); On-site; USD 110,000 - 160,000; Full time

Job summary

Prodapt seeks a specialized Power BI Migration Engineer to lead modernizing legacy reporting by migrating paginated reports from SSRS to Power BI Cloud / Fabric. You will redesign data models, convert outputs, and implement interactive dashboards to maximize Fabric investment.

Responsibilities include migration assessment, report conversion, semantic modeling with DAX and M, and ensuring data security and governance across cloud and on-prem data sources.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, BI or related field.
• Migration experience: proven track record migrating SSRS to Power BI Cloud / Fabric.
• Deep knowledge of SSRS, Report Builder, T-SQL, SSMS; cloud stack includes Power BI and Fabric.
• Strong SQL, DAX and Power Query (M) skills.
• Understanding of data warehousing, star schemas, and dimensional modeling.
• Strong analytical thinking and stakeholder communication skills during downtime or report changes.

Responsibilities

• Migration Assessment: catalog dependencies and plan migration wave.
• Report Conversion: convert SSRS to Power BI Paginated Reports and dashboards.
• Semantic Modeling: build enterprise-grade Power BI models with DAX and M.
• Fabric Cloud Integration: deploy within Microsoft Fabric environment.
• Data Source Modernization: move to cloud-optimized queries and data connections.
• Security & Governance: implement RLS/OLS and Fabric RBAC.
• Gateway Management: manage on-prem gateways for data refreshes.
• Testing & Validation: parallel testing SSRS vs Power BI for data accuracy.

Skills

SQL

DAX

Power Query (M)

Analytical thinking

Stakeholder communication

Education

Bachelor's degree in Computer Science, Information Systems, Business Intelligence, or related technical field

Tools

SSRS

Report Builder

SSMS

Power BI Desktop

Power BI Service

Paginated Report Builder

Microsoft Fabric

Job description

Prodapt seeks a specialized Power BI Migration Engineer to lead modernizing legacy reporting by migrating paginated reports from SSRS to Power BI Cloud / Fabric. You will redesign data models, convert outputs, and implement interactive dashboards to maximize Fabric investment.

Responsibilities include migration assessment, report conversion, semantic modeling with DAX and M, and ensuring data security and governance across cloud and on-prem data sources.