Data and analytics engineer building semantic models, pipelines, and AI-ready infrastructure. Supporting SH/FT’s consultancy work for enterprise marketing and technology clients.
Responsibilities
Partner with business stakeholders to uncover business goals and translate domain needs into unified data engineering solutions, semantic layers, and warehouse architectures
Architect context layers and semantic models for AI/LLM-driven engines and autonomous agents
Design scalable taxonomy and metadata data models using architectures such as Medallion/Multi-layer
Build and maintain deterministic and probabilistic identity resolution models and graph-like bridge tables
Lead integration of complex cross-system datasets
Develop high-performance ingestion and transformation pipelines unifying marketing metadata, CDP activation models, DAM content, and real-time telemetry
Implement enterprise data governance, business glossaries, access controls, and data cataloging
Enable secure self-service analytics and reliable AI execution
Partner directly with clients to understand strategic goals and translate requirements into scalable, warehouse-native infrastructure
Requirements
5+ years of hands-on experience in data engineering, analytics engineering, or data architecture building production-grade data pipelines and semantic models
2+ years in a client-facing, consultative, or strategic lead role
Ability to run discovery, map business goals to technical architectures, and present solutions to cross-functional stakeholders
Ability to translate non-technical business strategies into clear technical specifications and articulate technical trade-offs
Understanding of agentic AI concepts and how data modeling, semantics, and context layers support autonomous workflows
Hands-on experience designing production pipelines and semantic data models across modern cloud data platforms
Deep expertise in Databricks, Snowflake, or equivalent architectures
Proficiency in SQL, Python/PySpark, data pipeline orchestration, and modern data stack tooling such as dbt
Experience with MarTech, CDPs, reverse ETL tools such as Hightouch or Census, and enterprise platforms such as Salesforce Marketing Cloud and CRMs
Proven experience in multi-dimensional schema design, identity resolution modeling, graph/hierarchical structures, and API payload parsing (nested JSON/REST)
Databricks, Snowflake, or dbt certifications preferred
Ability to manage complex deliverables independently in a distributed, fast-paced environment
Current US or Canada work authorization required
No relocation assistance available
Benefits
Competitive compensation aligned with your experience and impact
Remote flexibility
Collaborative culture that values diverse perspectives and innovative thinking
Marketing Data Analytics Engineer building Salesforce, Marketo, and warehouse pipelines for PointClickCare’s healthcare analytics platform. Automating campaign reporting and supporting marketing - sourced pipeline insights.
Senior Analytics Engineer designing Lime’s finance - grade data warehouse and semantic layer. Ensuring governed, audit - ready reporting for the global shared micromobility business.
Analytics Engineer building Snowflake and dbt data platforms for Tucows’ Internet businesses. Applying AI, SQL, Looker, and Python to drive data - informed decisions.
Senior Analytics Engineer designing financial, GTM, and product data models for Lightspeed’s cloud commerce platform. Owning pipelines, documentation, and analytics foundations used across the business.
Senior Analytics Engineer building scalable data pipelines and AI - native analytics foundations at Mercury, a fintech company. Supporting agentic tooling, self - service analytics, governance, and data products.
Senior Business Systems Analyst modernizing Boeing Canada’s defence sustainment systems and cloud data platforms. Translating mission needs into requirements, analytics, integrations, and reporting solutions.
Senior Analytics Engineer building GTM pipelines, metrics, dashboards, and AI data tools. Supporting Motive’s platform for safer, more productive physical operations.
Data Analytics Engineer building trusted SQL data systems for Toptal, a global talent network. Owning transformation, governance, warehousing, and AI - enabled analytics foundations.
Analytics Engineer building dbt models, AI - ready datasets, and Tableau reporting for Movable Ink’s content personalization platform. Translating stakeholder needs into trusted metrics and business intelligence.