Senior Financial Analyst, Reporting

The Brick; Toronto; On-site; CAD 65,000 - 85,000; Full time

Job summary

A leading retail company in Toronto is seeking a detail-oriented Reporting Analyst to support decision-making through data analysis. The role involves developing reports, collaborating with IT on cloud migrations, and ensuring data integrity. Ideal candidates will have a Bachelor's degree and strong skills in Excel, Oracle SQL, and data visualization tools. This position is critical for driving data strategy and requires excellent communication and analytical abilities.

Qualifications

• Bachelor’s degree preferred, on-job experience considered.
• Proficiency in Excel with VBA coding and data sources.
• Experience with Oracle SQL and MS SQL.

Responsibilities

• Support Finance, Business, and Analytics teams with data preparation and reporting.
• Lead the development of data assets for enterprise use.
• Collaborate with IT on data migration to cloud.

Skills

Excel proficiency

Oracle SQL proficiency

Cognos Analytics

Data visualization tools

Communication skills

Analytical skills

Education

Bachelor’s degree in Business, Data Analytics, Statistics, Engineering, Computer Science or related fields

Tools

Power BI

Microsoft Office

Jira

Job description

Is this job for you?

We are seeking a detail-oriented and analytical Reporting Analyst to collect, analyze, and present data that supports informed decision‑making. The ideal candidate will have strong technical skills, a keen eye for accuracy, and the ability to translate complex data into clear, actionable insights.

Responsibilities

• Develop a deep understanding of Retail data to support Finance, Business and Analytics teams with data preparation, organization, quality control, reporting, and governance
• Lead the development of productionized data assets consumable by the enterprise
• Establish robust documentation including business rules, data lineage maps, script summaries to facilitate questions from business teams on data fields and derived metrics
• Produce and distribute key reporting on foundational data metrics to Sr. Executive audience. Automate practices to establish consistency and increase efficiency within team of data analysts and engineers
• Provide creative solutions, recommendations and timely advice that solve problems through data management and engineering
• Facilitate data reviews which maintain integrity of metric production and reporting
• Collaborate with IT and Enterprise teams supporting the migration of data assets into cloud
• Gather, validate, and analyze data from multiple sources
• Develop and maintain reports, dashboards, and visualizations for stakeholders
• Identify trends, anomalies, and opportunities through data analysis
• Collaborate with cross‑functional teams to understand reporting needs
• Ensure data integrity, accuracy, and compliance with company standards
• Automate recurring reports to improve efficiency

Qualifications

• Bachelor’s degree in Business, Data Analytics, Statistics, Engineering, Computer Science or related fields. On‑job experience preferred
• Proficiency in Excel with detailed knowledge of VBA coding, Power Queries, Power Pivots and external data sources
• Proficiency in Oracle SQL and MS SQL with attention to data mining ETL coding including competency in comparative analytics
• Proficiency in Cognos Analytics version 11.2.4 FP6 and higher. In depth understanding of Transformer and Framework modeling and Application reporting capabilities
• Understanding of data source structures, indexes and performance tuning
• Understanding of Azure Data Lake and pipeline processes with the ability to build and monitor data and timing
• Knowledge of Jira and/or other Sprint Planning Software
• Proficiency in Microsoft Office applications and data visualization tools (e.g., Power BI)
• Sound knowledge of database technologies; able to communicate with staff to challenge processes and solve complex problems
• Seasoned experience in developing and driving data strategy
• Excellent communication skills, with the ability to communicate both technical and business concepts, as well as strong presentation skills
• Strong analytical, problem‑solving, and communication skills
• Ability to manage multiple priorities and meet deadlines
• Experience with data governance and quality assurance is an asset