← Back to jobsJob ID col-cmvgyj8ql00dcs3ctzsd3a1vb

OptomiPosted 30+ days ago

Data Engineer

Full-time
On-site
3+ years
Competitive
Posted 30+ days ago

Optomi is recruiting for a leading clean energy company. The Analytics Engineer will own the semantic layer and data mart strategy, modeling operational and financial data in Snowflake and building tested, documented dbt models to support dashboards and business teams.

Posted
30+ Days Ago
Source
linkedin.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • A significant portion of this role will focus on modeling data replicated from SAP and other financial and operational platforms into Snowflake, building clean, tested, and well-documented dbt models that serve Hex dashboards and Snowflake semantic models queryable by LLMs
  • Owning the analytics engineering, semantic layer, and data mart strategy
  • Working with modern data technologies including Snowflake, dbt, Hex, and AI/LLM tooling
  • Building data products that directly support Finance, Accounting, Asset Management, Operations, Trading, and executive teams
  • Using AI-assisted development tools to improve productivity while maintaining strong engineering and data quality standards

Qualifications

  • 3+ years of experience in Analytics Engineering, Data Engineering, or BI Engineering roles delivering production dbt models at scale
  • Strong hands-on experience with dbt Core/Cloud, including staging, intermediate, and mart-layer modeling, incremental models, macros, testing, and documentation
  • Working knowledge of Snowflake, including query optimization, clustering, result caching, Time Travel, and cost-aware data model design
  • Advanced SQL skills, including CTEs, window functions, recursive queries, and query performance tuning
  • Experience with Python for scripting, automation, and custom testing
  • Experience developing analytical datasets that support BI and dashboarding platforms
  • Experience with Git, code review, and CI/CD for dbt projects
  • Practical experience using AI coding assistants with an understanding of data privacy, security, and responsible AI practices

Preferred

  • Hex experience strongly preferred
  • dbt Analytics Engineer certification
  • Experience with Snowflake semantic models, Cortex Analyst, dbt Semantic Layer, or MetricFlow
  • Experience with Dagster or other modern data orchestration platforms
  • Energy, utilities, or financial services industry experience
  • Knowledge of energy gross margin, power generation metrics, or energy trading/market data
  • Experience with Snowflake Cortex, including LLM functions or Cortex Analyst
  • Familiarity with SOX, GDPR, CCPA, or other data governance and regulatory compliance frameworks
  • Experience managing dbt Cloud jobs, environments, and orchestration
  • Experience with GitLab CI or Azure DevOps for analytics engineering workflows
  • Energy Industry Experience
  • Utilities Industry Experience
  • Financial Services Experience

Required skills

CI/CDCortex AnalystDagsterGitHexPythonSQLSnowflakeSnowflake Semantic Modelsdbt

Nice to have

dbt Analytics Engineer certification

Full job description

Optomi is recruiting for a leading clean energy company. The Analytics Engineer will own the semantic layer and data mart strategy, modeling operational and financial data in Snowflake and building tested, documented dbt models to support dashboards and business teams.

Responsibilities

  • A significant portion of this role will focus on modeling data replicated from SAP and other financial and operational platforms into Snowflake, building clean, tested, and well-documented dbt models that serve Hex dashboards and Snowflake semantic models queryable by LLMs
  • Owning the analytics engineering, semantic layer, and data mart strategy
  • Working with modern data technologies including Snowflake, dbt, Hex, and AI/LLM tooling
  • Building data products that directly support Finance, Accounting, Asset Management, Operations, Trading, and executive teams
  • Using AI-assisted development tools to improve productivity while maintaining strong engineering and data quality standards

Preferred

  • Hex experience strongly preferred
  • dbt Analytics Engineer certification
  • Experience with Snowflake semantic models, Cortex Analyst, dbt Semantic Layer, or MetricFlow
  • Experience with Dagster or other modern data orchestration platforms
  • Energy, utilities, or financial services industry experience
  • Knowledge of energy gross margin, power generation metrics, or energy trading/market data
  • Experience with Snowflake Cortex, including LLM functions or Cortex Analyst
  • Familiarity with SOX, GDPR, CCPA, or other data governance and regulatory compliance frameworks
  • Experience managing dbt Cloud jobs, environments, and orchestration
  • Experience with GitLab CI or Azure DevOps for analytics engineering workflows
  • Hex
  • dbt Analytics Engineer Certification
  • Snowflake Semantic Models
  • Cortex Analyst
  • dbt Semantic Layer
  • MetricFlow
  • Dagster
  • Data Orchestration Platforms
  • Energy Industry Experience
  • Utilities Industry Experience
  • Financial Services Experience
  • Energy Gross Margin
  • Power Generation Metrics
  • Energy Trading Data
  • Energy Market Data
  • Snowflake Cortex
  • LLM Functions
  • SOX Compliance
  • GDPR Compliance
  • CCPA Compliance
  • Data Governance
  • Regulatory Compliance Frameworks
  • dbt Cloud Jobs
  • dbt Cloud Environments
  • dbt Cloud Orchestration
  • GitLab CI
  • Azure DevOps
  • Analytics Engineering Workflows

