Data Engineer

Optomi, in partnership with a leading clean energy company, are seeking an Analytics Engineer to own the semantic layer and data mart strategy that connects raw operational and financial data to the business teams who depend on it. 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.What the right candidate will enjoy:Owning the analytics engineering, semantic layer, and data mart strategyWorking with modern data technologies including Snowflake, dbt, Hex, and AI/LLM toolingBuilding data products that directly support Finance, Accounting, Asset Management, Operations, Trading, and executive teamsWorking in a collaborative, cross-functional environment with significant ownership and autonomyUsing AI-assisted development tools to improve productivity while maintaining strong engineering and data quality standardsWhat type of experience does the right candidate have:3+ years of experience in Analytics Engineering, Data Engineering, or BI Engineering roles delivering production dbt models at scaleStrong hands-on experience with dbt Core/Cloud, including staging, intermediate, and mart-layer modeling, incremental models, macros, testing, and documentationWorking knowledge of Snowflake, including query optimization, clustering, result caching, Time Travel, and cost-aware data model designAdvanced SQL skills, including CTEs, window functions, recursive queries, and query performance tuningExperience with Python for scripting, automation, and custom testingExperience developing analytical datasets that support BI and dashboarding platforms; Hex experience strongly preferredExperience with Git, code review, and CI/CD for dbt projectsPractical experience using AI coding assistants with an understanding of data privacy, security, and responsible AI practicesNice-to-Have Experience:dbt Analytics Engineer certificationExperience with Snowflake semantic models, Cortex Analyst, dbt Semantic Layer, or MetricFlowExperience with Dagster or other modern data orchestration platformsEnergy, utilities, or financial services industry experienceKnowledge of energy gross margin, power generation metrics, or energy trading/market dataExperience with Snowflake Cortex, including LLM functions or Cortex AnalystFamiliarity with SOX, GDPR, CCPA, or other data governance and regulatory compliance frameworksExperience managing dbt Cloud jobs, environments, and orchestrationExperience with GitLab CI or Azure DevOps for analytics engineering workflows