Job Description
Our Client, a Banking company, is looking for a Data Analyst II for their Toronto, ON/Hybrid location.
Responsibilities:
Requirements:
Why Should You Apply?
Responsibilities:
- Design, develop, enhance, and maintain interactive Power BI dashboards and reports for operational, management, and executive audiences.
- Analyze, profile, and transform data from multiple sources to create scalable and reusable reporting datasets.
- Develop and optimize SQL queries, stored procedures, views, and data models to support analytics and reporting requirements.
- Utilize Python to automate data processing, validation, reconciliation, and reporting workflows.
- Partner with business stakeholders to gather, document, and translate reporting and analytics requirements into technical solutions.
- Perform data quality assessments and investigate data anomalies to ensure accuracy and reliability of analytics products.
- Support the modernization and consolidation of manual reporting processes through automation and self-service analytics capabilities.
- Contribute to Agile delivery practices including backlog refinement, sprint planning, stand-ups, and retrospectives.
- Prepare executive-ready presentations and communicate analytical findings, trends, risks, and opportunities to stakeholders.
- Support ongoing maintenance, enhancements, and issue resolution for existing analytics products and dashboards.
- Collaborate with data engineers, analysts, product owners, and business partners to deliver end-to-end analytics solutions.
Requirements:
- Undergraduate degree in Computer Science, Data Analytics, Mathematics, Statistics, Engineering, Economics, Business Analytics, or a related quantitative discipline.
- 3+ years of experience in data analytics, business intelligence, reporting, or related roles.
- Advanced experience with Power BI, including:
- Data modeling
- DAX measures and calculations
- Power Query
- Dashboard and report development
- Performance optimization
- Strong SQL experience with the ability to write complex queries and work with large datasets.
- Proficiency in Python for data analysis, automation, and reporting.
- Experience working with relational databases and enterprise data environments.
- Strong analytical and problem-solving skills with attention to detail.
- Excellent verbal and written communication skills, including the ability to present findings to technical and non-technical audiences.
- Ability to manage multiple priorities and work independently in a fast-paced environment.
- Preferred Qualifications (Nice to Have):
- Experience within Financial Risk Management, Credit Risk, Enterprise Risk, Regulatory Reporting, or Banking domains.
- Familiarity with risk metrics, risk reporting, credit portfolio analytics, or governance reporting.
- Exposure to Microsoft Azure services including Azure Data Factory, Azure SQL Database, Synapse, Databricks and Azure Storage Services
- Knowledge of Agile delivery methodologies.
- Experience supporting reporting modernization, automation, or analytics transformation initiatives.
- Familiarity with Excel Power Query, Power Pivot, and advanced Excel functions.
- Experience creating executive-level reporting packages and presentations.
Why Should You Apply?
- Health Benefits
- Referral Program
- Excellent growth and advancement opportunities
Numbers & Facts
| Location | Toronto, ON |
| Industry | Management Consulting Services |
| Salary | $44.58–$47.99 Per Hour |
| Company Size | 2,000 to 2,499 employees |
| Year Founded | 2000 |
| Website | https://www.iconma.com/ |
Benefits
401K, Employee Referral Program, Life Insurance
About Company
ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.
- Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
- Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
- Founded in 2000
- 2000+ Employees
The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.
Skills
- Agile Programming Methodologiesunmatched
- Analysis Skillsunmatched
- Automationunmatched
- Backlog Prioritizationunmatched
- Banking Servicesunmatched
- Business Analysisunmatched
- Business Intelligenceunmatched
- Communication Skillsunmatched
- Computer Scienceunmatched
- Credit Riskunmatched
- Data Analysisunmatched
- Data Modelingunmatched
- Data Processingunmatched
- Data Qualityunmatched
- Data Setsunmatched
- Detail Orientedunmatched
- Economic Analysisunmatched
- Health Planunmatched
- Mathematicsunmatched
- Metricsunmatched
- Microsoft Windows Azureunmatched
- Multitaskingunmatched
- Operations Managementunmatched
- Performance Tuning/Optimizationunmatched
- Portfolio Analysisunmatched
- Power BIunmatched
- Presentation/Verbal Skillsunmatched
- Problem Solving Skillsunmatched
- Python Programming/Scripting Languageunmatched
- Query Optimizationunmatched
- Reconciliationunmatched
- Relational Databases (RDBMS)unmatched
- Reliability Analysisunmatched
- Reporting Dashboardsunmatched
- Requirements Managementunmatched
- Riskunmatched
- SQL (Structured Query Language)unmatched
- SQL Databasesunmatched
- Sprint Planningunmatched
- Standup Meetingsunmatched
- Statisticsunmatched
- Stored Proceduresunmatched
- Technical Presentationunmatched
- Trend Analysisunmatched
- Writing Skillsunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder