Data Analyst

Finance Professionals Inc.; Toronto; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading company in the finance sector is seeking a skilled Data Analyst for a 6-month hybrid role in Toronto. The ideal candidate will be proficient in SQL and SAS, with strong reporting experience in BI tools. This position offers the opportunity to work with diverse data sources and contribute to critical analytics projects.

Qualifications

• 5-7 years of business acumen experience required.
• 3-5 years of SQL experience necessary.
• 2-4 years of SAS knowledge preferred.

Responsibilities

• Perform analytics and data testing using SQL queries.
• Independently mine data from various sources.
• Generate reports using BI technologies like Tableau or Power BI.

Skills

SQL

SAS

Data Analysis

Business Acumen

Data Warehouse Knowledge

BI Technologies

Education

Business, Technology, Computer Science, or IT-related fields

Tools

Tableau

Power BI

Oracle BI

Microsoft Reporting Services

Job description

Duration: 6 Months (possible extension or FTE conversion)

Hybrid: 2/3 days per week

Essential Program/Technology/Software Knowledge

• Proficient in SQL and knowledgeable of relational database concepts and design, data manipulation, and summarization. Ability to perform analytics and data testing leveraging SQL queries.
• Ability to independently mine data across all data sources.
• Proficient in SAS.
• Extensive experience with reporting capabilities using BI technologies such as Tableau, Microsoft Reporting Services, Oracle BI, or Power BI.
• Thorough working knowledge of Data Warehouse (e.g., IDM, EDW, etc.).

Must-Have Skills/Experience/Education

• Business Acumen (minimum 5-7 years)
• Proven SQL knowledge (minimum 3-5 years)
• SAS knowledge (minimum 2-4 years)
• Experience with OBIEE/OAS Reporting Suite (minimum 4-6 years)
• Proven analytical capabilities (minimum 3-5 years)

Nice-to-Have Skills/Experience/Education

• Background in BI reporting
• Educational background in Business, Technology, Computer Science, or IT-related fields.
• Prior experience in the Banking Industry
• Knowledge of Tableau
• Knowledge of Power BI
• Knowledge of Python