PowerBI Lead
Cincinnati - Ohio - USAOn-siteFull-timeInformation Technology
Description
Onshore PowerBI Lead SSRS to PowerBI Migration Location Cincinnati,OH On-site Onshore Client-facing role Role Summary The Onshore PowerBI Lead will be responsible for leading enterprisescale migration of legacy SSRS reports to PowerBI owning end-to-end 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 PowerBI migration initiatives including report rationalization redesign and modernization Define migration strategy roadmap and execution approach liftandshift vs reengineering Own solution architecture for PowerBI 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 PowerBI 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 PowerBI development teams Review designs PowerBI 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 PowerBI 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 Direct Query Import strategies as applicable
Define standards for versioning documentation and operational handover
Adoption Enablement
Support PowerBI adoption by defining report usage standards and user experience principles
Guide business users transitioning from paginated SSRS reports to interactive PowerBI experiences
Contribute to training materials and knowledge transfer sessions as needed
Required Skills Experience
Must Have
8 years in BIreporting platforms with strong hands-on PowerBI experience
Proven experience leading SSRS to PowerBI migration programs in large enterprises
Deep expertise in
PowerBI 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 client-facing communication and leadership skills Good to have Experience with Azure data services Azure SQL Synapse Data Factory Exposure to PowerBI 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
Requirements
Mandatory Skills : PowerBI