Overview
Data Analyst Jobs in Canada at Hays
Title: Data Analyst
Company: Hays
Location: Canada
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
