Analytics Engineer, Semantic Layer

Clayco is hiring an Analytics Engineer to build and maintain a governed semantic layer on its Snowflake platform. The role translates business logic into tested, documented models, migrates legacy reporting logic, and ensures trusted metrics remain accurate as source systems change.

Tags

Architecture & Design

Architecture

Interior Design

Insider Connection @LJC

2 email credits available today

Beyond your network

Find More Connections

From your previous company

from your School

Find Any Email

Responsibilities

Build semantic models on our Snowflake platform, with tests and documentation as part of finished work rather than cleanup afterward

Translate business logic from finance, operations, and project controls into models that hold up when someone audits them

Move legacy reporting logic onto governed models and help retire what it replaces

Keep models working as source systems change, so a field change upstream does not quietly break a number people trust

Answer the definitional questions that come back from the business, and write down the answers

Preferred

Dimensional modeling experience, dbt, or construction background

Benefits

Discretionary annual bonus, subject to company and individual performance.

Medical plans

Dental plans

Vision plans

401k

Generous PTO

Paid company holidays

Employee assistance program

Flexible spending accounts

Life insurance

Disability coverage

Learning & development programs

LJC Design & Engineering is a full-service architecture, engineering, and design firm committed to enhancing the quality of the human experience through integrated design.

Chicago, Illinois, USA

https://www.theljc.com

Distribution of Different Job Fields Receiving Sponsorship

16

Represents job field similar to this job

Engineering and Development

Creatives and Design

Management and Executive

Trends of Total Sponsorships

*2026

(15)

2025

(7)

2024

(11)

2023

(9)

Qualifications

Window functions, complex joins, and the judgment to know when a query is correct rather than merely returning rows

You care whether a number is right. Enough to chase down a variance of a few hundred dollars because it means something is wrong with the logic, not because anyone asked you to

The willingness to tell a finance director you do not follow the calculation yet, and keep asking until you do

Telling two groups their reports disagree, explaining why, and helping them land on one answer

Dimensional modeling experience, dbt, or construction background

Required skills

SQL, Dimensional Modeling, dbt, Construction Industry Knowledge