Can you lead the modernization of enterprise reporting and cloud-based analytics? Apply Now!
Working with one of our top financial clients, this role calls for a Power BI Lead/Migration & Modernization Project to provide technical leadership for the migration, modernization, and governance of reporting solutions across cloud and on-premises environments. The successful candidate will help advance Power BI adoption, enable AI-assisted insights, strengthen reporting controls, and build capability across business, data, technology, and risk teams.
Pay rate range (CAD): $69.83/hr – $83.79/hr
Responsibilities
- Lead the migration of Tableau, Business Objects, and other legacy reporting solutions to Power BI.
- Assess existing reporting portfolios and develop migration roadmaps, sequencing strategies, technical approaches, and implementation plans.
- Provide hands-on support for report conversion, data mapping, star-schema modelling, semantic model consolidation, testing, validation, and production readiness.
- Apply best practices across DAX, Power Query, DirectQuery, Import and hybrid architectures, incremental refresh, and Power BI and Fabric deployment pipelines.
- Partner with report owners, business teams, data engineers, and platform teams to resolve migration issues and manage dependencies.
- Identify opportunities to simplify and automate recurring reporting processes, reduce manual effort, and improve analytical capacity.
- Track migration progress, risks, and outcomes while escalating issues and recommending practical solutions.
- Define and evolve target-state architecture for scalable, resilient, and reusable Power BI reporting.
- Establish development, modelling, deployment, and documentation standards across Power BI, Microsoft Fabric, and related Azure data platforms.
- Design semantic models and metadata to support performance, scalability, reusability, natural-language exploration, and AI-assisted insights.
- Collaborate with data engineering teams on integration with Azure Databricks, Unity Catalog, Azure Synapse Analytics, data lakes, and lakehouse architectures.
- Diagnose complex performance issues across reports, semantic models, dataflows, and capacities, implementing sustainable improvements to refresh times and user experience.
- Develop and maintain Power BI governance and controls aligned with security, privacy, data, and technology requirements.
- Define standards for workspace design, ownership, access, certification, deployment, lifecycle management, documentation, and evidence retention.
- Establish row-level security, object-level security, data access controls, and metadata management practices.
- Lead capacity planning, workload monitoring, performance reviews, and quality practices across reporting assets and platforms.
- Promote the responsible use of governed enterprise data assets, Copilot, and AI-enabled analytics.
- Serve as a trusted Power BI advisor to report developers, analysts, and business users.
- Provide thought leadership, review solutions, share expertise, and coach colleagues through complex technical challenges.
- Build collaborative relationships across business, data, technology, and control teams.
- Promote governed self-service analytics through reusable standards, training, guidance, and knowledge sharing.
- Lead office hours, communities of practice, and targeted learning sessions to support adoption and professional development.
- Gather user feedback and adoption insights to identify barriers and improve the reporting experience.
- Engage senior stakeholders through clear recommendations, architecture reviews, and concise updates on progress, risks, and decisions.
Desired Skill-Set
- At least five years of relevant professional experience.
- Experience leading the migration of Tableau, Business Objects, or other reporting platforms to Power BI within a financial institution.
- Expert knowledge of Power BI, Power BI Service administration, semantic modelling, DAX, Power Query, data modelling, security, and capacity management.
- Strong working knowledge of Microsoft Fabric, Azure Databricks, Unity Catalog, Azure Synapse Analytics, SQL Server, data warehousing, and lakehouse architecture.
- Experience enabling Copilot capabilities within Power BI dashboards and reporting solutions.
- Strong written and verbal communication skills.
- Strong interpersonal, collaboration, and stakeholder management skills.
- Ability to educate business and technical teams on new platforms and capabilities.
- Project management capabilities, including planning, coordination, risk management, and delivery tracking.
- Post-secondary education is an asset.
Nice to Have
- Experience with Microsoft Copilot, AI-enabled analytics, enterprise data governance, or large-scale business intelligence transformation.
- Experience with GitHub integration, CI/CD pipelines, deployment automation, and workspace governance.
BeachHead is an equal opportunity agency and employer. We advocate for our candidates and welcome applicants regardless of race, color, religion, national origin, sex, age, or physical or mental disability. BeachHead or our clients may use technology-enabled tools, including automation and artificial intelligence (AI), to support parts of the recruitment process such as resume screening, application management, and candidate matching. These tools assist our recruiters and our clients, and do not replace human decision-making. This job posting represents a current or anticipated vacancy. The position may be filled at any time, and the posting may be removed without notice once the role has been filled.
Privacy Policy