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
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
