PowerBI Developer - Banking/Capital market exp.

Role: PowerBI Developer - Banking/Capital market exp.

Location: Mississauga, ON (3 days hybrid)

Contract

Responsibilities:

• Design, develop, and maintain interactive Power BI dashboards, reports, and analytical solutions.
• Gather reporting and analytics requirements from business stakeholders and translate them into effective BI solutions.
• Develop robust data models using Power BI and implement appropriate relationships, hierarchies, and calculated measures.
• Write optimized DAX calculations and queries to support complex business requirements.
• Extract, transform, and load data from multiple sources using SQL, Power Query, ETL tools, APIs, and other data integration technologies.
• Develop and optimize SQL queries, stored procedures, views, and data pipelines.
• Create dashboards and reports for banking and financial use cases, including:
• Customer and account analytics
• Deposits and lending
• Loan portfolio performance
• Credit risk and delinquency
• Fraud monitoring
• Regulatory and compliance reporting
• Profitability and financial performance
• Branch and channel performance
• Treasury and liquidity analytics
• Operational and service-level metrics
• Ensure data accuracy, consistency, security, and governance across all reporting solutions.
• Implement row-level security, workspace governance, and appropriate access controls.
• Improve report performance through effective data modeling, query optimization, aggregation, and incremental refresh strategies.
• Publish and manage reports, datasets, dashboards, and apps within the Power BI Service.
• Monitor scheduled refreshes and resolve data quality, performance, and connectivity issues.
• Collaborate with data engineers, business analysts, risk teams, finance teams, and other stakeholders.
• Prepare technical documentation, data dictionaries, report specifications, and user guides.
• Support user acceptance testing, deployment, production support, and ongoing enhancements.
• Stay informed about Power BI updates, financial reporting standards, data governance, and industry best practices.

Requirements:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Finance, Business Analytics, or a related field.
• 8+ years of experience in Power BI development or business intelligence.
• Proven experience working in the banking, financial services, insurance, fintech, or related domain.

Strong proficiency in:

• Power BI Desktop and Power BI Service
• DAX
• Power Query
• SQL
• Data modeling and dimensional modeling
• Dashboard and report development
• Experience with data sources such as SQL Server, Oracle, Snowflake, Azure Synapse, Databricks, Excel, APIs, and enterprise data warehouses.
• Knowledge of ETL/ELT processes and data integration concepts.
• Experience implementing Row-Level Security and managing Power BI workspaces.
• Strong understanding of data visualization principles and dashboard usability.
• Ability to analyze complex business requirements and convert them into scalable BI solutions.
• Excellent analytical, problem-solving, communication, and stakeholder management skills.