Search jobs

What You Bring

Experience & Expertise

• 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—demonstrated ability to run discovery, map business goals to technical architectures, and present solutions to cross-functional stakeholders.
• Willing to travel 25% a year and up to twice a quarter minimum.
• Consultative Mindset: Strong ability to navigate ambiguity, translate non-technical business strategies into clear technical specifications, and articulate technical trade-offs to executives and cross-functional teams.
• Strategic Vision for AI/Agents: A keen interest in the shift toward agentic AI, with an understanding of how data modeling, semantics, and context layers must adapt to support autonomous workflows across data platforms and marketing engines.
• Cloud Data Platform Expertise: Hands-on experience designing production pipelines and semantic data models across modern cloud data platforms, with deep expertise in Databricks, Snowflake, or equivalent architectures.
• Advanced Data Engineering Skills: Proficiency in SQL, Python/PySpark, data pipeline orchestration, and modern data stack tooling (e.g., dbt).
• Domain & Integration Knowledge: Experience with marketing technology (MarTech), Customer Data Platforms (CDPs), reverse ETL tools (e.g., Hightouch, Census), and enterprise platforms (e.g., Salesforce Marketing Cloud, CRMs).
• Data Modeling Fundamentals: Proven track record in multi-dimensional schema design, identity resolution modeling, graph/hierarchical structures, and API payload parsing (nested JSON/REST).
• Relevant Certifications (Preferred): Professional Data Engineer / Analytics Engineer certifications in Databricks or Snowflake.

Preferred Certifications

• Databricks: Certified Data Engineer Professional or Certified Analytics Engineer.
• Snowflake: SnowPro Core or SnowPro Advanced Architect.
• dbt: dbt Cloud Developer Certification.

Mindset

• Forward-Thinking AI Perspective: Active interest and practical awareness of agentic AI concepts (e.g., tool use, LLM context retrieval, autonomous agent workflows) and how data modeling must evolve to serve them.
• Remote & Autonomous: Ability to manage complex deliverables independently in a distributed, fast-paced environment.

What We Offer

• Competitive compensation aligned with your experience and impact
• Remote flexibility
• Collaborative culture that values diverse perspectives and innovative thinking
• Work that makes a measurable difference for your clients

Why SH/FT

SH/FT is a consultancy built for transformation. We bridge the gap between marketing, data, and technology to unlock growth for some of the world's most recognized brands. At SH/FT you'll shape the future of how organizations connect with their customers through intelligent architecture, scalable systems, and the power of data-driven strategy.

Comp & Benefits

The US salary range for this role is $120,000 to $140,000 USD. Salary is based on several factors including but not limited to skillset, relevant education, level of experience, certifications, and scope of responsibilities.

In addition to base salary, SH/FT offers benefits such as medical, dental, vision, STD/LTD, Life/AD&D, Flexible Paid Time Off, and various other ancillary benefits and perks.

We welcome and encourage applications from people with disabilities under the Accessibility for Ontarians with Disabilities Act. Accommodations are available on request for candidates taking part in all aspects of the selection process.

Candidates must have current US or Canada work authorization. For US candidates, this employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the US.

No relocation assistance can be offered at this time.

All inquiries are held in strict confidence.