Data Analyst

Role: Data Analyst Location: Remote Type: Contract Rate: CAD55/hr - CAD65/hr Key Responsibilities: Collaborate with business stakeholders to perform requirements analysis and refine functional and technical specifications Prepare Source-to-Target Mapping (STTM) documents with accurate data definitions, transformation logic, and mapping rules Analyze, interpret, and validate data to support business needs and data engineering processes Work closely with data engineers, architects, and business teams to ensure data quality and alignment with solution designs Support ETL/ELT development processes by providing detailed mapping, data rules, and validation inputs Participate in data model reviews and contribute to the design and improvement of data structures in the warehouse environment. Required Skills and Experience: Strong proficiency in SQL, with hands‑on experience using Snowflake (highly preferred) Solid understanding of data modeling techniques, including dimensional modeling, data vault modeling, and medallion architecture Good knowledge of ETL/ELT concepts, cloud data platforms, and modern data warehouse practices Experience working with structured and semi‑structured data Ability to document and communicate analytical findings and technical details clearly Strong problem‑solving skills and attention to detail Ability to work collaboratively with cross‑functional teams Preferred Qualifications: Experience with Snowflake-specific features (e.g., stages, virtual warehouses, Snowpipe) Experience with data integration tools (e.g., dbt, Databricks, Azure Data Factory, Talend) Knowledge of data governance and data quality frameworks Preferred Knowledge of Tools and Technology: ERWin Snowflake Snowsight Microsoft Excel and Word Python Notebooks