Semantic Layer

Semantic Layer Data Jobs

4 jobs found

1mo ago

Senior Analytics Engineer

Orchard New York, NY

New York, NY

1mo ago Closed

$135k - $180k/yr Full time Senior Analytics Business Intelligence

This position is no longer accepting applications (closed Jul 3, 2026).

Job Description

Orchard seeks a Senior Analytics Engineer in New York, NY (hybrid) to rebuild how the business derives answers from data and to own the analytics platform roadmap end to end.

Responsibilities

Own the major analytics platform initiatives from scoping to delivery, collaborating with the Director to shape future roadmap directions.
Ingest new data sources and deliver production gold-tier dbt models that the company can rely on, balancing speed and quality.
Author and maintain the prose semantic layer with markdown documentation describing model meanings, metric definitions, historical decisions, and known landmines.
Develop and tune the LLM-powered query layer, including prompt design, retrieval workflows, evaluation, and the feedback loop when results are incorrect.
Deploy and calibrate agents that monitor certified dashboards for anomalies and trend shifts, refining them until executives trust the alerts and act upon them.

Requirements

4+ years in analytics engineering, data engineering, or a hybrid data role, including ownership of a significant data platform or end-to-end migration.
Deep dbt and SQL fluency with strong opinions about data grain, testing, documentation, and the limits of each approach.
Experience working in Redshift or a comparable data warehouse at scale.
Built something useful with LLMs against your own data and have opinions about what works; hands-on experience with retrieval or evaluations is a plus.
Clear technical writing ability; able to explain a metric in a paragraph that an executive can read.
Proven track record of owning technical decisions and bringing stakeholders along across the organization; able to push back when data does not support requests while maintaining collaboration.

Technologies

Looker
dbt
SQL
Redshift
LLM

Compensation

Salary: USD 135,000 - 180,000 per year

Benefits

Stock options
Incentive pay
Medical benefits
Financial benefits
Other benefits

View full job page →

1mo ago

Analytics Engineer, Data Platform

AndHealth Columbus, OH

Columbus, OH

1mo ago Closed

Full time Analytics Business Intelligence Data

This position is no longer accepting applications (closed Jun 23, 2026).

Job Description

The Analytics Engineer, Data Platform at AndHealth designs and maintains dbt models and ETL pipelines, and develops the semantic layer for self-service analytics across clinical, pharmacy, billing, and care operations.

Responsibilities

Create, implement, and maintain dbt models to transform raw data from clinical, pharmacy, billing, and care operations into clean, domain-specific data marts.
Collaborate with Data and Software Engineering on ETL/ELT pipeline design, data ingestion, and raw-to-staging transformations to ensure data is delivered in a usable form for analytics engineers.
Develop and own the semantic layer in Omni by defining governed metric definitions, curated datasets, and self-service data products that analysts and stakeholders can consume directly.
Build a comprehensive testing suite across the data platform, including schema tests, data quality checks, anomaly detection, and SLA monitoring to foster trust in the data.
Implement and maintain data governance practices such as lineage documentation, cataloging, access control, and column-level documentation in dbt.
Become a domain expert in the assigned area (pharmacy operations, billing, or care operations) by thoroughly understanding business logic and translating it into accurate, scalable data models.
Collaborate with analysts to understand data needs, accelerate workflows, and reduce time spent on ad hoc data prep, enabling focus on higher-order analysis and strategy.
Contribute to platform level decisions including warehouse organization, modeling conventions, CI/CD for dbt, and tooling standards across the analytics engineering team.
Proactively identify data quality issues, gaps in coverage, and opportunities to improve the reliability and usability of the data platform.

Requirements

Strong SQL proficiency with the ability to write complex queries, CTEs, window functions, and performance-optimized transformations across large datasets.
Hands-on experience with dbt (Core or Cloud): understanding of the modeling layer, ref() dependencies, tests, macros, and structuring a well-organized dbt project.
Solid understanding of data warehouse concepts, including dimensional modeling, mart layers, slowly changing dimensions, and staging/intermediate/mart separation.
Experience with ETL/ELT pipelines and partnering with data or software engineers on data ingestion.
Comfort with the command line, including running scripts, managing files, and troubleshooting basic shell operations.
Strong analytical instincts: ability to interrogate data, identify anomalies, trace root causes, and communicate findings to technical and non-technical audiences.
Ability to operate in ambiguous, fast-moving environments with competing priorities.
Bachelor's degree in Computer Science, Economics, Engineering, Mathematics, or a related quantitative field, or equivalent.

