Analytics Engineer II

The Analytics Engineer II designs, builds, and maintains the Foundation’s analytics infrastructure and applications, ensuring a reliable, scalable analytics environment that delivers meaningful value to end users.

Requirements

• Design, build, and maintain SQL/dbt data models and semantic layers optimized for analytical query patterns and AI agent access.
• Define and maintain semantic layer encoding business logic, KPIs, and metric definitions in a single authoritative location.
• Apply dimensional modeling techniques to accurately represent business processes and metrics in our data warehouse.
• Prepare and curate data assets optimized for machine learning, LLM, and AI-agent workflows.
• Partner with analysts, data scientists, and stakeholders to translate business requirements into trusted data/analytical products.
• Develop and optimize ELT/ETL pipelines in a cloud data warehouse (e.g., Snowflake) for reliable, scalable data delivery.
• Implement data quality testing (schema, freshness, business rules) and remediate recurring data issues.
• Establish and sustain data lineage standards across analytical models, enabling stakeholders to trace data provenance from source to consumption in support of data governance, auditability, and operational reliability.
• Contribute to shared analytics codebases via Git/GitHub, including code reviews and established development workflows.
• Support Python-based automation, lightweight analytics services, and troubleshooting of cloud or containerized components as needed.

Benefits

• Comprehensive Benefits
• Professional Growth
• Innovative Work Environment