Senior Data Analyst to support data analysis, requirements gathering, Source-to-Target Mapping (STTM), and data warehouse initiatives

We are seeking an experienced Data Analyst to support data analysis, requirements gathering, Source-to-Target Mapping (STTM), and data warehouse initiatives. The successful candidate will work closely with business stakeholders, data engineers, and architects to translate business requirements into accurate data mappings and technical specifications.

Duration - 12 months with a possibility of extension

Work Mode - remote , on site meetings one per month

Location - Montreal

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.

Must Haves

- Robust 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 Knowledge of Tools and Technology:

- ERWin
- Snowflake Snowsight
- Microsoft Excel and Word
- Python Notebooks

Nice to have

- 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

We are seeking an experienced Data Analyst to support data analysis, requirements gathering, Source-to-Target Mapping (STTM), and data warehouse initiatives. The successful candidate will work closely with business stakeholders, data engineers, and architects to translate business requirements into accurate data mappings and technical specifications.

Duration - 12 months with a possibility of extension

Work Mode - remote , on site meetings one per month

Location - Montreal

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.

Must Haves

- 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 Knowledge of Tools and Technology:

- ERWin
- Snowflake Snowsight
- Microsoft Excel and Word
- Python Notebooks

Nice to have

- 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

Disclaimer:

AI may be used in evaluating candidates.

This posting is for an existing vacancy.

📌 Senior Data Analyst to support data analysis, requirements gathering, Source-to-Target Mapping (STTM), and data warehouse initiatives (Montreal)
🏢 S.i. Systems
📍 Montreal