Technologies

SQL
dbt
Omni
Looker
Metabase
Python

Benefits

Equal investment and support for our people and patients
A fun and ambitious start-up environment with a culture that takes on big things, takes risks, and learns quickly
Opportunities to demonstrate creativity, innovation, and conscientiousness, and to collaborate effectively
A team of highly skilled, welcoming, and supportive colleagues with diverse strengths
Commitment to ongoing learning and growth, both personally and professionally
Full-time employees are eligible for a benefits package including Medical, Dental, and Vision Insurance, Paid time off, Short- and Long-Term Disability, and more

View full job page →

1mo ago

Technical Data and Analytics Product Manager II - Senior

Cambia Health Solutions Portland, OR

Portland, OR

1mo ago Closed

$104k - $228k/yr Full time Ai Workflows Analytics Business Analytics

This position is no longer accepting applications (closed Jun 22, 2026).

Job Description

The Senior Technical Data and Analytics Product Manager II at Cambia Health Solutions leads Snowflake native data, analytics, and semantic initiatives across the enterprise. This role owns the product roadmap and governance for data products and AI-enabled offerings, partnering with business stakeholders, data engineers, and analytics consumers in a hybrid environment based in Portland, Oregon. The position offers a salary range of USD 104,000 to 228,000 per year and requires a bachelor’s degree with a minimum of five years of relevant experience.

Responsibilities

Own the delivery roadmap for data, analytics, and semantic products within an assigned subset of the enterprise data domain, guiding how trusted data products are defined, governed, and delivered to business users and AI systems.
Balance near-term value with long-term platform coherence by leading the roadmap for data, analytics, and semantic offerings across the designated business domains.
Lead stakeholder engagement across business partners, data engineering, and analytics consumers to identify opportunities where governed data and AI capabilities yield measurable outcomes.
Collaborate with Semantic Analysts, Data Engineers, and AI product teams to translate business intent into well-defined semantic models, metric definitions, and context layers on the Snowflake platform (dbt Semantic Layer, Snowflake Cortex, Sigma).
Develop a deep understanding of enterprise strategy and domain priorities to surface opportunities where applied AI, semantic intelligence, and analytics accelerate decision-making at scale.
Steer product decisions across the semantic layer, including entity definitions, metric governance, ontology design, and the organizational context layer that supports AI agent reasoning.
Prioritize features by balancing business and technical objectives, serving both human consumers (analysts, operators) and machine consumers (Cortex agents, AI workflows).
Coordinate across the broader data and analytics landscape to sequence initiatives strategically, reduce definitional fragmentation, and maximize platform-wide impact.
Translate business requirements into concrete product specifications, prototypes, semantic contracts, data quality SLAs, and AI-ready context specifications.
Partner with TPMs and engineering to manage complex product and technical decisions within an agile delivery framework.
Align with internal and external partners (Snowflake, Sigma, dbt Labs) on platform capabilities, roadmap integration, and joint development opportunities.
Define and communicate product success metrics, including semantic layer adoption, metric trust scores, AI agent accuracy, and analytics platform utilization, driving continuous improvement based on these signals.

Requirements

Technical Data and Analytics Product Manager II: a BA/BS in Business Administration or related field with 6+ years of product management experience in healthcare or an equivalent education/experience mix; experience in consumer-facing software or startup environments preferred; MBA preferred.
Technical Data and Analytics Product Manager III: a BA/BS in Business Administration or related field with 8+ years of product management experience in healthcare or an equivalent education/experience mix; experience in consumer-facing software or startup environments preferred; MBA preferred.
Senior Technical Data and Analytics Product Manager: a Bachelor’s degree in Business, Computer Science, Applied AI or related field; 10+ years in data engineering, data analytics, and/or business intelligence; 5+ years of product management experience or equivalent in a data-driven industry; healthcare, insurance, banking, or related industry experience preferred.

Technologies

Snowflake
dbt Semantic Layer
Snowflake Cortex
Sigma
dbt Labs

