Senior Data Engineer – Data Platform, Semantic Architecture

Role Overview

• Together with Engineering and Data Modeling leaders, define and evolve enterprise standards for dimensional modeling, semantic layers, and analytics-ready data platforms.
• Serve as a design authority for complex operational, analytic, data pipeline, and semantic architectures, reviewing and approving high‑impact solutions
• Guide engineers on technical solutions and techniques to optimize compute and storage cost.
• Oversee design and optimization of scalable ELT/ETL pipelines and data products, with a focus on reliability, performance, and cost efficiency.
• Drive platform observability, proactive data quality monitoring, and automated validation frameworks.
• Lead performance tuning efforts for Snowflake tables, views, materialized views, and semantic access patterns.
• Guide the design and implementation of enterprise semantic models on Snowflake, including facts, dimensions, metrics, and governed business logic.
• Collaborate with the Data Product and Data Modeling teams to establish patterns for metric definitions, conformed dimensions, and reusable semantic assets.
• Partner with Enterprise and Domain Architects to ensure semantic consistency, interoperability, and scalability
• Ensure semantic layers are optimized for BI tools, self‑service analytics, and agentic/AI consumption.
• Enable trusted data foundations for agent‑based analytics and AI assistants, ensuring semantic models are consumable by LLMs and analytic agents.
• Collaborate with platform and AI teams to define contracts, metadata, and observability required for intelligent agents.
• Influence responsible AI usage by embedding governance, lineage, and explainability into semantic designs.
• Champion data governance, security, and compliance across operational, analytical, semantic, and agentic platforms.
• Ensure solutions meet healthcare and regulated‑industry expectations for auditability and reliability.

Requirements

• Bachelor’s degree in computer science, Mathematics, Business Administration, Engineering, or a related field
• 8 years relevant experience in a multi-platform environment, including, but not limited to application development or database development
• At least 2 years working with Snowflake or similar cloud data platforms
• Senior or principal-level experience in Data Engineering or Data Platform Engineering.
• Deep expertise in dimensional modeling, semantic layer design, and analytics enablement.
• Advanced proficiency with Snowflake, dbt, and SQL, including performance tuning at scale.
• Hands-on experience with at least one enterprise semantic technology (e.g., Snowflake semantic views, AtScale semantics, dbt semantics, MicroStrategy Architect / Semantic Graph, Business Objects Universes.
• Proven ability to lead through influence across teams and disciplines.
• Strong mentoring and coaching skills, particularly with senior engineers.
• Demonstrated success driving standards, patterns, and long‑term platform strategy.
• Consulting or cross‑industry background bringing diverse perspectives to complex data ecosystems.
• Experience supporting AI‑enabled analytics, agentic workflows, or metadata‑driven systems.
• Python development for data engineering, automation, or platform tooling.
• Experience integrating semantic layers with BI tools such as Tableau, Power BI, or Looker.

Tech Stack

• Cloud
• ETL
• Python
• SQL
• Tableau

Benefits

• Medical, dental and vision coverage for employees and their eligible family members, including mental health benefits.
• Annual employer contribution to a health savings account.
• Generous paid time off varying by role and tenure in addition to 10 company-paid holidays.
• Market-leading retirement plan including a company match on employee 401(k) contributions, with a potential discretionary contribution based on company performance (no vesting period).
• Up to 12 weeks of paid parental time off (eligibility requires 12 months of continuous service with Cambia immediately preceding leave).
• Award-winning wellness programs that reward you for participation.
• Employee Assistance Fund for those in need.
• Commute and parking benefits.