Analytics Engineer: Semantic Data Modeling on Snowflake

Clayco; St. Louis (MO); Presencial; USD 90 000 - 150 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Discretionary Bonus

Resumo da oferta

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.

Qualificações

• 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.

Responsabilidades

• 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.

Conhecimentos

SQL proficiency

Data modeling

Analytical mindset

Cross-functional collaboration

Ferramentas

Snowflake

dbt

Descrição da oferta de emprego

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.