Senior Power BI Developer
Candidate profile details:
• Degree/Level of Education: Post secondary – data analytics
• Certifications Required: NO
• Years of Overall Experience: 8-11 years of experience
• How will performance be measured: deliverables and quality of work
• Preferred/Ideal Candidate Background: power BI, working in a complex environment, data developer roles, active demo of their work show their work, story telling.cultural fit in terms of ability to deal with ambiguity, changing requirements. It’s a highly dynamic, ambiguous environment wherein business requirements always change. Need somebody who has the ability of learner’s mindset, able to coach easily, and able to with an adaptive mindset.
Summary of the role:
• Typical Day-to-Day Responsibilities: run ETL pipelines, working with data partner, using python, developing dashboards,
• How much time is being spent in meetings:20 %
• Who are they interacting with (internal/external) – Internal
• Will the contractor have access to any customer data? NO
Must-have hard skills:
• Power BI, Power Automate, M queries, tax queries**
• Report development
• Processing mapping
• SQL
• Story telling
• Dax*
• M- Code
• Documentation
Soft skills:
• Attention to detail
• Stakeholder Engagement
• 3.Communcaiton
• Coachable– Learner’s Mindset
• 5.Willingness to Deliver.
Nice-To-Have
• PBI Service management
• Version Control
• Power Platform
• Python
Interview process:
• 2 to 3 Rounds of interview – one in person and 2 virtual
• Senior Power BI Developer/ Data Engineer V – Capital Measurement Reporting (Data Modernization)
Experience
• 10–15 years overall experience in Business Intelligence, Data & Analytics
• 5+ years of advanced Power BI development in Banking / Financial Services
• Proven experience supporting Capital, Risk, or Regulatory Reporting initiatives
Role Summary
• We are seeking a seasoned Senior Power BI Developer to support a Capital Measurement Reporting (CMR) Data Modernization program within the Banking domain. This role will focus on delivering trusted, well governed, and regulator ready analytics that support capital reporting, risk metrics, and executive decision making.
• The successful candidate will work closely with Risk, Finance, Regulatory Reporting, and Data Engineering teams to modernize reporting platforms, enhance transparency, and enable data driven insights aligned to regulatory expectations (e.g., Basel / capital frameworks).
Key Responsibilities
• Capital & Risk Reporting Analytics
o Design and develop Power BI dashboards and reports supporting Capital Measurement, RWA, Risk Exposure, and Finance metrics.
o Translate complex capital and risk data into clear, auditable, and business friendly visualizations.
o Enable storytelling for senior management and regulators, ensuring clarity, traceability, and consistency.
o Support drill downs from enterprise summaries to granular risk and exposure data.
• Data Modernization & Modeling
o Build optimized Power BI semantic models aligned with modern data platforms (cloud, curated data layers).
o Apply advanced data modeling techniques (star schema, conformed dimensions) for capital and risk data.
o Develop and optimize DAX measures for capital calculations, aggregations, trends, and comparisons.
o Leverage Power Query (M code) and SQL to support ETL and data transformation requirements.
• ETL & Data Integration
o Work with upstream ETL and Data Engineering teams to ensure accurate, timely, and reconciled data feeds.
o Support ingestion from multiple banking data sources (risk engines, finance systems, regulatory datasets).
o Ensure data lineage, reconciliation, and consistency across reports.
• Power BI Service & Governance
o Manage Power BI Service environments, including workspace strategy, datasets, refresh schedules, and access controls.
o Implement version control, deployment, and release management practices aligned with enterprise standards.
o Ensure compliance with data governance, security, and audit requirements.
o Produce high quality documentation to support audit, model validation, and regulatory reviews.
• Automation & Power Platform
o Utilize Power Automate to streamline reporting workflows and data validation processes.
o Contribute to broader Power Platform adoption within the Capital Measurement ecosystem.
• Stakeholder Engagement & Leadership
o Partner with Risk, Finance, Capital Management, and Technology stakeholders to gather requirements and validate outputs.
o Act as a subject matter expert for Power BI within the Capital Measurement Reporting space.
o Mentor junior BI developers and promote best practices across the program.
o Participate in design reviews and modernization working groups.
Required Technical Skills
• Business Intelligence & Data
o Power BI Desktop & Power BI Service (Expert)
o Advanced DAX
o Power Query / M code
o Advanced SQL
o Enterprise data modeling (Fact / Dimension modeling)
o ETL concepts and performance optimization
o Documentation and audit ready reporting
• Power Platform & Tools
o Power Automate
o Power Platform fundamentals
o Version Control (Git, Azure DevOps or equivalent)
o PBIX lifecycle and release management
• Banking & Domain Knowledge (Highly Preferred)
o Capital Measurement / Capital Reporting
o Risk & Finance data concepts
o Regulatory reporting environments
o Data controls, reconciliation, and traceability expectations
o Large scale data modernization programs
• Additional Skills (Nice to Have)
o Python scripting
o VBA / Macros (legacy reporting environments)
o Process mapping and operating model documentation
• Core Competencies & Soft Skills
o Strong stakeholder engagement across Risk, Finance, and Technology
o Excellent communication and storytelling skills
o Ability to explain complex capital data in simple, executive ready formats
o Coachable, continuous learner with modernization mindset
o High accountability and willingness to deliver in regulatory driven environments
Education & Certifications (Preferred)
• Bachelor’s or Master’s degree in Technology, Analytics, Finance, or related field
• Microsoft Power BI certification (e.g., PL 300) preferred
What Success Looks Like
• Capital and risk stakeholders rely on Power BI as a trusted reporting source
• Improved transparency, traceability, and confidence in capital metrics
• Well governed, scalable Power BI assets aligned with modernization goals
• Strong partnership between Capital, Risk, Finance, and Technology teams
• Degree/Level of Education: Post secondary – data analytics
• Certifications Required: NO
• Years of Overall Experience: 8-11 years of experience
• How will performance be measured: deliverables and quality of work
• Preferred/Ideal Candidate Background: power BI, working in a complex environment, data developer roles, active demo of their work show their work, story telling.cultural fit in terms of ability to deal with ambiguity, changing requirements. It’s a highly dynamic, ambiguous environment wherein business requirements always change. Need somebody who has the ability of learner’s mindset, able to coach easily, and able to with an adaptive mindset.
Summary of the role:
• Typical Day-to-Day Responsibilities: run ETL pipelines, working with data partner, using python, developing dashboards,
• How much time is being spent in meetings:20 %
• Who are they interacting with (internal/external) – Internal
• Will the contractor have access to any customer data? NO
Must-have hard skills:
• Power BI, Power Automate, M queries, tax queries**
• Report development
• Processing mapping
• SQL
• Story telling
• Dax*
• M- Code
• Documentation
Soft skills:
• Attention to detail
• Stakeholder Engagement
• 3.Communcaiton
• Coachable– Learner’s Mindset
• 5.Willingness to Deliver.
Nice-To-Have
• PBI Service management
• Version Control
• Power Platform
• Python
Interview process:
• 2 to 3 Rounds of interview – one in person and 2 virtual
• Senior Power BI Developer/ Data Engineer V – Capital Measurement Reporting (Data Modernization)
Experience
• 10–15 years overall experience in Business Intelligence, Data & Analytics
• 5+ years of advanced Power BI development in Banking / Financial Services
• Proven experience supporting Capital, Risk, or Regulatory Reporting initiatives
Role Summary
• We are seeking a seasoned Senior Power BI Developer to support a Capital Measurement Reporting (CMR) Data Modernization program within the Banking domain. This role will focus on delivering trusted, well governed, and regulator ready analytics that support capital reporting, risk metrics, and executive decision making.
• The successful candidate will work closely with Risk, Finance, Regulatory Reporting, and Data Engineering teams to modernize reporting platforms, enhance transparency, and enable data driven insights aligned to regulatory expectations (e.g., Basel / capital frameworks).
Key Responsibilities
• Capital & Risk Reporting Analytics
o Design and develop Power BI dashboards and reports supporting Capital Measurement, RWA, Risk Exposure, and Finance metrics.
o Translate complex capital and risk data into clear, auditable, and business friendly visualizations.
o Enable storytelling for senior management and regulators, ensuring clarity, traceability, and consistency.
o Support drill downs from enterprise summaries to granular risk and exposure data.
• Data Modernization & Modeling
o Build optimized Power BI semantic models aligned with modern data platforms (cloud, curated data layers).
o Apply advanced data modeling techniques (star schema, conformed dimensions) for capital and risk data.
o Develop and optimize DAX measures for capital calculations, aggregations, trends, and comparisons.
o Leverage Power Query (M code) and SQL to support ETL and data transformation requirements.
• ETL & Data Integration
o Work with upstream ETL and Data Engineering teams to ensure accurate, timely, and reconciled data feeds.
o Support ingestion from multiple banking data sources (risk engines, finance systems, regulatory datasets).
o Ensure data lineage, reconciliation, and consistency across reports.
• Power BI Service & Governance
o Manage Power BI Service environments, including workspace strategy, datasets, refresh schedules, and access controls.
o Implement version control, deployment, and release management practices aligned with enterprise standards.
o Ensure compliance with data governance, security, and audit requirements.
o Produce high quality documentation to support audit, model validation, and regulatory reviews.
• Automation & Power Platform
o Utilize Power Automate to streamline reporting workflows and data validation processes.
o Contribute to broader Power Platform adoption within the Capital Measurement ecosystem.
• Stakeholder Engagement & Leadership
o Partner with Risk, Finance, Capital Management, and Technology stakeholders to gather requirements and validate outputs.
o Act as a subject matter expert for Power BI within the Capital Measurement Reporting space.
o Mentor junior BI developers and promote best practices across the program.
o Participate in design reviews and modernization working groups.
Required Technical Skills
• Business Intelligence & Data
o Power BI Desktop & Power BI Service (Expert)
o Advanced DAX
o Power Query / M code
o Advanced SQL
o Enterprise data modeling (Fact / Dimension modeling)
o ETL concepts and performance optimization
o Documentation and audit ready reporting
• Power Platform & Tools
o Power Automate
o Power Platform fundamentals
o Version Control (Git, Azure DevOps or equivalent)
o PBIX lifecycle and release management
• Banking & Domain Knowledge (Highly Preferred)
o Capital Measurement / Capital Reporting
o Risk & Finance data concepts
o Regulatory reporting environments
o Data controls, reconciliation, and traceability expectations
o Large scale data modernization programs
• Additional Skills (Nice to Have)
o Python scripting
o VBA / Macros (legacy reporting environments)
o Process mapping and operating model documentation
• Core Competencies & Soft Skills
o Strong stakeholder engagement across Risk, Finance, and Technology
o Excellent communication and storytelling skills
o Ability to explain complex capital data in simple, executive ready formats
o Coachable, continuous learner with modernization mindset
o High accountability and willingness to deliver in regulatory driven environments
Education & Certifications (Preferred)
• Bachelor’s or Master’s degree in Technology, Analytics, Finance, or related field
• Microsoft Power BI certification (e.g., PL 300) preferred
What Success Looks Like
• Capital and risk stakeholders rely on Power BI as a trusted reporting source
• Improved transparency, traceability, and confidence in capital metrics
• Well governed, scalable Power BI assets aligned with modernization goals
• Strong partnership between Capital, Risk, Finance, and Technology teams