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
Senior Analytics Engineer building cloud data pipelines, analytical models, and BI dashboards for Valtech, an experience innovation company. Translating client business questions into reliable, governed data solutions.
Intermediate ETL Developer migrating customer data into Pandell - ESG’s energy software. Writing conversion scripts, adapting ETL frameworks, and leading technical implementation projects.
Analytics Engineer transforming data for Lightspeed’s commerce and financial services platform. Building pipelines, models, quality checks, and Looker reporting for cross - functional teams.
Senior Analytics Engineer building trusted financial data products for Kraken, a global crypto platform. Automating reconciliations, pipelines, dashboards and finance close processes.
Marketing Data Analytics Engineer building Salesforce, Marketo, and warehouse pipelines for PointClickCare’s healthcare analytics platform. Automating campaign reporting and supporting marketing - sourced pipeline insights.
Senior Analytics Engineer designing Lime’s finance - grade data warehouse and semantic layer. Ensuring governed, audit - ready reporting for the global shared micromobility business.
Analytics Engineer building Snowflake and dbt data platforms for Tucows’ Internet businesses. Applying AI, SQL, Looker, and Python to drive data - informed decisions.
Senior Analytics Engineer designing financial, GTM, and product data models for Lightspeed’s cloud commerce platform. Owning pipelines, documentation, and analytics foundations used across the business.
Senior Analytics Engineer building scalable data pipelines and AI - native analytics foundations at Mercury, a fintech company. Supporting agentic tooling, self - service analytics, governance, and data products.