Chef d’équipe Analytics Engineer chez Lightspeed, plateforme infonuagique de commerce mondiale. Transformation des données et leadership d’une équipe analytique pour soutenir les décisions fondées sur les données.
About the role
- Analytics Data Engineer turning ingested data into trusted analytical assets for dashboards and insights. Collaborating with various teams to enhance data models and support decision-making.
Responsibilities
- Design and build scalable data transformation pipelines using SQL, DBT, and Jinja templating
- Develop and maintain dimensional data models optimized for analytics and BI consumption
- Own the analytics data layer in DBT, enabling self-service analytics for business users
- Collaborate with product, analytics, and BI teams to translate business requirements into data models
- Enhance and maintain analytics codebases including DBT models, macros, tests, and documentation
- Implement data quality checks, tests, and governance-aligned transformations
- Optimize SQL for performance using partitioning, clustering, and materialized views
- Ensure semantic consistency and metric definitions across dashboards and reports
- Apply software engineering best practices including version control, CI/CD, and peer code reviews
- Support Agile development and collaborate with offshore teams for delivery and reviews
Requirements
- Bachelor’s or Master’s degree in Computer Science, Statistics, Mathematics, or a related field
- 5 years or more of experience in analytics-focused data engineering
- 3 years or more of deep hands-on experience with DBT, including advanced models, macros, and packages
- Strong expertise in dimensional modeling and data warehousing concepts
- Proficiency in SQL performance tuning and large-scale analytical query optimization
- Experience working with Amazon Redshift and modern cloud data platforms
- Familiarity with Python and/or Jinja templating for analytics engineering
- Experience aligning data models with governance, privacy, and access-control requirements
- Agile experience and comfort working with extended offshore teams
- Strong ownership mindset, attention to detail, and passion for building clean, trusted data products
Benefits
- Bonuses
- Paid Time Off policy
- Region specific benefits
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Staff Engineer owning analytics architecture and data modeling at Oscilar, an AI risk decisioning platform for fraud, credit, and compliance. Building tiered data infrastructure, optimizing database performance, and shaping long - term analytics platform strategy.
Senior Data Analytics Engineer building automated reporting and business insights for Dotmatics’ cloud scientific research platform. Partnering across Sales, Product, Marketing, and Finance to enable self - service analytics.
Analytics Engineer building trusted data models, pipelines, dashboards, and GTM workflows for Linear’s product development system. Partnering across Product, Engineering, and GTM to make data actionable.
Senior Analytics Engineer building trusted, AI - ready analytics infrastructure for Luxury Presence’s real estate growth platform. Owning dbt, Snowflake, Python pipelines, semantic layers, and cross - system data quality.
Junior Analytics Engineer maintaining data pipelines, models, and dashboards for Top Hat, an education technology company. Supporting operational teams with trusted data, SQL analysis, and data quality improvements.
Associate Analytics Engineer building governed, tested data models and pipelines for CircleCI, the world’s largest CI/CD platform. Supporting business users, downstream systems, and AI - powered workflows through reliable analytics engineering.
Analytics Engineer building scalable data models and pipelines for Tailscale’s secure networking platform. Supporting reporting, analysis, and decision - making across Finance, Engineering, Sales, and other teams.
Data Analytics Specialist supporting the design and development of analytical products for Alberta government. Collaborating with team to leverage data assets and enhance service delivery.
Senior Data Engineer on the Graph Analytics team building scalable systems for analyzing cryptocurrency transactions. Collaborating with data scientists and engineers to design graph algorithms.