Why This Role Stands Out
This hybrid role offers a fantastic opportunity to shape the data strategy for a leading clean energy company, building impactful Snowflake semantic models and driving data accessibility. You'll thrive here if you're a skilled Analytics Engineer with a passion for transforming complex SAP data into actionable insights, leveraging your expertise in SQL, Python, and dbt. Don't miss out on this chance to grow your career in a dynamic and innovative environment!
Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Scottsdale, AZ, United States
Posted
4 weeks ago
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
- TB
Sr. Analytics Engineer
NewTrail Blazer Consulting LLC
United States🇺🇸$175k/yrHybridYesterdaySQLSnowflakeData Pipeline+4Technology - TE
Data Scientist / Analytics Engineer
NewTechDigital Corporation
Temple Terrace, FL🇺🇸HybridYesterdayDjangoDockerFastAPI+14Technology - VC
Industrial Engineering Analytics Engineer
NewVayu Consulting Group Inc.
Boston, MA🇺🇸HybridYesterdaySQLMicrosoft ExcelPower BITechnology - AS
Senior BI & Analytics Engineer (Tableau / Looker / Google Cloud Platform)
NewAgreeYa Solutions
Ashburn, VA🇺🇸On-siteYesterdaySQLETLLooker+8Technology - SA
Senior AI Data & Analytics Engineer II
NewAuto ApplySamsara
Remote - Chicago🇺🇸Remote14 hours agoSQLETLMachine Learning+14Technology - SA
Senior AI Data & Analytics Engineer II
NewAuto ApplySamsara
Remote - Austin🇺🇸Remote14 hours agoSQLETLMachine Learning+14Technology - AS
Senior Unconventional Analytics Engineer
NewApex Systems
Spring, TX🇺🇸On-siteYesterdaySQLSpringETL+3Technology - SP
Data Visualization Engineer
NewAuto ApplySpaceXSI
Palo Alto🇺🇸HybridYesterdaySQLLookerSAML+9Engineering - WM
Manager, Analytics
NewAuto ApplyWPP Media
New York🇺🇸$60k - $140k/yrHybrid13 hours agoGCPSalesforceSnowflake+3 - NB
Lead, Commerce & Growth Product Analytics
NewAuto ApplyNBCUniversal
Universal City, CA🇺🇸$125k - $165k/yrHybridYesterdayLookerTableauAirflow+2 - GI
Director, Analytics Engineering
NewAuto ApplyGitLab
Remote🇺🇸$139.2k - $285.6k/yrRemoteYesterdaySQLSnowflakeTableau+9Engineering - UL
BI Analytics Engineer
Uline
Pleasant Prairie, WI🇺🇸On-site3 days agoSQLPower BIPythonTechnology