Location Address: Toronto – hybrid – onsite 3x/week
Contract Duration: 10 months
Possibility for Extension
Number of Positions: 1
Schedule Hours: 9am-5pm Monday-Friday (Possible OT)
Reason: Additional workload
Story Behind the Need
Business group: Global Cash Management
The team focused on internal treasury reporting around liquidity and funding metrics.
We are seeking a skilled Power BI Developer to join our dynamic team. The ideal candidate will be responsible for transforming raw data into meaningful insights through the development of interactive and visually appealing reports and dashboards using Microsoft Power BI. The Power BI Developer will collaborate with business stakeholders, analysts, and other team members to understand data requirements, design efficient data models, and deliver actionable insights that drive informed business decisions.
Candidate Value Proposition:
The successful candidate will have exposure to data and treasury function of the bank within reporting and product. They will have opportunity to work in an environment and practice work within a team that drives the bank’s decisions.
Typical Day in Role:
1.Data Analysis and Requirements Gathering:
•Collaborate with business stakeholders to understand their data analysis needs.
•Gather and document requirements for reporting and analytics projects.
2.Data Modeling and Transformation:
•Design and implement efficient data models for Power BI reports.
•Transform and clean raw data into a format suitable for analysis.
3.Power BI Report and Dashboard Development:
•Develop interactive and visually compelling reports and dashboards using Power BI.
•Implement best practices for data visualization to ensure clarity and usability.
4.Integration and Data Connectivity:
•Integrate Power BI with various data sources, including databases, APIs, and other data repositories.
•Ensure data connectivity and seamless data refresh capabilities.
5.Performance Optimization:
•Optimize Power BI reports and dashboards for performance and responsiveness.
•Troubleshoot and resolve any performance-related issues.
6.Collaboration and Communication:
•Work closely with cross-functional teams, including business analysts, data engineers, and IT professionals.
•Communicate effectively to translate business requirements into actionable insights.
Candidate Requirements/Must Have Skills:
1) 3+ years of experience as a Power BI Developer or data visualization
2) Strong proficiency in Power BI, including data modeling, DAX, and Power Query.
3) 3+ years of Experience with data warehouse concepts (preferably SQL)
4) Familiarity with business intelligence and data visualization best practices.
Nice-To-Have Skills:
1) Power BI certification is a plus.
2) Experience with other BI tools such as Tableau or QlikView
3) Knowledge of Azure
Soft Skills Required:
•Excellent analytical and problem-solving skills.
•Strong communication and collaboration skills.
Education:
Bachelor's degree in Computer Science, Information Systems, or a related field.
Candidate Review & Selection
2 rounds
1st – HM + peer – 45 mins – MS Teams Video
2nd – HM + Director – 30 mins – in-person preferred
Hiring Manager’s availability to interview: ASAP