*Its 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).

iTeckSoft Inc.

Open Positions

Product Owner