Power BI Migration Engineer

Prodapt

$110K — $130K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Business Intelligence, or related field.
  • Proven track record of executing large-scale migrations from SSRS to Power BI Cloud.
  • Deep expertise in legacy reporting tools like SSRS and T-SQL, along with SQL Server Management Studio (SSMS).
  • Advanced knowledge of Power BI tools and Microsoft Fabric platform.
  • Expert-level skills in SQL, and proficiency in DAX and Power Query (M).
  • Strong grasp of data warehousing principles and cloud data architecture.
  • Excellent analytical skills and communication abilities for managing stakeholder expectations.

Responsibilities

  • Evaluate existing SSRS reports to plan migration strategy and identify redundancies.
  • Convert SSRS RDL files to Power BI Paginated Reports and redesign standard reports as interactive dashboards.
  • Design and optimize Power BI Semantic Models using DAX and M formula language.
  • Deploy and manage report assets within the Microsoft Fabric environment using workspaces and pipelines.
  • Modernize data sources by transitioning legacy SQL queries to cloud-optimized connections.
  • Implement data security standards including Row-Level Security and Object-Level Security.
  • Configure and maintain secure On-Premises Data Gateways for automated data refreshes.

Benefits

  • Opportunity to lead a significant reporting modernization project.
  • Work with the latest technologies in cloud-based BI solutions.
  • Collaborative environment with a focus on stakeholder engagement.
  • Potential for professional growth in a high-demand field.
  • Exposure to enterprise-grade data architecture and design.
Full Job Description
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. Responsibilities 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. Requirements 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.

Similar Jobs

More Jobs at Prodapt

More Information Technology Jobs

Find similar Power BI Migration Engineer jobs: