Analytics Engineer, Semantic Layer

Clayco is hiring an Analytics Engineer to build a governed semantic layer on its Snowflake platform. The role translates business logic from finance, operations, and project controls into tested, documented models, migrates legacy reporting, maintains models as source systems change, and resolves business questions about metric definitions.

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 are all welcome, none are required

Dimensional Modeling

dbt

Construction Background

Benefits

Discretionary annual bonus, subject to company and individual performance

Medical, dental and vision plans

401(k)

Generous PTO

Paid company holidays

Employee assistance program

Flexible spending accounts

Life insurance

Disability coverage

Learning & development programs

Company

Turnkey real estate development, architecture, engineering, and construction firm.

Chicago, Illinois, USA

http://www.claycorp.com/

Founded in 1984

1001-5000 employees

Qualifications

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

Dimensional modeling experience, dbt, or construction background are all welcome, none are required

Required skills

SQL, Dimensional Modeling, dbt, Construction