Analytics Engineer

Motion Recruitment; Scottsdale (AZ); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical Insurance

Health Savings Account

Dental Benefits

FSA / Dependent Care

Job summary

Motion Recruitment invites an Analytics Engineer to join a leading energy enterprise in a hybrid Scottsdale setting. You will design modern data architecture, shape the enterprise semantic layer, and build scalable data marts to power BI and AI-driven querying tools.

The role emphasizes dbt workflows, Snowflake optimization, and Python-based automation, with collaboration across data engineers, analysts, and trading teams.

Qualifications

• Bachelor's degree or higher in a quantitative field.
• 5+ years in Analytics/BI/Data Engineering with production dbt workflows.
• Strong SQL skills including window functions and optimization.
• Deep Snowflake architecture knowledge including performance tuning.

Responsibilities

• Design, deploy, and maintain modular dbt models transforming ERP data to clean schemas in Snowflake.
• Develop semantic models for self-serve BI and natural-language querying via LLMs.
• Build scalable data marts for finance, power generation performance, and revenue variance analysis.
• Deliver data foundation and optimized queries for interactive Hex dashboards and executive reports.
• Implement dbt testing, schema validations and data quality frameworks.
• Leverage LLM tools to accelerate code scaffolding, SQL tuning, and documentation with strict reviews.

Skills

Analytical thinking

Problem solving

SQL proficiency

Education

Bachelor's degree in CS/Math/Engineering

Tools

dbt Core/Cloud

Snowflake

Python

GitLab CI / Azure DevOps

Hex

Job description

Scottsdale, AZ (hybrid role and will require 3 days a week onsite)

Our client is one of the country's largest energy enterprises is searching for an Analytics Engineer to join their innovative data team. In this role, you will design and implement modern data architecture within an advanced, AI-driven environment. You will play a foundational part in shaping the enterprise semantic layer, architecting scalable data marts, and bridging the gap between raw operational data and machine-readable models that power both business intelligence and cutting‑edge generative AI querying tools.

Responsibilities

• Design, deploy, and maintain modular dbt models that transform replicated ERP data into clean, well‑governed schemas within Snowflake.
• Architect resilient semantic models that streamline self‑service business intelligence while enabling natural‑language querying via large language models.
• Build and scale dimensional data marts focused on financial tracking, power generation performance, and revenue variance analysis.
• Deliver the data foundation and optimized queries required for interactive Hex dashboards and executive reporting assets.
• Implement rigorous dbt testing, schema validations, and data quality frameworks to safeguard pipeline reliability and regulatory compliance.
• Utilize AI coding assistants such as Claude Code, ChatGPT, and GitHub Copilot to accelerate code scaffolding, SQL tuning, and documentation while maintaining strict code review standards.
• Partner cross‑functionally with data engineers, financial analysts, and trading teams to translate business metrics into production‑ready analytical products.

Skills & Experience

• Bachelor's degree in Computer Science, Mathematics, Information Systems, Engineering, or a related quantitative field.
• 5+ years of professional experience in an Analytics Engineering, Data Engineering, or BI Engineering role managing production dbt workflows.
• Advanced proficiency in SQL, including deep experience with window functions, CTEs, and query optimization techniques.
• In‑depth practical knowledge of Snowflake architecture, covering performance tuning, clustering, and cost‑conscious model design.
• Strong expertise building modular data layers, macros, and automated testing frameworks in dbt Core or dbt Cloud.
• Proficiency in Python for workflow automation, data pipeline scripting, and custom testing logic.
• Demonstrated track record modeling datasets specifically for modern BI platforms or collaborative notebook tools such as Hex.
• Hands‑on experience with Git‑based version control and CI/CD pipelines (such as GitLab CI or Azure DevOps).
• Working experience integrating LLM coding assistants into development cycles with a strong focus on data privacy and code reliability.

Preferred Qualifications

• Official dbt Developer or Analytics Engineer Certification.
• Hands‑on experience developing Snowflake semantic models (Cortex Analyst) or MetricFlow / dbt Semantic Layer definitions.
• Practical exposure to modern data orchestration platforms like Dagster.
• Domain knowledge in energy, power generation, commodities, or financial services.
• Familiarity with enterprise governance standards and compliance frameworks such as SOX, GDPR, or CCPA.

We offer:

• Medical Insurance: Four medical plans to choose from for you and your family
• Dental & Orthodontic Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts
• Voluntary Life Insurance
• Long‑Term & Short‑Term Disability Insurance
• Hospital Indemnity Insurance