Data Analyst

iTeckSoft Inc.; Canada; On-site; CAD 75,000 - 95,000; Full time

Job summary

A technology company's data team in Canada is looking for a skilled Data Analyst to work on data-driven projects. The ideal candidate should have strong SQL skills, experience in data warehousing, and proficiency with ETL tools. As part of the team, you will analyze data from various sources, ensure data quality, and create insightful dashboards. This is a mid-senior level contract position focused on integrating and cleansing data for impactful reporting.

Qualifications

• Strong proficiency in SQL including joins and window functions.
• Hands-on experience with ETL tools and data warehousing.
• Knowledge of MDM, SCD, and CDC methodologies.

Responsibilities

• Analyze and transform data from multiple sources.
• Perform data profiling and quality checks.
• Develop SQL queries and optimize data processes.
• Create reports and dashboards for stakeholders.
• Implement data governance standards.

Skills

SQL proficiency

ETL tools experience

Data Warehousing concepts

Data cleansing

Deduplication methods

API-based data integration

Data quality frameworks

Analytical skills

Tools

Power BI

Tableau

Job description

This range is provided by iTeckSoft Inc. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$75,000.00/yr - $95,000.00/yr

Direct message the job poster from iTeckSoft Inc.

It is a CANADA requirement and the candidate has to be local to Canada.

Role Overview

We are seeking a skilled Data Analyst to join our team and work on data-driven projects involving data integration, cleansing, transformation, and reporting. The ideal candidate will have strong SQL expertise, experience with data warehousing, and proficiency in handling complex data scenarios.

Key Responsibilities

• Analyze, interpret, and transform data from multiple sources including APIs, files, and databases.
• Perform data profiling, cleansing, and quality checks before loading into Data Warehouse (DWH).
• Design and implement deduplication strategies and handle similar/identical records using SQL and ETL tools.
• Develop and optimize SQL queries, including joins, ranking functions (ROW_NUMBER(), RANK(), DENSE_RANK()), and aggregation logic.
• Create reports and dashboards ensuring accurate representation of data at different granular levels (customer, product, service).
• Implement MDM (Master Data Management) principles to maintain data consistency and accuracy.
• Handle Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) in ETL processes.
• Collaborate with stakeholders to understand requirements and deliver actionable insights.
• Automate data reconciliation scripts and ensure robust data quality checks post-load.
• Document processes, maintain audit trails, and adhere to data governance standards.

Required Skills

• Strong proficiency in SQL (joins, window functions, ranking, aggregation).
• Hands‑on experience with ETL tools and Data Warehousing concepts.
• Knowledge of MDM, SCD, and CDC methodologies.
• Experience in data cleansing, deduplication, and reconciliation.
• Familiarity with API-based data integration.
• Good understanding of data quality frameworks and automation techniques.
• Excellent analytical and problem‑solving skills.

Nice to Have

• Experience with BI tools (Power BI, Tableau, etc.).
• Knowledge of Python or other scripting languages for data processing.
• Exposure to cloud platforms (AWS, Azure, GCP).

Seniority level

Mid‑Senior level

Employment type

Contract

Job function

Consulting, Accounting/Auditing, and Engineering