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