20 Nov
|
Envision Technology Solutions
|
Canada
20 Nov
Envision Technology Solutions
Canada
Key Responsibilities
- Own and drive end-to-end data architecture and data modelling.
- Lead discussions with business and technology stakeholders to understand requirements, clarify business rules, resolve ambiguities, and eliminate gaps.
- Design logical and physical data models, including fact and dimension tables, relationships, data grain, keys, and hierarchies.
- Define data warehouse architecture, data integration patterns, transformation logic, and data structures.
- Leverage Snowflake to design and optimize scalable data warehouse solutions.
- Translate architecture and data models into actionable development specifications and implementation plans.
- Guide offshore development teams, address technical queries, review design and implementation, and resolve technical blockers.
- Ensure development adheres to the approved architecture, modelling standards, and data quality requirements.
Required Skills & Experience
- 8+ years of experience in data engineering, data architecture, and enterprise data warehousing.
- Mandatory hands-on experience with
Snowflake
, including schema design,
SQL development, and performance optimization.
- Strong expertise in conceptual, logical, and physical data modelling, dimensional modelling, Star/Snowflake schemas, fact and dimension tables, and SCD.
- Strong SQL skills and understanding of ETL/ELT, data integration, and transformation processes.
- Proven ability to convert business requirements into detailed data models and technical designs.
- Excellent stakeholder management and communication skills, with experience leading technical discussions and driving design decisions.
- Experience providing technical direction and guidance to offshore development teams.
Positive to Have
- Exposure to
Snowplow and event-tracking data architecture.
- Experience with streaming data ingestion technologies such as Kafka or AWS Kinesis.
- Exposure to dbt, Airflow, and cloud data platforms (AWS, Azure, or GCP).
- Knowledge of data governance, lineage, and data quality frameworks.
📌 Data Lead Snowflake (Canada)
🏢 Envision Technology Solutions
📍 Canada