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/yrDirect 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 ResponsibilitiesAnalyze, interpret, and transform data from multiple sources including APIs, files, and databases.Performdata profiling, cleansing, and quality checksbefore loading into Data Warehouse (DWH).Design and implementdeduplication strategiesand handle similar/identical records using SQL and ETL tools.Develop and optimizeSQL 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).ImplementMDM (Master Data Management)principles to maintain data consistency and accuracy.HandleSlowly Changing Dimensions (SCD)andChange Data Capture (CDC)in ETL processes.Collaborate with stakeholders to understand requirements and deliver actionable insights.Automatedata reconciliation scriptsand ensure robust data quality checks post-load.Document processes, maintain audit trails, and adhere to data governance standards.Required SkillsStrong proficiency inSQL(joins, window functions, ranking, aggregation).Hands‑on experience withETL toolsandData Warehousing concepts .Knowledge ofMDM ,SCD , andCDCmethodologies.Experience indata cleansing, deduplication, and reconciliation .Familiarity withAPI-based data integration .Good understanding ofdata quality frameworksand automation techniques.Excellent analytical and problem‑solving skills.Nice to HaveExperience 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 levelEmployment type ContractJob function Consulting, Accounting/Auditing, and Engineering#J-18808-Ljbffr