- Company Name
- FreshBooks
- Job Title
- Analytics Engineer
- Job Description
-
**Job Title:** Analytics Engineer
**Role Summary:**
Design, develop, and maintain scalable data models and transformation pipelines using dbt within a modern cloud data warehouse. Ensure data quality, governance, and performance while enabling self‑service analytics for business users.
**Expectations:**
- 3‑5 years of hands‑on analytics engineering or data warehousing experience.
- Advanced SQL expertise with strong query‑optimization skills.
- Proven ability to translate business requirements into efficient technical specifications.
- Effective communicator who can collaborate with data engineers, analysts, and stakeholders.
- Commitment to engineering best practices, documentation, and continuous improvement.
**Key Responsibilities:**
- Collaborate with stakeholders to define modeling requirements and align on raw data ingestion.
- Architect and maintain scalable dimensional data models in dbt.
- Write, test, and monitor automated data quality checks (dbt tests).
- Implement version control, pull‑request reviews, and CI/CD pipelines for transformation code.
- Optimize warehouse performance and cost (incremental models, clustering/partitioning).
- Enforce data governance, PII tagging, and code standards (SQL linting, DRY principles).
- Produce and upkeep documentation: ERDs, data dictionaries, lineage maps, and business glossaries.
- Provide technical support to BI analysts, guiding query optimization and self‑service best practices.
- Evaluate and recommend new tools/technologies for the data ecosystem.
**Required Skills:**
- Advanced SQL (complex joins, window functions, performance tuning).
- Proficiency with dbt, Git, and CI/CD workflows.
- Experience with cloud data warehouses (BigQuery, Snowflake, Redshift, etc.).
- Strong understanding of dimensional modeling and data warehousing concepts.
- Familiarity with BI tools (e.g., Looker, Tableau) and how they consume data models.
- Excellent written and verbal communication; ability to adapt messaging for technical and non‑technical audiences.
**Required Education & Certifications:**
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or a related quantitative field, **or** equivalent professional experience.
- Relevant certifications (e.g., Google Cloud Professional Data Engineer, Snowflake SnowPro, dbt certification) are a plus but not mandatory.