TekStaff's Client has a current vacancy for a Senior Power BI Lead
Duration : This is a 12 month contract located in Toronto/Ontario, Hybrid
Job Description
SUMMARY OF THE ROLE:
- Typical Day-to-Day Responsibilities – see below
- How much time is being spent in meetings – 2 hours per day on average
- Who are they interacting with (internal/external) – internal
- Will the contractor have access to any customer data? – Yes
Role Overview
Retail Risk Management (RRM) is reimagining the future of reporting as we accelerate our adoption of cloud-based data, analytics and AI. The Senior Power BI Lead will provide the technical leadership needed to migrate, scale and automate legacy reporting while enabling teams build the skills and confidence to fully leverage Power BI and Copilot. The role will help shift reporting from primarily consuming dashboards to a more intuitive experience where users can explore data, ask questions and generate insights to support faster decision-making. This is an opportunity to combine deep technical expertise with innovation and people leadership to modernize RRM-wide reporting and create capacity for teams to focus on strategic risk insights and decisions.
Key Responsibilities
Lead Migration Activities
- Lead the modernization and migration of Tableau and other legacy reporting to Power BI across cloud and on-prem environments.
- Assess the existing reporting portfolio and help develop migration roadmaps, sequencing, technical approaches and implementation plans.
- Provide hands-on support for report conversion, data mapping, star-schema modeling best practices, semantic model consolidation, testing, validation and production readiness.
- Provide expert guidance on DAX optimization, 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, manage dependencies and minimize disruption.
- Identify opportunities to simplify and automate recurring reporting processes, reduce manual effort and create capacity for higher value analysis.
- Track migration progress, risks and outcomes, escalating issues and recommending practical solutions where needed.
Define and Enable Future State
- Define and evolve the target state architecture for scalable, resilient and reusable Power BI reporting in the cloud.
- Establish practical development, modelling, and deployment standards across Power BI, Microsoft Fabric and related Azure data platforms.
- Design semantic models and metadata for performance, scalability, reusability and Copilot readiness, enabling natural language exploration and AI-assisted insights.
- Partner with data engineering teams to optimize integration with Azure Databricks, Unity Catalog, Azure Synapse Analytics, and data lake architectures.
- Diagnose complex performance issues across reports, semantic models, dataflows and capacities, and implement sustainable improvements to refresh times and user experience.
- Monitor platform capabilities and emerging practices, translating them into a clear roadmap and practical recommendations for RRM.
Build Trusted Governance and Controls
- Develop and maintain a practical Power BI governance and controls framework aligned with enterprise security, privacy, data and technology requirements.
- Define standards for workspace design, ownership, access, certification, deployment, lifecycle management, documentation and evidence retention.
- Establish appropriate row level security, object level security, data access controls and metadata management practices.
- Lead capacity planning, workload monitoring and performance reviews to improve stability, responsiveness and cost effectiveness.
- Implement monitoring and quality practices across reports, dashboards, dataflows, semantic models and capacities, and drive timely identification and remediation of issues.
- Promote the use of governed enterprise data assets and responsible adoption of Copilot and AI enabled analytics.
Champion Adoption and Build Capability
- Serve as RRM’s go-to Power BI advisor, providing approachable, hands-on support to report developers, analysts and business users.
- Provide thought leadership across the Power BI community by setting direction, reviewing solutions, sharing expertise and coaching colleagues through complex challenges.
- Build trusted partnerships across RRM, Data, Technology and Control teams to understand needs and connect users with the right expertise and support.
- Promote governed self-service analytics through reusable standards, guidance, training and knowledge sharing that increase user capability and confidence.
- Lead knowledge sharing, office hours, communities of practice and targeted learning sessions to accelerate RRM wide adoption of Power BI and Copilot.
- Gather user feedback and adoption insights to identify recurring barriers, improve the reporting experience and shape future priorities.
- Engage senior leaders and stakeholders through clear recommendations, architecture reviews and concise communication of progress, risks and decisions.
MUST-HAVE Hard Skills:
1.) Someone who has a led migration from tableau/business objects or other reporting tools to Power Bi at another financial institutions
2.) Expert knowledge of Power BI, Power BI Service administration, semantic modelling, DAX, Power Query, data modelling and security and capacity management.
3.) Strong working knowledge of Microsoft Fabric, Azure Databricks, Unity Catalog, Azure Synapse Analytics, SQL Server, data warehousing and lakehouse architecture.
4.) Experimeve anabling copilot on power bi dashboards
SOFT SKILLS:
1.) Strong communication skills (written and verbal)
2.) Strong interpersonal and collaboration skills
3.) Strong stakeholder management skills
4.) Ability to educate teams, stakeholders on new platform
5.) Someone with Project Management capabilities
NICE-TO-HAVE
1.) Experience with Microsoft Copilot, AI enabled analytics, enterprise data governance or large-scale business intelligence transformation is considered an asset.
2.) Experience with GitHub integration, CI/CD pipelines, deployment automation and workspace governance
TekStaff may use artificial intelligence (AI) tools as part of the applicant screening process. However, applications will also be reviewed by a member of our Recruitment team to ensure a fair and thorough assessment.