Analytics Engineer

Data Sciences Inc.; Montreal (administrative region); On-site; CAD 90,000 - 120,000; Full time

Job summary

Data Sciences Inc. in Montreal is seeking an Analytics Engineer to design, develop, and maintain the data transformation layer and dimensional models feeding BI tools. You will enable data democratization and collaborate with both technical and non-technical stakeholders to deliver reliable analytics infrastructure.

The role emphasizes scalable data models, ELT pipeline understanding, and strong documentation. A proactive, problem-solving mindset is valued in this fast-growing team.

Qualifications

• Bachelor’s degree in a technical field or equivalent experience.
• 3+ years of experience writing production-grade SQL as an analytics engineer, data engineer, data analyst, or related role.

Responsibilities

• Design and develop complex data models and transformations that standardize data definitions and promote data democratization.
• Lead discussions with technical and non-technical stakeholders in order to understand business objectives and document requirements.
• Work with our engineering team to understand what data is captured by our ELT pipelines, where, and how.
• Produce detailed documentation describing the data models and the jobs that generate them
• Build and own analytics infrastructure that delivers good quality data, reliably

Skills

SQL

dbt

Data Warehousing

Data Modeling

ETL/ELT

Git

CI/CD

BI Tools familiarity

Communication

Education

Bachelor’s degree in a technical field

Tools

dbt

Airflow

Redshift

Snowflake

BigQuery

Databricks

Git

Job description

We are looking for an Analytics Engineer to join our diverse and rapidly growing team in Montreal. The successful candidate will be responsible for designing, developing, maintaining the data transformation layer and building dimensional models that will feed BI tools. The objective for the role is to facilitate reporting and analytics for technical and non-technical users alike. We are looking for big picture thinkers with strong communication skills and a track record of independent problem-solving. We value creativity and innovation, hard work and on-the-job excellence. The ideal candidate is someone who is highly motivated and who seeks to take on a challenging role.

What you’ll do

• Design and develop complex data models and transformations that standardize data definitions and promote data democratization
• Lead discussions with technical and non-technical stakeholders in order to understand business objectives and document requirements.
• Work with our engineering team to understand what data is captured by our ELT pipelines, where, and how.
• Produce detailed documentation describing the data models and the jobs that generate them
• Build and own analytics infrastructure that delivers good quality data, reliably

Requirements

• Bachelor’s degree in a technical field or equivalent experience.
• 3+ years of experience writing production-grade SQL as an analytics engineer, data engineer, data analyst, or related role.
• 2+ years hands‑on experience with dbt (models, tests, macros) in production.
• Solid understanding of data warehousing concepts (ETL/ELT, data marts), and data modeling techniques (dimensional modeling, one big tables, etc.).
• Familiarity with data warehouses such as Redshift, Snowflake, BigQuery, or Databricks.
• Experience with version control (Git), DevOps practices, and CI/CD pipelines.
• Excellent communication skills, with the ability to generate technical requirements from a set of non-technical stakeholder interviews.
• Strong attention to detail, with a focus on data accuracy, quality, and integrity.
• Some experience with common BI tools are an asset (e.g. Power BI, Tableau, Looker).

Additional Assets

• Demonstrate a strong intuition for data product design
• Experience working with an orchestrator (Airflow, Dagster, AWS Step Functions)
• Familiarity with semantic modeling using LookML, Cube, MetricFlow, etc. is a plus
• Knowledge of Python, bash.

We encourage applications from all qualified candidates and are committed to equal employment opportunities. If you have a disability or special need that requires accommodation, please let us know during the recruitment process or by emailing [e-mail].