Celigo
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
Opens the application — the Jobs AI extension fills it for you. Set up autofill
Opens the official application on the employer’s site. No login required.
Celigo
Celigo builds data infrastructure and analytics solutions that transform raw data into reliable, well-documented data models serving as a single source of truth for organizations. The company is hiring Analytics Engineers to design scalable data architectures using modern tools like dbt/Coalesce and support data-driven decision-making across product, finance, and go-to-market functions.
- Website
- celigo.com
Likely interview questions
- Walk us through your experience designing and maintaining data models with dbt or Coalesce. How do you approach structuring a Star Schema or Kimball model to balance flexibility with performance?
- Tell us about a time you implemented automated testing and documentation for a data warehouse. What frameworks did you use, and how did it improve data quality or team velocity?