Business Data Analyst

Tekgence Inc; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A technology consulting firm in Toronto is seeking a Business Data Analyst with 5-10 years of experience, preferably in the Life Insurance and Wealth Management sector. The ideal candidate will excel in writing complex SQL queries and have knowledge of Azure Data Tools. This role requires onsite presence three days a week and involves analyzing data to provide insights, working on Azure projects, and delivering documentation. Competitive compensation and professional development opportunities are offered.

Qualifications

• 5–10 years experience as a Business Data Analyst in Life Insurance/Wealth Management.
• Experience with Azure data-centric projects and data documentation artifacts.
• Excellent verbal and written communication skills.

Responsibilities

• Analyze data and generate insights using SQL.
• Work on data-centric projects with a focus on integration and warehousing.
• Deliver documentation artifacts within project deadlines.

Skills

Writing complex SQL queries

Experience with Databricks

Knowledge of Azure Data Tools

ETL processes

Job description

Business Data Analyst

Location: Toronto, ON

Duration: 6-12 months

Experience: 6-8 years

Industry: BFSI

Role: Business Data Analyst - 3 days onsite (Tue, Wed, Thu)

Roles & Responsibilities

• 5–10 years experience as a Business Data Analyst, preferably in the Life Insurance / Wealth Management domain (Retail, Retirement, Institutional, or General Accounts)
• Experience with Azure data-centric projects, including Master Data Management, Data Integration, Data Warehousing, and Reporting, preferably within capital markets or investment banking environments
• Proficiency in writing complex SQL queries to analyze data and generate insights for business users or project teams
• Experience delivering data documentation artifacts within organizations of similar size and complexity, adhering to project deadlines
• Excellent verbal and written communication skills across various levels of project teams
• Experience with major trading platforms and book of record systems such as Bloomberg Polar Lake, SimCorp Dimension, Findur, Apex, Eagle, Charles River, Sylvan, and Calypso

Required Qualifications

• Proficiency in writing complex SQL queries
• Experience with Databricks
• Knowledge of Azure Data Tools including Azure Data Factory, Azure Data Studio, Azure Data Lake Storage, and Azure Synapse Analytics

Additional Skills

• Experience with ETL processes