Korn Ferry
Risk Reporting Automation Consultant (Power BI/Power Apps)
Korn Ferry, Chicago, Illinois, United States, 60290
Apply for the
Risk Reporting Automation Consultant (Power BI/Power Apps)
role at
Korn Ferry .
Base pay range $65.00/hr - $70.00/hr
Location: Chicago, IL (Hybrid - 3 days)
Compensation: $60 - $70/hr. (6+ month contract)
We have partnered with our client in their search for a Risk Reporting Automation Consultant (Power BI/Power Apps). This role will automate risk and finance reporting using Microsoft Power BI and Power Apps, and strengthen the firm’s Key Risk Indicator (KRI) logic. The consultant partners with Risk, Finance, and Technology to connect data from multiple systems, codify business rules, and produce reliable, self‑service dashboards and apps. Success is measured by reduced manual reporting effort, accuracy and consistency of KRI calculations, on‑time delivery of dashboards/apps, and clear documentation aligned to banking data‑governance practices.
Responsibilities
Automate end-to-end reporting workflows across multiple systems using Microsoft Power BI and Power Apps
Design and maintain semantic models, DAX measures, calculation groups, dataflows, and scheduled/incremental refresh in Power BI Service
Build and publish user‑friendly dashboards and apps; implement Row-Level Security (RLS) and workspace governance
Translate business and risk requirements into robust KRI definitions, thresholds, and calculation logic; validate with stakeholders
Implement data quality checks, lineage, and monitoring for KRI data; investigate and remediate refresh and performance issues
Author and socialize data standards, data definitions, and calculation rules aligned with the Data Management Capability Assessment Model (DCAM) and the Basel Committee’s BCBS 239 principles for Risk Data Aggregation and Risk Reporting (RDARR)
Partner with Risk, Data Governance, and Technology to prioritize a delivery backlog; plan sprints and report status and risks
Provide documentation, playbooks, and knowledge transfer to ensure sustainable ownership and support
Skills Required
Expert Power BI skills: DAX, Power Query (M), dataflows, composite models, deployment pipelines, and row‑level security
Power Apps (Canvas/Model‑driven) and Power Automate with Dataverse/SharePoint/SQL integrations and basic ALM in Power Platform
Advanced SQL and ELT/ETL patterns; incremental refresh, gateways, and scheduled data pipelines
KRI/KPI design in risk or finance, including thresholding, trend analysis, variance, and alerting logic
Data modeling and semantic layer design; star schemas and calculation groups
Documentation excellence; writes calculation specifications, data dictionaries, and user guides that are audit‑ready
Data governance and controls literacy; familiarity with RDARR and BCBS 239; exposure to DCAM (Data Management Capability Assessment Model)
Testing and quality assurance for BI artifacts; builds test cases, validates results to source, and monitors data quality
Dashboard UX and data storytelling; designs accessible, comprehensible visuals that drive decisions
Stakeholder engagement across Risk, Finance, and Technology; facilitates workshops, backlog grooming, and U‑AT sign‑off
Education & Work Experience
Relevant degree in Information Systems, Computer Science, Data/Analytics, or equivalent experience
4+ years delivering Power BI solutions and 3+ years with Power Apps/Power Automate in production environments
4+ years building metrics/KPIs/KRIs in risk or finance contexts
DCAM certification a plus; experience aligning deliverables to RDARR/BCBS 239 preferred
Seniority Level Mid‑Senior level
Employment Type Contract
Job Function Information Technology
Industries Information Services
Korn Ferry unleashes potential in people, teams, and organizations. We work with our clients to design optimal organization structures, roles, and responsibilities. We help them hire the right people and advise them on how to reward and motivate their workforce while developing professionals as they navigate and advance their careers. To learn more, please visit Korn Ferry at www.Kornferry.com.
#J-18808-Ljbffr
Risk Reporting Automation Consultant (Power BI/Power Apps)
role at
Korn Ferry .
Base pay range $65.00/hr - $70.00/hr
Location: Chicago, IL (Hybrid - 3 days)
Compensation: $60 - $70/hr. (6+ month contract)
We have partnered with our client in their search for a Risk Reporting Automation Consultant (Power BI/Power Apps). This role will automate risk and finance reporting using Microsoft Power BI and Power Apps, and strengthen the firm’s Key Risk Indicator (KRI) logic. The consultant partners with Risk, Finance, and Technology to connect data from multiple systems, codify business rules, and produce reliable, self‑service dashboards and apps. Success is measured by reduced manual reporting effort, accuracy and consistency of KRI calculations, on‑time delivery of dashboards/apps, and clear documentation aligned to banking data‑governance practices.
Responsibilities
Automate end-to-end reporting workflows across multiple systems using Microsoft Power BI and Power Apps
Design and maintain semantic models, DAX measures, calculation groups, dataflows, and scheduled/incremental refresh in Power BI Service
Build and publish user‑friendly dashboards and apps; implement Row-Level Security (RLS) and workspace governance
Translate business and risk requirements into robust KRI definitions, thresholds, and calculation logic; validate with stakeholders
Implement data quality checks, lineage, and monitoring for KRI data; investigate and remediate refresh and performance issues
Author and socialize data standards, data definitions, and calculation rules aligned with the Data Management Capability Assessment Model (DCAM) and the Basel Committee’s BCBS 239 principles for Risk Data Aggregation and Risk Reporting (RDARR)
Partner with Risk, Data Governance, and Technology to prioritize a delivery backlog; plan sprints and report status and risks
Provide documentation, playbooks, and knowledge transfer to ensure sustainable ownership and support
Skills Required
Expert Power BI skills: DAX, Power Query (M), dataflows, composite models, deployment pipelines, and row‑level security
Power Apps (Canvas/Model‑driven) and Power Automate with Dataverse/SharePoint/SQL integrations and basic ALM in Power Platform
Advanced SQL and ELT/ETL patterns; incremental refresh, gateways, and scheduled data pipelines
KRI/KPI design in risk or finance, including thresholding, trend analysis, variance, and alerting logic
Data modeling and semantic layer design; star schemas and calculation groups
Documentation excellence; writes calculation specifications, data dictionaries, and user guides that are audit‑ready
Data governance and controls literacy; familiarity with RDARR and BCBS 239; exposure to DCAM (Data Management Capability Assessment Model)
Testing and quality assurance for BI artifacts; builds test cases, validates results to source, and monitors data quality
Dashboard UX and data storytelling; designs accessible, comprehensible visuals that drive decisions
Stakeholder engagement across Risk, Finance, and Technology; facilitates workshops, backlog grooming, and U‑AT sign‑off
Education & Work Experience
Relevant degree in Information Systems, Computer Science, Data/Analytics, or equivalent experience
4+ years delivering Power BI solutions and 3+ years with Power Apps/Power Automate in production environments
4+ years building metrics/KPIs/KRIs in risk or finance contexts
DCAM certification a plus; experience aligning deliverables to RDARR/BCBS 239 preferred
Seniority Level Mid‑Senior level
Employment Type Contract
Job Function Information Technology
Industries Information Services
Korn Ferry unleashes potential in people, teams, and organizations. We work with our clients to design optimal organization structures, roles, and responsibilities. We help them hire the right people and advise them on how to reward and motivate their workforce while developing professionals as they navigate and advance their careers. To learn more, please visit Korn Ferry at www.Kornferry.com.
#J-18808-Ljbffr