Analytics Engineer

Transform data into business impact. Spendesk is seeking a skilled Analytics Engineer to join our growing data organization. Reporting to the Head of Data, you will be responsible for transforming raw data into business-ready datasets, building dimensional models, and enabling self-service analytics across the organization.

About the role: As an Analytics Engineer, you will bridge the gap between data engineering and data analysis/business team by creating clean, documented, and reusable analytics assets. You will work closely with Data Engineers, Data Scientists, and business stakeholders to implement data quality testing, build dimensional models, and enable data-driven decision making throughout Spendesk. This role requires an engineer who can translate business requirements into robust data models, implement best practices for data transformation, and create analytics solutions that scale with our business growth.

Our tech environment: Our data platform relies on dbt (core and Cloud), Snowflake, Looker (original), Metabase, and Amplitude for Product analytics. For ingestion/exposure: Airbyte (cloud), Fivetran, Airflow, Hightouch, Segment. We use Github for versioning, CI/CD, and Synq for observability.

Key Responsibilities:

• Transform raw data into business-ready datasets using dbt and modern data stack tools.
• Build and maintain dimensional models that serve BI and Product needs.
• Implement business logic and calculations in the data transformation layer.
• Create reusable analytics assets that can be leveraged across multiple use cases.
• Ensure data models follow best practices for performance, maintainability, and scalability.
• Implement comprehensive data quality testing using dbt tests.
• Develop and maintain data quality monitoring and alerting systems.
• Create data validation rules that catch issues before they impact business decisions.
• Establish data quality metrics and SLAs for analytics datasets.
• Collaborate with all stakeholders to resolve data quality issues at the source.
• Enable self-service analytics by creating intuitive, well-documented data models.
• Partner with business and product stakeholders to understand analytics requirements and translate them into technical solutions.
• Build metric definitions and calculations that ensure consistency across the organization.
• Create data documentation and maintain data catalogs for business and product stakeholders.
• Provide training and support to stakeholders on analytics tools and data interpretation.

Stakeholder collaboration:

• Work closely with analysts and data scientists to provide analysis-ready datasets.
• Collaborate with business stakeholders to understand requirements and design appropriate data solutions.
• Partner with Data Engineers to ensure optimal data pipeline design and performance.
• Communicate technical concepts clearly to both technical and business audiences.

What we’re looking for:

Experience & Background:

• 3-5 years of experience in analytics engineering, data analytics, or related data roles.
• Proven track record of building data models and transformations in production environments.
• Experience working with business stakeholders to translate requirements into technical solutions.
• Background in implementing data quality testing and monitoring practices.

Technical Requirements:

• Expert proficiency in SQL and advanced capabilities.
• Hands-on experience with dbt for data transformation and modeling.
• Experience with cloud data warehouses (Snowflake).
• Experience with data quality testing frameworks (e.g. dbt tests).
• Proficiency in version control systems (Git, GitHub).
• Understanding of dimensional modeling concepts and best practices.

Analytics & Business Skills:

• Strong understanding of business intelligence and analytics concepts.
• Experience with data visualization tools and self-service analytics platforms.
• Ability to translate business requirements into technical data solutions.
• Knowledge of statistical concepts and data analysis methodology.

Diversity & Inclusion: At Spendesk, we’re committed to fostering an environment where all differences are encouraged, supported and celebrated. We’re building our culture for everyone, with everyone. Our goal is to attract and build a diverse, equal and inclusive team, where everyone feels welcome and we truly embrace and encourage people from all backgrounds to apply.

Benefits:

• Flexible on-site and remote policy.
• Lunch 60% funded by Spendesk (Swile Card).
• Alan Premium health insurance.
• A Gymlib pass to let off steam after a productive day at work.
• Access to Moka.care for emotional and mental health wellbeing.
• Great office snacks to fuel your day.
• A positive team to work with daily!