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.

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.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

dimensional modelingsemantic layer designanalytics enablementperformance tuningSQLSnowflakedbtPythonELTETL

Soft Skills

leadershipmentoringcoachinginfluencecollaborationcommunicationconsultingproblem-solvingstrategic thinkingcross-disciplinary teamwork