Analytics Engineer - Semantic DBT & Snowflake (Hybrid)

Motion Recruitment Partners LLC; Scottsdale, Northern (AZ, KY); Hybrid; USD 110,000 - 140,000; Part time

Job summary

Motion Recruitment Partners LLC in Scottsdale, AZ is seeking an Analytics Engineer to own the semantic layer and data mart strategy. You will model data replicated from SAP into Snowflake using dbt, and build clean, tested models that serve Hex dashboards and BI tools.

The role requires 3+ years in Analytics/Data/BI Engineering, strong SQL and Python skills, and a hybrid work arrangement with 3 days onsite.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Mathematics, or related field.
• 3+ years in Analytics Engineering, Data Engineering, or BI Engineering.
• Working knowledge of Snowflake.
• SQL and Python proficiency.

Responsibilities

• Design and maintain the staging and intermediate dbt model layers for financial, operational, and asset-management data replicated from SAP (ERP) into Snowflake.
• Build Snowflake semantic models (definitions that allow LLMs and BI tools to query business metrics without ad-hoc SQL).
• Create documentation, data dictionaries, and training materials that enable analysts to use data marts and Hex workbooks independently.

Skills

SQL

Python

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, or related field

Tools

Snowflake

dbt

Hex

Job description

Motion Recruitment Partners LLC in Scottsdale, AZ is seeking an Analytics Engineer to own the semantic layer and data mart strategy. You will model data replicated from SAP into Snowflake using dbt, and build clean, tested models that serve Hex dashboards and BI tools.

The role requires 3+ years in Analytics/Data/BI Engineering, strong SQL and Python skills, and a hybrid work arrangement with 3 days onsite.