Analytics Engineer / Contract / Hybrid / Scottsdale, AZ

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

Our client,a clean energy developer and operator across the US,is actively hiring anAnalytics Engineerto join their team inScottsdale, AZ! This will be a hybrid role and will require 3 days a week onsite.

In this role, you will be responsible for building and owning the semantic layer and data mart strategy that connects the raw operational and financial data to the business teams who depend on it. A significant portion of your work will focus on modeling data replicated from SAP, our financial and other operational platforms into Snowflake building clean, tested, and well-documented dbt models that serve Hex dashboards and Snowflake semantic models queryable by LLMs.

Contract Duration: 12 Months

Required Skills & Experience

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

What You Will Be Doing

• Design and maintain the staging and intermediate dbt model layers for financial, operational, and asset-management data replicated from SAP (ERP) into Snowflake
• Build and maintain 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