Analytics Engineer

About this role

Celigo seeks an Analytics Engineer to design and maintain scalable data models that serve as a trusted single source of truth for the organization. You'll apply software engineering best practices to transform raw data into clean, documented schemas using dbt/Coalesce, while optimizing performance and supporting data-driven decisions across Product, Finance, and GTM teams.

What you'll do

• Develop and maintain scalable data models using dbt/Coalesce to transform raw data into production-ready schemas
• Implement automated testing, data documentation, and observability frameworks to ensure data quality
• Optimize SQL queries and warehouse configurations for performance and cost efficiency
• Collaborate with Data Engineering and Analytics teams on technical architecture and business logic
• Maintain version control workflows, CI/CD pipelines, and coding standards across the data team
• Support semantic layer and BI catalogs to enable self-service data exploration

What they're looking for

• Expert-level SQL with focus on efficient, maintainable code
• dbt or Coalesce for data transformation
• Cloud data warehouses (Snowflake or BigQuery)
• Data modeling (Star Schema, Kimball methodology)
• Git and pull request workflows
• Software engineering best practices (testing, versioning, peer review)
• Python for data orchestration (nice to have)
• SaaS/Fintech metrics understanding (nice to have)

Benefits

• Remote-first culture built on trust and collaboration
• Competitive base salary of $120,000-$140,000
• Learning opportunities to stay current with industry trends
• High-growth, inclusive work environment
• Variable incentives and additional benefits as outlined in offer