Role description

Onshore Power BI Lead SSRS to Power BI Migration

Location Cincinnati,OH Onsite

Onshore Clientfacing role

Role Summary

The Onshore Power BI Lead will be responsible for leading enterprisescale migration of legacy SSRS reports to Power BI owning endtoend delivery from assessment and design through migration validation and stakeholder signoff This role acts as the primary onshore interface for business IT leadership and offshore delivery teams ensuring solution quality performance and adoption

Key Responsibilities

Program Technical Leadership

Lead largescale SSRS to Power BI migration initiatives including report rationalization redesign and modernization

Define migration strategy roadmap and execution approach liftandshift vs reengineering

Own solution architecture for Power BI reports datasets and semantic models based on enterprise standards

Establish best practices for report development performance tuning reusability and governance

Stakeholder Client Engagement

Act as the primary onshore point of contact for business stakeholders product owners and IT leadership

Conduct requirement workshops to translate SSRS reports into optimized Power BI dashboards and reports

Present design proposals migration progress risks and outcomes to executive and operational audiences

Drive business validation UAT coordination and signoffs

Delivery Team Coordination

Provide technical and delivery leadership to offshore Power BI development teams

Review designs Power BI artifacts DAX calculations and dataset models for quality and scalability

Ensure adherence to timelines delivery milestones and SLAs

Identify and mitigate migration risks related to data quality performance security and user adoption

Governance Security Performance

Implement Power BI governance models including workspaces deployment pipelines and access controls

Ensure rowlevel security RLS and compliance with enterprise security standards

Optimize datasets using star schema modeling aggregations and DirectQueryImport strategies as applicable

Define standards for versioning documentation and operational handover

Adoption Enablement

Support Power BI adoption by defining report usage standards and user experience principles

Guide business users transitioning from paginated SSRS reports to interactive Power BI experiences

Contribute to training materials and knowledge transfer sessions as needed

Required Skills Experience

MustHave

8 years in BIreporting platforms with strong handson Power BI experience

Proven experience leading SSRS to Power BI migration programs in large enterprises

Deep expertise in

Power BI Desktop Service and Premium capacities

DAX Power Query M and data modeling

SSRS architecture subscriptions and report types

Strong understanding of SQL Server data warehouses and dimensional modeling

Experience working in onshoreoffshore delivery models

Excellent clientfacing communication and leadership skills

GoodtoHave

Experience with Azure data services Azure SQL Synapse Data Factory

Exposure to Power BI deployment pipelines and CICD practices

Experience with enterprise governance audit and compliance requirements

Background in analytics modernization or cloud BI transformations

Role Characteristics

Onshore leadership role with high client visibility

Heavy collaboration with business architecture and engineering teams

Balanced focus on strategy execution and stakeholder management