Senior Data Architect — Snowflake, dbt & Pipelines (Hybrid)

Socket.dev; Montreal (administrative region); Hybrid; CAD 100,000 - 160,000; Full time

Benefits offered by this job

Hybrid work: 3 days/week in Montreal/T

Mental health support

Fully funded insurance

Health spending account

4 weeks vacation

Wellness days

RRSP matching

Coursera learning budget

Parental leave top-up

Job summary

Socket.dev is seeking a Senior Data Developer to advance our data product catalogue. You will model data in a cloud-based warehouse, build scalable data pipelines, and contribute to governance and privacy practices.

The role emphasizes collaboration with data analysts, developers, and product managers in an agile setting. You will design and optimize data warehouses, implement observability, and lead end-to-end data flow from raw sources to client-ready datasets, ensuring reliability and

Qualifications

• Minimum 3 years of meaningful experience in data or engineering roles.
• Experience with data modeling techniques and building well-structured transformation layers in dbt and Snowflake.
• Familiarity with BI-as-code tools and translating business requirements into data models for BI consumption.
• Strong collaboration, communication skills and willingness to share knowledge for continuous improvement.
• Understanding of data governance and privacy, especially with health-related data.

Responsibilities

• Develop and maintain data warehouse modelling, optimizing for utility, extensibility, and performance across staging, intermediate, and mart layers, transforming raw data into curated datasets for reporting and SOW reporting using dbt and Snowflake.
• Implement observability for data pipelines with logging, data quality checks, freshness monitoring, and alerting.
• Develop and own batch and event-driven data pipelines (Snowpipe, EventBridge) powering eligibility management and engagement reporting.
• Participate in code reviews and technical design discussions to ensure high-quality, maintainable data products.
• Champion data governance and privacy practices, including anonymization standards and access controls.

Skills

Data modeling

Dimensional modeling

Slowly changing dimensions

Star schema

Data quality

Tools

dbt

Snowflake

Snowpipe

EventBridge

Job description

Socket.dev is seeking a Senior Data Developer to advance our data product catalogue. You will model data in a cloud-based warehouse, build scalable data pipelines, and contribute to governance and privacy practices.

The role emphasizes collaboration with data analysts, developers, and product managers in an agile setting. You will design and optimize data warehouses, implement observability, and lead end-to-end data flow from raw sources to client-ready datasets, ensuring reliability and