Analytics Engineer

About the role

Celigo is seeking an Analytics Engineer to lead the transformation of raw data into actionable insights. This role involves developing and maintaining scalable data models, collaborating with engineering teams, implementing automated testing, and optimizing warehouse configurations.

Responsibilities

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

Requirements

• Strong belief in applying software engineering best practices (testing, versioning, peer review) to data workflows.
• Ability to design modular data models (Star Schema, Kimball) that balance flexibility with system performance.
• Proficiency in communicating technical trade-offs to both analysts and infrastructure engineers.

Qualifications

• Degree in Computer Science, Mathematics, Statistics, or a related quantitative field.
• 3+ years of experience in Analytics Engineering, Data Engineering, or a technical Data Analyst role.
• Expert-level proficiency in SQL with a focus on writing efficient, maintainable, and readable code.
• Hands-on experience with dbt / Coalesce and modern cloud data warehouses like Snowflake or BigQuery.
• Familiarity with Git, pull request workflows, and command-line interfaces.

Skills & Abilities

• Strong belief in applying software engineering best practices (testing, versioning, peer review) to data workflows.
• Ability to design modular data models (Star Schema, Kimball) that balance flexibility with system performance.
• Proficiency in communicating technical trade-offs to both analysts and infrastructure engineers.

Pay

Celigo reasonably expects to pay a base salary between $120,000 and $140,000 per year for this position. Actual starting base pay will be determined by skills, experience, geographic location, and other non-discriminatory factors permitted by law. Total compensation may also include variable incentives, benefits, or other perks as outlined in any formal employment offer made.

Schedule

Remote-first culture with flexible working hours.