Senior Data Analyst and Reporting

Job#: 3027201
Job Description:
Senior Data Analyst and Reporting
Client:
Big 5 Bank
Location
: Hybrid; 2-3 days a week in Toronto

• (Monday and Tuesday/ week and 1 Friday a month

Terms
: 4 Month Contract,

• Strong possibility of extension based on project budget & candidate performance.

Hours:
37.5 hours/week Monday-Friday, 9:00 am - 5:00 pm
Team:

• Foundational transformation initiatives across the bank, including a strong focus on AI-related programs. The team drives enterprise programs involving resourcing, capacity planning, portfolio management, and AI rollout initiatives.

Who Will the Candidate Be Working with on a Daily Basis?

• Works closely with senior leadership and the broader team on requirements gathering, report creation, presentation, and maintenance
• Regular interaction with the Hiring Manager, senior managers/directors, and executives (VPs, SVPs, EVPs)

What you will be doing:

• Require to track, report and present on multiple Program/Portfolio datasets including resourcing, efficiencies, benefits
• Work is Data Analysis, status reporting, creating different dashboards for Executives, senior management and team level, so data and presentation must be accurate and professional.
• Will work closely with the Senior leadership and Team for Requirements gathering and Report creation/presentation, maintenance

Responsibilities:

• Build and maintain Power BI reports, dashboards (existing and new)
• Transform manual spreadsheet-based reports into automated, scalable Power BI solutions for dynamic and weekly/monthly team or executive reporting.
• Gather and document requirements; design reporting solutions
• Validate, clean, and reconcile asset inventory data to ensure accuracy for compliance, audit, and lifecycle reporting.
• Collaborate with teams to understand data context and support remediation planning.
• Use advanced Excel (pivot tables, VLOOKUP/XLOOKUP, macros) to prepare and QA data before ingestion into Power BI.
• Identify inefficiencies in current reporting workflows and recommend/support process improvement, automation, and data-quality enhancements.
• Troubleshoot data issues, perform root-cause analysis, and ensure dashboards refresh reliably, efficiently and accurately.
• Prepare training materials, documentation and operational guides
• Provide training on usage of Power BI to team members (where applicable)

Must Have Requirement:

• 4+ yrs as a Data Analyst for reporting
• Strong Power BI experience building and maintaining dashboards, including cost/benefit or financial reporting
• Advanced Excel expertise (pivot tables, VLOOKUP/XLOOKUP, macros, automation) used to prepare, validate, and QA data for Power BI
• Proven experience automating manual spreadsheet reports into scalable Power BI solutions
• Banking (ideally top 5 banks but not mandatory) or regulated financial services experience using Power BI for reporting and analysis
• Solid understanding of business analysis, data quality, reconciliation, and reporting with imperfect data
• Ability to troubleshoot data issues, perform root cause analysis, and ensure reliable dashboard refreshes
• Experience collaborating with teams to understand data context and support remediation
• Comfortable working in a fast paced, motivated team environment
• Proficiency with PowerPoint, JIRA, and SharePoint
• Undergraduate degree (Bachelor’s degree)
• Aptitude and attitude are critical – highly motivated team environment; candidate must be proactive, driven, and able to navigate ambiguity

Nice to Have:

• Financial banking experience

Apex pay scales are determined by role, experience, skill set, and location. For this new position, the estimated hourly range is provided below as a guideline; however, total compensation may vary based on individual circumstances.

• Role Type: Current opening
• Location: Ontario
• Hourly Range: $40-45/hr

EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click here for more details.
Apex Benefits Overview:
In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA.
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click here for more details.
Apex Benefits Overview:
In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA.
Apex Systems is part of the Commercial Segment of ASGN Incorporated.
NYSE: ASGN
4400 Cox Road
Suite 200
Glen Allen, Virginia 23060
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Benefits Department at [email protected] or 804-523-8228. (Do not submit resumes or solicit consultants to this email address). UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Apex Systems.