Analytics Engineer, Semantic Layer

Job overview

The Analytics Engineer, Semantic Layer role is onsite in Saint Louis, MO; compensation is not specified. Clayco is a real estate development, architecture, engineering, and construction firm serving projects across multiple sectors. The engineer builds governed, tested, and documented semantic models that establish consistent business definitions for reporting and downstream tools. By translating finance, operations, and project-controls logic into reliable models, the role helps teams use trusted data for decisions and analysis.

What you'll do

• Build semantic models on Snowflake with tests and documentation
• translate finance, operations, and project-controls logic into auditable models
• migrate legacy reporting logic to governed models and help retire replaced logic
• maintain models as source systems change
• answer and document business questions about metric definitions.

What we're looking for

Skills & competencies

saint louis mo

clayco

analytics engineer

semantic layer

snowflake

sql

data modeling

business metrics

finance data

operations data

project controls

travel required

early-career considered

401(k)

Work arrangement

• Weekend coverage required

Benefits & perks

• Discretionary annual bonus
• medical, dental, and vision plans
• 401(k)
• paid time off and company holidays
• employee assistance program
• flexible spending accounts
• life insurance
• disability coverage
• learning and development programs.

Why this role

Travel is required because clients and projects are nationwide. The posting welcomes early-career candidates with strong fundamentals and curiosity; dimensional modeling, dbt, and construction experience are welcome but not required.

About the employer

Clayco is hiring for this role. Industry: Commercial and Institutional Building Construction. Sector: 23.