Analytics Engineer, Semantic Layer

Clayco; St. Louis (MO); On-site; USD 90,000 - 150,000; Full time

Benefits offered by this job

Discretionary Bonus

Job summary

Clayco in St. Louis is seeking a data modeling specialist to build semantic models on Snowflake, ensuring accuracy and audit readiness.

You will translate finance and project-control logic into robust data models, with tests and documentation as part of every deliverable. You will migrate legacy reporting to governed models, keep them resilient as source systems evolve, and work with senior engineers to learn and refine dimensional modeling, dbt, and construction-domain knowledge.

Qualifications

• Strong SQL skills with window functions and complex joins.
• Ability to translate business logic into scalable models.
• Willingness to learn from senior engineers and collaborate across finance and operations.

Responsibilities

• Build semantic models on Snowflake with tests and documentation.
• Translate finance, operations, and project controls logic into models.
• Migrate legacy reporting to governed models.
• Maintain models as source systems evolve.
• Clarify definitional questions and document answers.

Skills

SQL proficiency

Data modeling

Analytical mindset

Cross-functional collaboration

Tools

Snowflake

dbt

Job description

About Us

Clayco is a full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $8.1 billion in revenue for 2025, Clayco specializes in the "art and science of building," providing fast track, efficient solutions for mission critical, industrial, life sciences, power & energy, aviation, commercial, institutional, residential and sports & entertainment related building projects.

The Role We Want You For

Ask three people at a construction company what a job costs to complete and you will get three answers. All of them are defensible. They come from different systems, different assumptions about what is committed versus spent, and different ideas about how far along the work really is.

The semantic layer is where that gets settled. It is the set of governed definitions that say what a Clayco number means; built once, tested, documented, and used by every report, dashboard, and AI agent downstream. A metric here is not a query someone wrote. It is a decision about meaning that somebody owns.

You will build that layer. The work is SQL and modeling discipline, done carefully, on data that matters to people who will notice if you get it wrong.

The Specifics of the Role

• 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

Requirements

• Real SQL. 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.
• You ask until you understand. The willingness to tell a finance director you do not follow the calculation yet, and keep asking until you do.
• You can be the person in the middle. Telling two groups their reports disagree, explaining why, and helping them land on one answer.
• We will hire someone early in their career for this if the fundamentals and the curiosity are there — you would have senior engineers around you to learn from. Dimensional modeling experience, dbt, or construction background are all welcome, none are required.

Some Things You Should Know

• Our clients and projects are nationwide – Travel will be required.
• No other builder can offer the collaborative design-build approach that Clayco does.
• We work on creative, complex, award-winning, high-profile jobs.
• The pace is fast!
• This position is classified as a safety-sensitive role in accordance with applicable state and federal laws. Candidates selected for this position will be subject to a comprehensive background check, which includes mandatory drug testing.

Why Clayco?

• 2025 Best Places to Work – St. Louis Business Journal, Los Angeles Business Journal, and Phoenix Business Journal.
• 2025 ENR Top 400 – Top Data Center Contractor (Top 3).
• 2025 ENR Top 100 Design-Build Firms – Design-Build Contractor (Top 5).
• 2025 ENR Top 100 Green Contractors – Green Contractor (Top 3).

Benefits

• Discretionary Annual Bonus: Subject to company and individual performance.
• Comprehensive Benefits Package Including: Medical, dental and vision plans, 401k, generous PTO and paid company holidays, employee assistance program, flexible spending accounts, life insurance, disability coverage, learning & development programs and more!

Compensation

• The salary range for this position considers a wide range of factors in making compensation decisions including but not limited to: Education, qualifications, skills, training, experience, certifications, internal equity, and location. Compensation decisions are dependent on the facts and circumstances of each case.