Submit Resume

Analytics Engineer

  • Arizona, Scottsdale

  • 11/19/2026

  • Contract

  • Active

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.

.

.

.