Data Analyst

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; Hybrid; CAD 61,992 - 68,880; Full time

Job summary

A leading IT consulting service is seeking a Data Analyst in Toronto, Ontario. The role involves working in a hybrid setting with two days in the office per week. The ideal candidate will have 8-10 years of experience in finance and data analysis, along with expertise in Informatica PowerCenter and SQL. Responsibilities include documenting data definitions, applying data quality standards, and performing end-to-end data analysis. A competitive salary of CA$45.00 - CA$50.00 per hour is offered.

Qualifications

• 8-10 years in finance and data analysis roles.
• Experience with data quality and governance.
• Proficiency in Informatica PowerCenter and SQL.

Responsibilities

• Document data dictionaries and mappings for banking domain.
• Translate business needs into technical specifications.
• Validate ETL loads and troubleshoot data discrepancies.

Skills

Strong documentation skills

Problem-solving skills

Collaboration

Tools

Informatica PowerCenter

SQL

Databricks (PySpark)

Azure

Job description

Data Analyst (Hybrid - 2 days in office/week)

Location: Toronto, Ontario, Canada

Salary: CA$45.00 - CA$50.00 per hour

Posted 2 weeks ago. Be among the first 25 applicants.

Experience

8-10 years in finance and data analysis roles.

Responsibilities

• Document data dictionaries, metadata, requirements, and mappings for banking domain.
• Apply data quality and data governance principles, including metadata lineage and security standards across cloud and on‑prem platforms.
• Translate business needs into detailed functional and technical specifications for Informatica PowerCenter mappings, workflows, and transformations.
• Validate ETL loads, troubleshoot data discrepancies, and collaborate with technical teams to resolve issues.
• Support development, testing, and implementation of Informatica PowerCenter jobs, ensuring alignment with business rules and data governance standards.
• Perform end‑to‑end data analysis, including source‑to‑target mapping, data profiling, and gap identification using Informatica and SQL.
• Understand how data is structured, connected, governed, and used across data products.
• Leverage data models, product lifecycle knowledge, and stakeholder management experience.
• Ingest and transform large datasets using Databricks (PySpark, SQL) and Informatica PowerCenter workflows.
• Create comprehensive Incoming Data Collections (IDCs) for cloud ingestion, outlining data sources, ingestion frequency, file formats, orchestration, and Azure target layers.

Qualifications

• Strong documentation skills (data dictionaries, metadata, requirements, mappings).
• Experience with data quality, data governance, lineage, and security standards.
• Proficiency in Informatica PowerCenter and SQL for mappings, workflows, and transformations.
• Knowledge of cloud (Azure) and on‑prem data platforms.
• Experience with Databricks (PySpark, SQL) for large data ingestion.
• Excellent problem‑solving skills and ability to work cross‑functionally.

Seniority & Employment

• Seniority level: Mid‑Senior level
• Employment type: Full‑time
• Job function: Information Technology
• Industry: IT Services and IT Consulting

Referrals increase your chances of interviewing at Astra‑North Infoteck Inc.