Ports North
Risk Reporting Automation Consultant (Power BI/Power Apps)
Ports North, Chicago, Illinois, United States, 60290
Title
Risk Reporting Automation Consultant (Power BI/Power Apps)
Location
Chicago, IL (Hybrid - 3 days)
Client Industry
Financial Services
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
#J-18808-Ljbffr
Risk Reporting Automation Consultant (Power BI/Power Apps)
Location
Chicago, IL (Hybrid - 3 days)
Client Industry
Financial Services
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
#J-18808-Ljbffr