Benefits

  • Working with modern data technologies including Snowflake, dbt, Hex, and AI/LLM tooling
  • A collaborative, cross-functional environment with significant ownership and autonomy

Company

  • IT talent services and staffing for technology companies
  • Atlanta, Georgia, USA
  • http://www.optomi.com/
  • Founded in 2012
  • 501-1000 employees

Qualifications

  • 3+ years of experience in Analytics Engineering, Data Engineering, or BI Engineering roles delivering production dbt models at scale
  • Strong hands-on experience with dbt Core/Cloud, including staging, intermediate, and mart-layer modeling, incremental models, macros, testing, and documentation
  • Working knowledge of Snowflake, including query optimization, clustering, result caching, Time Travel, and cost-aware data model design
  • Advanced SQL skills, including CTEs, window functions, recursive queries, and query performance tuning
  • Experience with Python for scripting, automation, and custom testing
  • Experience developing analytical datasets that support BI and dashboarding platforms
  • Experience with Git, code review, and CI/CD for dbt projects
  • Practical experience using AI coding assistants with an understanding of data privacy, security, and responsible AI practices
  • Hex experience strongly preferred
  • Dbt Analytics Engineer certification
  • Experience with Snowflake semantic models, Cortex Analyst, dbt Semantic Layer, or MetricFlow
  • Experience with Dagster or other modern data orchestration platforms
  • Energy, utilities, or financial services industry experience
  • Knowledge of energy gross margin, power generation metrics, or energy trading/market data
  • Experience with Snowflake Cortex, including LLM functions or Cortex Analyst
  • Familiarity with SOX, GDPR, CCPA, or other data governance and regulatory compliance frameworks
  • Experience managing dbt Cloud jobs, environments, and orchestration
  • Experience with GitLab CI or Azure DevOps for analytics engineering workflows

Required skills

  • CI/CD, Cortex Analyst, Dagster, Energy Trading and Market Data, Git, Hex, Python, SQL, Snowflake, Snowflake Semantic Models, dbt, dbt Analytics Engineer Certification

Preferred skills

  • Energy, utilities, or financial services industry experience, Hex experience strongly preferred, dbt Analytics Engineer certification

Experience

  • 3+ years

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Oct 20, 2026

Work mode

On-site

Job source

linkedin.com

Company

Optomi

Information Technology & AI

IT talent services and staffing for technology companies

See all 6 jobs from Optomi →
  • Atlanta, Georgia, USA
  • Information Technology & AI
  • 501-1000 employees
  • Founded 2012
  • optomi.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Phoenix

MaxIT Consulting - Max Corporate Group

6d ago

Data Engineer - ClickHouse, SQLMesh & TypeScript (Fintech)

Full-timeOn-siteNew York, NYCompetitive

MaxIT Consulting is recruiting a Software Engineer, Data Platform for an unnamed financial data and accounting automation platform.

Why similarSame roleDagsterDbt

Flow Traders

Today

New

Core Data Engineer

Full-timeOn-siteNew York, NY$165K – $210K/yr

Flow Traders is hiring a Core Data Engineer to own the lifecycle and quality of foundational data products, including market, trading, and reference data.

Why similarSame rolePythonSQL

KPG99 INC

1w ago

GCP Data Engineer - W2 Only

TemporaryRemoteUnited StatesCompetitive

KPG99 INC is seeking a GCP Data Engineer for a six-month contract-to-hire role. The role focuses on hands-on data engineering, including BigQuery and data pipeline development, in a fast-moving environment.

Why similarSame rolePythonRemote

Get new Data Engineer jobs in Phoenix by email

Create job alert

Data Engineer

Optomi · Competitive

Apply on company site