Strategic Data & Analytics Engineer (Cloud Data & Agentic Infrastructure)

SH/FT

United States

Remote

USD 120,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Remote flexibility
Collaborative culture

Job summary

SH/FT seeks a forward-thinking Data & Analytics Engineer to design, build, and maintain enterprise marketing data models, ontologies, and semantic context layers. You will bridge business goals with technical execution, partnering directly with clients to translate requirements into scalable, warehouse-native infrastructure.

Beyond core data engineering, you will shape how client data ecosystems adapt to an evolving AI-enabled landscape, architecting semantic models and data integration patterns

Qualifications

  • 5+ years of hands-on data engineering, analytics engineering, or data architecture experience.
  • Experience building production-grade data pipelines and semantic models.
  • Client-facing or consulting experience is a plus.

Responsibilities

  • Design and maintain enterprise marketing data models and semantic layers.
  • Lead cross-system data integration and ingestion pipelines.
  • Architect AI-enabled data readiness and context layers for autonomous agents.
  • Implement governance, catalogs, and security for self-service analytics.

Skills

SQL
Python/PySpark
dbt
Graph modeling

Tools

Databricks
Snowflake
Hightouch
Salesforce

Job description

The Role

We are seeking a forward-thinking, consultative Data & Analytics Engineer to design, build, and maintain enterprise marketing data models, ontologies, and semantic context layers. In this role, you will act as a strategic bridge between business leaders and technical execution-partnering directly with clients to understand their strategic goals and translating those business requirements into scalable, warehouse-native data infrastructure.

Beyond core data engineering, you will spearhead how our clients' data ecosystems adapt to an evolving agentic future. You will architect the semantic models and data integration patterns required to power autonomous AI agents, both native to modern cloud data platforms (such as Databricks and Snowflake) and across connected MarTech platforms (such as Salesforce, Hightouch).

What You'll Accomplish
  • Consultative Requirements & Architecture: Partner with key business stakeholders to uncover core business goals, mapping complex business domain needs into unified data engineering solutions, semantic layers, and robust warehouse architectures.
  • Agentic & AI Data Readiness: Architect forward-looking context layers and semantic models designed specifically for AI/LLM-driven engines and autonomous agents-ensuring data ecosystems (from modern cloud warehouses to activation platforms like Hightouch and Salesforce) are structured for reliable execution.
  • Taxonomy & Metadata Engineering: Design scalable data models (e.g. Medallion/Multi-layer architectures) to house controlled classification hierarchies, unified asset tags, and standardized business glossaries across marketing channels.
  • Identity & Semantic Modeling: Build and maintain deterministic and probabilistic identity resolution models and graph-like bridge tables to resolve customer identities across CRM IDs, device tokens, and digital touchpoints.
  • Cross-System Pipeline Integration: Lead the technical integration of complex cross-system datasets, developing high-performance ingestion and transformation pipelines to unify marketing metadata, CDP activation models, DAM content, and real-time telemetry.
  • Data Governance & Quality: Implement enterprise governance, business glossaries, access controls, and data cataloging (e.g., Unity Catalog, Snowflake Horizon) to enable secure self-service analytics and reliable AI execution.
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 t

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Strategist, Data & Analytics
Strategist, Data & Analytics

SH/FT • United States

On-site
USD 120,000 - 180,000
Data Engineer, AI & Analytics
Data Engineer, AI & Analytics

powerdigitalmarketing • United States

Remote
USD 110,000 - 180,000
Senior Data Engineer 2026 - US
Senior Data Engineer 2026 - US

Aimpoint Digital • United States

Remote
USD 140,000 - 190,000
Senior Data Engineer 2026 - US
Senior Data Engineer 2026 - US

Aimpoint Digital • Atlanta (GA)

Remote
USD 140,000 - 190,000
Lead Data Engineer
Lead Data Engineer

Aimpoint Digital • United States

Remote
USD 140,000 - 210,000
Manager, Data Engineering
Manager, Data Engineering

Bigcommerce • United States

Remote
USD 150,000 - 250,000
Remote Strategic Data & Analytics Engineer - AI-Ready
Remote Strategic Data & Analytics Engineer - AI-Ready

SHIFT Paradigm • United States

Remote
USD 120,000 - 140,000
Remote flexibility
Competitive compensation
Collaborative culture
+1
Lead Data Engineer 2026- US
Lead Data Engineer 2026- US

Aimpoint Digital • United States

Remote
USD 140,000 - 190,000
Analytics Engineer
Analytics Engineer

thesiscareers • New York (NY)

Hybrid
USD 120,000 - 150,000
Data Architect - Healthcare Insights, Revenue Cycle
Data Architect - Healthcare Insights, Revenue Cycle

Huron Consulting Group Inc. • Chicago (IL)

On-site
USD 150,000 - 210,000