Analytics Engineer, Semantic Layer

Cloaked

. Own, design, build, and maintain Cloaked’s semantic layer .

Posted 10/16/2026full-timeNew York City • New York • United StatesMid-LevelSenior💰 $160,000 - $180,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in analytics engineering and business intelligence, with a strong focus on SQL, dimensional data modeling, and semantic layer development using tools like Looker and dbt. Proven ability to collaborate with stakeholders to define metrics and deliver actionable insights across various business functions.

Highest-signal resume keywords

Strong SQL SkillsDimensional Data ModelingLooker (LookML) Semantic ModelsExperience with dbt or Similar FrameworkCloud Data Platforms (AWS/Athena, Snowflake, BigQuery)

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

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

Hard Skills

SQLDimensional Data ModelingSemantic Layer DevelopmentData Quality ChecksVersion-Controlled CodeData TransformationBI Artifacts CreationMetrics DefinitionData QueryingDocumentation

Soft Skills

Clear CommunicationProblem-SolvingCollaboration

Tools & Technologies

LookerDbtOmniCubeGitAWS/AthenaSnowflakeBigQueryClaudeChatGPT

Industry Keywords

Analytics EngineeringBusiness IntelligenceStartup ExperienceCustomer PrivacyMetric Governance

Tech Stack

Tools & technologies

AWSBigQueryCloudSQL

About the role

Key responsibilities & impact

Own, design, build, and maintain Cloaked’s semantic layer
Define and govern metrics, dimensions, joins, and entity relationships across product, subscription, and lifecycle data
Build and maintain BI artifacts including models, explores, and dashboards
Build and curate certified metrics and queries for AI-assisted natural-language data querying
Improve answer accuracy over time
Partner with stakeholders to resolve conflicting metric definitions and document the source of truth
Write clean, tested, version-controlled SQL and transformation code
Implement data quality checks and clear documentation
Collaborate with data engineering on upstream models
Work with analysts on semantic-layer usage
Deliver insights and data value to stakeholders across Product, Growth, Finance, and CX

Requirements

What you’ll need

3–5 years of experience in analytics engineering, BI engineering, or a closely related role
Strong SQL skills
Solid dimensional data modeling skills
Hands-on experience building semantic models in Looker (LookML), Omni, dbt Semantic Layer, Cube, or similar tools
Experience with dbt or a similar transformation framework
Experience with Git-based workflows and code review
Familiarity with cloud data platforms such as AWS/Athena, Snowflake, BigQuery, or similar
Fluency with AI tooling such as Claude and ChatGPT
Clear communication and comfort defining ambiguous metrics
Startup or growth-stage company experience
Commitment to customer privacy
Must be local to NYC or open to relocating to NYC / working onsite in NYC
Must address U.S. employment authorization or sponsorship requirements

Benefits

Comp & perks

Equity
Bonus
Medical, dental and vision insurance, with Cloaked covering the majority of employee premiums
Company-paid basic life insurance
401(k) with company match
Flexible work arrangements and ability to work remotely as needed
Home office stipend
New company laptop and other role-dependent technology
Competitive PTO, floating holidays and sick days
Paid parental leave for birth, adoption, or foster placement
Monthly wellness and meals stipend
Lunch and coffee during the workday
Unlimited professional development fund
Conference and industry event attendance
Team outings and social events
Two kitchens with drinks and snacks