Senior Data Analyst to support data analysis, requirements gathering, Source-to-Target Mapping (STTM), and data warehouse initiatives
Summary
A Senior Data Analyst bridges business needs and technical data solutions by gathering requirements, creating source-to-target mappings, and supporting data warehouse initiatives. Core work involves SQL, Snowflake, and data modeling to ensure accurate, high-quality data transformations and alignment with engineering processes.
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
- 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
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
AI may be used in evaluating candidates.
This posting is for an existing vacancy.