Benefits

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

What Sets This Role Apart

This position transcends a traditional analytics product role. The ideal candidate treats the semantic layer as foundational infrastructure, recognizing the difference between AI that hallucinates and AI that reasons correctly. They are equally comfortable contributing to business strategy discussions and reviewing dbt models, ensuring the platform reliably supports enterprise AI and analytics at scale.

View full job page →

2mo ago

Analytics Engineer II (Epic Cogito, Power BI)

Children's Health Dallas, TX 🇺🇸 Remote

Dallas, TX

2mo ago Closed

Full time Analyst Analytics Business Analytics

This position is no longer accepting applications (closed Jun 7, 2026).

Job Description

The Analytics Engineer II role centers on owning analytics artifacts across domains, building semantic layers and metric stores, and enabling federated domain adoption with governance and data quality in mind.

Responsibilities

Model analytically ready datasets and design or maintain semantic layers, metrics stores, or data marts; apply analytics engineering best practices (version control, CI/CD, and environment management); partner with BI analysts, data scientists, and domain stakeholders to operationalize analytics products; ensure alignment with governance and data quality requirements.

Requirements

Minimum 3 years in analytics or data roles with demonstrated delivery of analytics artifacts; hands-on experience with dbt or similar analytics engineering tools; practical usage of CI/CD and workflow orchestration.
3+ years of advanced SQL and experience with dbt or equivalent transformation frameworks; familiarity with metrics store concepts and basics of knowledge graphs or ontologies for semantic enrichment where applicable.
3+ years implementing CI/CD for analytics, automated testing, environment promotion, and metadata/catalog integration.
3+ years with at least one cloud data platform (Snowflake, Databricks, or MS Fabric) and BI tool optimization experience (Power BI or Tableau performance tuning).
1+ year exposure to machine learning, data science, or AI concepts (preferred).
1+ year experience in healthcare or another regulated industry (preferred).
Design and implement semantic layer components such as metrics store objects, analytical models, and data marts to support domain KPIs and BI consumption.
Implement automated testing and CI/CD pipelines, with deployment promotions for analytics products; own environment management for domain artifacts.
Lead data quality monitoring for analytics products; collaborate with data stewards to remediate issues; maintain metadata and lineage in the data catalog.
Optimize query and semantic performance for BI tools; apply best practices to reduce dashboard sprawl and metric inconsistencies.
Collaborate with clinical and operational stakeholders to translate workflows and EHR/ERP data into repeatable analytics products, such as procedure-level cost and outcomes dashboards and inventory visibility reports.
Engage across domain areas (clinical, financial, or supply chain); facilitate stakeholders and solve problems effectively.
Translate business KPIs into reproducible metrics-as-code and communicate technical concepts to a diverse range of stakeholders; mentor junior engineers.
Work with EHR/clinical data and supply chain/ERP data sources; follow interoperability expectations (FHIR/HL7 awareness) for clinical integrations; support clinical analytics and supply-chain analytics as relevant.
Maintain version control of analytics content, separate dev/test/prod environments, workflow orchestration, metadata/cataloging, and performance testing to improve uptime, adoption, code quality and defect resolution.
Adhere to organizational data governance, privacy and security requirements including HIPAA-relevant controls; collaborate with governance or ARB when analytics or AI artifacts are used in clinical or high-risk contexts.

Technologies

Epic Cogito
Power BI
dbt
Snowflake
Databricks
MS Fabric
Tableau

Benefits

Employee portion of medical plan premiums are covered after 3 years.
4% to 10% employee savings plan match based on tenure.
Paid Parental Leave (up to 12 weeks).
Caregiver Leave.
Adoption and surrogacy reimbursement.

A PLACE WHERE YOU BELONG

We put our people first. We welcome, value, and respect the beliefs, identities and experiences of our patients and colleagues. We are committed to delivering culturally effective care, creating meaningful partnerships in the communities we serve, and equipping and developing our team members to make Children’s Health a place where everyone can contribute.

View full job page →

Semantic Layer Data Jobs

Senior Analytics Engineer

Analytics Engineer, Data Platform

Technical Data and Analytics Product Manager II - Senior

Analytics Engineer II (Epic Cogito, Power BI)

Get Job Alerts