Analytics Engineer: Gold Data Layer Architect

Celigo, Inc.; Redwood City, Northern (CA, KY); Hybrid; USD 120,000 - 140,000; Full time

Benefits offered by this job

Three weeks vacation

Wellness days and holidays

Parental leave

Monthly tech stipend

Job summary

Celigo, Inc. is seeking an Analytics Engineer to own our Gold data layer and be the primary architect of scalable data models.

You will transform complex datasets into clean, validated tables and apply software engineering rigors (version control, automated testing, CI/CD) to ensure a trusted data warehouse. You will collaborate with Data Engineering and Analytics to support reporting, optimize queries, and maintain documentation for a self-service BI ecosystem across Product, Finance, and GTM

Qualifications

• 3+ years of Analytics Engineering / Data Engineering experience.
• Expert-level proficiency in SQL.
• Hands-on experience with dbt / Coalesce and modern cloud data warehouses (Snowflake or BigQuery).
• Familiarity with Git, pull request workflows, and command-line interfaces.

Responsibilities

• Develop and maintain scalable data models using dbt/Coalesce to transform raw data into clean, production-ready schemas.
• Collaborate with Data Engineering and Data Analytics to ensure architecture supports reporting needs.
• Implement automated testing, data documentation, and observability to maintain a single source of truth.
• Optimize SQL queries and warehouse configurations to improve performance and reduce compute costs.
• Maintain version control workflows, CI/CD pipelines, and coding standards across the data team.
• Support the semantic layer and BI data catalogs for self-service exploration.

Skills

Software engineering practices

Modular data models

Technical communication

Education

CS/Math/Stats degree

Tools

dbt

Coalesce

Snowflake

BigQuery

Git

Job description

Celigo, Inc. is seeking an Analytics Engineer to own our Gold data layer and be the primary architect of scalable data models.

You will transform complex datasets into clean, validated tables and apply software engineering rigors (version control, automated testing, CI/CD) to ensure a trusted data warehouse. You will collaborate with Data Engineering and Analytics to support reporting, optimize queries, and maintain documentation for a self-service BI ecosystem across Product, Finance, and GTM