Data Analyst

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