Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Scottsdale, AZ, United States
Posted
Yesterday
SQLSnowflakePythondbt
Job Description
Our client, a clean energy developer and operator across the US, is actively hiring an Analytics Engineer to join their team in Scottsdale, 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
What You Will Be Doing
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
Similar jobs
- IC
Data Mining & Analytics Engineer, Journeyman (Security Clearance Required)
ICF Consulting Group, Inc.
Arlington, VA🇺🇸$98.6k - $167.6k/yrRemote5 weeks agoSQLAWSDatabricks+3Technology - IC
Data Mining & Analytics Engineer, Senior (Security Clearance Required)
ICF Consulting Group, Inc.
Arlington, VA🇺🇸$119.3k - $202.8k/yrRemote5 weeks agoSQLAWSDatabricks+3Technology - OH
Workday Reporting & Analytics Lead, People Analytics
NewOscar Health
New York🇺🇸$101.8k - $133.7k/yr20 hours agoTableauAuditingCompliance+6Technology - PE
Data Analytics Engineer with Security Clearance
Peraton
Huntsville, AL🇺🇸$80k - $128k/yrOn-site2 weeks agoMATLABHTTPSPythonTechnology - PE
Network Analytics - ToR - Junior Level with Security Clearance
Peraton
Fort Huachuca, AZ🇺🇸$51k - $82k/yrHybrid3 weeks agoComplianceHTTPS - PR
Senior BI / Analytics Engineer
NewProsum
Culver City, CA🇺🇸HybridYesterdaySQLAPI GatewaySnowflake+6Technology