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.
