Canals is looking for a Data Analyst to transform ad-hoc business inquiries into production-grade data models, ensuring data correctness, observability, and reusability for the entire company.
Requirements
- Production SQL experience (Snowflake, BigQuery, Redshift or similar).
- Solid dbt experience: models, tests, macros, CI practices, and modular modeling patterns.
- Proven track record of converting one-off analyses into reusable data models.
- Comfortable with Python for data tasks, Git-based workflows, and CI pipelines.
- Strong understanding of data lineage, monitoring, and testing best practices.
Responsibilities
- Own core business metrics end-to-end: design, implement, test, document, and maintain them in dbt and Snowflake.
- Convert ad-hoc analyses into durable, reusable warehouse artifacts rather than dashboard patches.
- Implement and maintain automated data tests, monitors, and lineage; integrate them into CI.
- Troubleshoot ingestion and transformation issues and ship fixes upstream (dbt/Snowflake) instead of working around problems at the edge.
- Partner closely with other teams to ensure data is performant, stable, and production-ready for models.
- Support product and commercial teams with analysis and insights.
- Surface platform roadmap work: identify recurring needs that should become new marts, schemas, or pipelines.
Other
- While you will collaborate closely with business stakeholders to ensure successful outcomes, your core ownership lies with the data warehouse: ensuring data correctness, observability, and reusability for all.
- Excellent stakeholder communication, able to map business questions to repeatable data products and document assumptions.
- Experience working in fast-paced teams and owning projects end-to-end.
- Improve self-serve documentation, tools, and onboarding so others can rely on the warehouse without manual hand-holding.
