Job opportunity
Data Analyst
iTeckSoft Inc.
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
#J-18808-Ljbffr
Apply on source site 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
#J-18808-Ljbffr