Analytics Engineer - Semantic Layer & AI-Driven Analytics

Cloaked; New York (NY); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Competitive PTO

Parental Leave

Wellness stipend

Professional growth

Job summary

Cloaked is building a cyber expert at your side, with a focus on a governed semantic layer powering dashboards, analysis, and AI-driven answers. You will own definitions and relationships across product, subscription, and lifecycle data, ensuring consistent metrics across tools and teams.

You will design and build the semantic layer, create BI artifacts, and collaborate with Data, Product, Growth, Finance, and CX to deliver reliable insights and AI-ready data assets.

Qualifications

• 3–5 years in analytics engineering, BI engineering, or a closely related role.
• Strong SQL and dimensional data modeling skills.
• Hands-on experience building semantic models in a tool like Looker (LookML), Omni, dbt Semantic Layer, or Cube.
• Experience with dbt or a similar transformation framework, Git-based workflows, and code review.
• Familiarity with cloud data platforms (AWS/Athena, Snowflake, BigQuery, or similar).
• AI-forward: you use AI tooling to ship faster and structure data that AI agents query directly.

Responsibilities

• Design, build, and maintain the semantic layer, including metric definitions, dimensions, joins, and entity relationships across product, subscription, and lifecycle data.
• Build and maintain BI artifacts - models, explores, and dashboards - on top of the semantic layer for teams across the company.
• Build and curate certified metrics and queries that power AI-assisted, natural-language data querying, and improve answer accuracy over time.
• Partner with stakeholders to resolve conflicting metric definitions and document the agreed source of truth.
• Write clean, tested, version-controlled SQL and transformation code with data quality checks and clear documentation.
• Work closely with data engineering on upstream models, and with analysts on how the layer gets used.

Skills

Strong SQL

Dimensional data modeling

Communication

AI tooling

Tools

Looker (LookML)

dbt Semantic Layer

Cube

Omni

Git workflows

Job description

Cloaked is building a cyber expert at your side, with a focus on a governed semantic layer powering dashboards, analysis, and AI-driven answers. You will own definitions and relationships across product, subscription, and lifecycle data, ensuring consistent metrics across tools and teams.

You will design and build the semantic layer, create BI artifacts, and collaborate with Data, Product, Growth, Finance, and CX to deliver reliable insights and AI-ready data assets.