Bachelor's degree in computer science, Engineering, Mathematics, or a related quantitative discipline.
3+ years of experience in Analytics Engineering, Data Engineering, or BI Engineering delivering production-grade data models.
Strong experience with dbt Core and/or dbt Cloud.
Expertise in incremental models, macros, testing frameworks, documentation, and dbt packages.
Working knowledge of Snowflake including query optimization and cost optimization.
Advanced SQL skills including window functions and performance tuning.
Strong Python programming skills for automation and data testing.
Responsibilities
Design, develop, and maintain dbt models for financial and operational data in Snowflake.
Collaborate with SAP and integration teams to understand data structures and relationships.
Implement data quality controls and validation strategies.
Own and maintain dbt models for revenue calculations and operational analytics.
Build and enhance data marts integrating various datasets.
Partner with stakeholders to ensure models reflect business metrics accurately.
Utilize AI coding assistants to accelerate SQL development and validation.
Benefits
Flexible work arrangements to promote work-life balance.
Opportunities for professional development and training.
Access to cutting-edge tools and technologies.
Collaborative and inclusive work environment.
Health and wellness programs to support employee well-being.
Full Job Description
Job Summary
We are seeking an Analytics Engineer to own the semantic layer and data mart strategy that connects operational and financial data to business stakeholders. This role will focus heavily on modeling SAP-sourced data within Snowflake, building scalable dbt models, enabling self-service analytics, and developing semantic data models that support BI reporting and AI/LLM-driven data consumption. The ideal candidate will have strong expertise in dbt, Snowflake, SQL, data modeling, analytics engineering, and modern AI-assisted development practices.
Key Responsibilities
Design, develop, and maintain staging, intermediate, and mart-layer dbt models for financial, operational, and asset management data replicated from SAP into Snowflake.
Collaborate with SAP and integration teams to understand source-system structures, business rules, and data relationships.
Implement data quality controls including incremental load strategies, referential integrity checks, null validation, and accepted-value testing.
Own and maintain dbt models supporting revenue calculations, budget variance reporting, and operational analytics.
Build and enhance data marts integrating operational, financial, and asset performance datasets.
Partner with business stakeholders to ensure analytical models accurately reflect business metrics and reporting requirements.
Develop and maintain Snowflake semantic models that support BI platforms and AI/LLM-driven data consumption.
Design machine-readable analytical data models with standardized naming conventions, metadata, and documentation.
Define, document, and govern business metrics, dimensions, hierarchies, and semantic definitions.
Build and maintain analytical datasets and data marts supporting dashboarding and reporting solutions.
Optimize data models and datasets for reporting performance and analytics workloads.
Support self-service analytics initiatives by providing well-documented and trusted datasets.
Implement comprehensive testing frameworks using dbt testing methodologies and related packages.
Establish and maintain data lineage, metadata standards, naming conventions, and governance processes.
Create and maintain technical documentation, data dictionaries, and business-facing model documentation.
Utilize AI coding assistants to accelerate SQL development, testing, documentation, and model generation while performing rigorous validation of generated outputs.
Participate in defining secure and responsible AI development practices, including privacy and security considerations.
Conduct stakeholder workshops, data model reviews, and business requirement sessions.
Collaborate with Data Engineers, Analysts, and Data Scientists to support analytical and operational use cases.
Develop training materials and onboarding documentation to enable analyst self-service adoption.
Required Qualifications
Bachelor's degree in computer science, Engineering, Mathematics, or a related quantitative discipline.
3+ years of experience in Analytics Engineering, Data Engineering, or BI Engineering delivering production-grade data models.
Strong experience with dbt Core and/or dbt Cloud.
Experience designing and maintaining staging, intermediate, and mart-layer data models.
Expertise in incremental models, macros, testing frameworks, documentation, and dbt packages.
Working knowledge of Snowflake including query optimization, clustering, result caching, time travel, and cost optimization.
Advanced SQL skills including window functions, CTEs, recursive queries, and performance tuning.
Strong Python programming skills for automation, scripting, and data testing.
Experience building analytical datasets for business intelligence and reporting platforms.
Experience with Git-based version control, code reviews, and CI/CD workflows.
Practical experience using AI-assisted coding tools while maintaining code quality and governance controls.
Strong analytical, communication, and stakeholder management skills.
Preferred Qualifications
Experience with Hex analytics platform and dashboard development.
dbt Analytics Engineer Certification.
Experience building Snowflake semantic models, Cortex Analyst models, dbt Semantic Layer, or MetricFlow implementations.
Experience with Dagster orchestration platforms.
Experience within Energy, Utilities, Financial Services, or related industries.
Knowledge of energy gross margin calculations, power generation metrics, and energy trading datasets.
Experience with Snowflake Cortex capabilities including LLM functions and AI-powered features.
Familiarity with regulatory and governance frameworks including SOX, GDPR, and CCPA.
Experience with dbt Cloud jobs, environments, scheduling, and orchestration.
Experience with Azure DevOps or GitLab CI/CD pipelines.