PowerBI Developer with Banking/Financial exp.
- Mississauga, ON, Canada
$110,000 to $120,000 CAD / year · Full-time
Applications open in a new tab.
Job details
- Pay
- $110,000 to $120,000 CAD / year
- Job type
- Full-time
- Apply by
- Experience
- 7 years of experience in Power BI development or business intelligence.
- Posting language
- English
- Posted
Original job description
We are
At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 17,000+, and has 58 offices in 22 countries within key global markets.
Our challenge
We are seeking an experienced Power BI Developer with strong expertise in business intelligence, data visualization, and analytics within the banking or financial services domain. The successful candidate will design, develop, and maintain interactive Power BI dashboards and reports that support business decision-making across areas such as retail banking, lending, risk, compliance, finance, treasury, and operations.
The role requires strong technical knowledge of Power BI, SQL, data modeling, and ETL processes, along with a solid understanding of financial data, banking KPIs, and regulatory reporting requirements.
Additional Information*
The base salary for this position will vary based on geography and other factors. In accordance with law, the base salary for this role if filled within Toronto, ON is CAD $110K - CAD $120K/year & benefits (see below).
The Role
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.
- 7 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.
Preferred skills:
Microsoft Certified: Power BI Data Analyst Associate (PL-300) or equivalent certification.
Experience with Microsoft Azure services such as Azure Data Factory, Azure Synapse, Azure SQL, or Databricks.
Familiarity with banking platforms, financial data warehouses, or core banking systems.
Knowledge of financial and banking KPIs, including:
- Net interest income
- Cost-to-income ratio
- Non-performing loans
- Loan-to-deposit ratio
- Capital adequacy
- Customer profitability
- Delinquency and default rates
- Liquidity and operational risk metrics
We offer:
- A multinational organization with 58 offices in 22 countries and the possibility to work abroad.
- 15 days (3 weeks) of paid annual leave plus an additional 10 days of personal leave (floating days and sick days).
- A comprehensive insurance plan including medical, dental, vision, life insurance, and long-term disability.
- Flexible hybrid policy.
- RRSP with employer’s contribution up to 4%.
- A higher education certification policy.
- On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
- Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.
- Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms.
- A truly diverse, fun-loving and global work culture.
S YNECHRON’S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.
More about this job
Responsibilities
Design, develop, and maintain Power BI dashboards, reports, data models, and data pipelines for banking and financial services use cases. Ensure reporting solutions are accurate, secure, governed, and performant while collaborating with stakeholders and supporting testing, deployment, and ongoing production enhancements.
Requirements
Requires a bachelor’s degree in a related field and at least seven years of Power BI development 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 row-level security, with strong analytical, communication, and stakeholder management skills.
Skills
- Power BI
- DAX
- Power Query
- SQL
- Data Modeling
- Dimensional Modeling
- Dashboard Development
- Data Visualization
- ETL/ELT
- Row-Level Security
- Power BI Service
- Data Governance
- Performance Optimization
- Financial Reporting
- Stakeholder Management
- Azure Data Services
Benefits
- Paid Annual Leave
- Personal Leave
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Long-Term Disability Insurance
- Hybrid Work Policy
- RRSP With Employer Contributions Up To 4%
- Higher Education Certification Support
- Udemy For Business Access
- Coaching And Mentoring
- Learning And Development Opportunities
- International Work Opportunities
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Finance & Accounting
- Consulting
Keywords
- Power BI
- Power BI Desktop
- Power BI Service
- DAX
- Power Query
- SQL
- SQL Server
- Oracle
- Snowflake
- Azure Synapse
- Databricks
- Azure Data Factory
- Azure SQL
- ETL/ELT
- Data Modeling
- Dimensional Modeling
- Row-Level Security
- Data Governance
- Financial Services
- Banking
- Regulatory Reporting
- Credit Risk
- Fraud Monitoring
- Treasury Analytics
- Financial KPIs
- PL-300
- Data Visualization
- Incremental Refresh
- Data Warehousing
- Dashboard Development