← Back to jobsJob ID col-cmvgy4xxc003ps3ctkybn3xsa

OptomiPosted 30+ days ago

Data Engineer

Full-time
Hybrid
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 for business teams, dashboards, and LLM-queryable semantic models.

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

Opens the employer's application page in a new tab

Responsibilities

  • Own the semantic layer and data mart strategy that connects raw operational and financial data to the business teams who depend on it
  • 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
  • Working in a collaborative, cross-functional environment with significant ownership and autonomy
  • 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/CDDagsterGitHexPythonSOX, GDPR, and CCPASQLSnowflakeSnowflake 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 for business teams, dashboards, and LLM-queryable semantic models.

Responsibilities

  • Own the semantic layer and data mart strategy that connects raw operational and financial data to the business teams who depend on it
  • 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
  • Working in a collaborative, cross-functional environment with significant ownership and autonomy
  • 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

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, Dagster, Energy Trading and Market Data, Energy and Financial Services Data, Git, Hex, Python, SOX, GDPR, and CCPA, SQL, Snowflake, Snowflake Semantic Models, dbt

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

Hybrid

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 United States

Woven by Toyota

Today

New

Software Engineer II, Data Labeling

Full-timeHybridAnn Arbor, MICompetitive

Woven by Toyota is enabling Toyota’s transformation into a mobility company through autonomous driving, software-defined vehicles, mobility infrastructure, and cloud and AI technologies.

Why similarSame roleGitPython

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

The Voleon Group

Today

New

Software Engineer, Data Infrastructure

Full-timeRemoteUnited States$235K – $300K/yr

The Voleon Group is a technology company applying AI and machine learning to finance. The Software Engineer on its Data Infrastructure team builds and scales data infrastructure and tooling, collaborates with teams to improve their use of data, and helps…

Why similarSame rolePython

Get new Data Engineer jobs in United States by email

Create job alert

Data Engineer

Optomi · Competitive

Apply on company site