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 setting.
Required Skills and Experience:
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
Solid 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
📌 Data Analyst Hays Fredericton
🏢 Hays
📍 Fredericton
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.