PowerBI Developer - Banking/Capital market exp.

Job summary

Design, develop, and maintain Power BI dashboards, reports, data models, and analytics solutions for banking and financial use cases, integrating data from multiple sources. Ensure reporting accuracy, security, governance, and performance while managing Power BI Service deployments, supporting users, and collaborating with business and technical teams.

Job details

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.

What you’ll do

Design, develop, and maintain Power BI dashboards, reports, data models, and analytics solutions for banking and financial use cases, integrating data from multiple sources. Ensure reporting accuracy, security, governance, and performance while managing Power BI Service deployments, supporting users, and collaborating with business and technical teams.

Requirements

Requires a bachelor’s degree in a related field and at least eight years of Power BI or business intelligence experience, including experience in banking, financial services, insurance, fintech, or a related domain. Candidates should be proficient in Power BI, DAX, Power Query, SQL, data modeling, ETL/ELT, and data integration, with strong analytical, communication, and stakeholder management skills.

Listed skills

• Data visualization · Preferred
• Power BI · Preferred
• SQL · Preferred
• Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Power BI
• DAX
• Power Query
• SQL
• Data Modeling
• Dimensional Modeling
• Dashboard Development
• Report Development
• ETL/ELT
• Data Integration
• Row-Level Security
• Data Governance
• Data Visualization
• Performance Optimization
• Stakeholder Management
• Banking Analytics

Job areas

• Data & Analytics
• Technology
• Finance & Accounting
• Software

More jobs from Zodiac Solutions, Inc