Data Analytics Engineer II
Canada Remote
Updated on 11/30/2023
Fullscript

201-500 employees

Company Stage

Private

Total Funding

$273.1M

Founded

2011

Headquarters

Ottawa, Canada

Growth & Insights
Headcount

6 month growth

6%

1 year growth

5%

2 year growth

33%
Locations
Ottawa, ON, Canada
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
BigQuery
Data Analysis
Airflow
MySQL
Postgres
Redshift
Snowflake
SQL
Python
CategoriesNew
Data & Analytics
Requirements
  • 2+ years in Data Analytics and/or Data Engineering position as part of ETL/ELT process or data insights development
  • Strong proficiency with SQL, and using Python for data transformation
  • Experience working with dbt (data build tool)
  • Experience working with Cloud Data warehouses like Snowflake, BigQuery, Redshift and RDBMS (PostgreSQL, MySQL)
  • You write tests for data quality as part of the data pipeline and understand their value
  • Keen interest in learning more about programming, modern data stack and data engineering.
Responsibilities
  • Collaborate across functions such as analytics, product, and operations to understand their data
  • Write the data transformation code in ELT pipelines to integrate that data into our data warehouse for consumption by the reporting and data analytics functions
  • Create and populate the data models for downstream consumption and write tests to ensure data quality
  • Apply version control, testing and continuous integration (CI) in the data transformation code
  • Maintain data documentation and definitions
Desired Qualifications
  • Experience writing and implementing data transformation pipelines in Argo, Airflow or similar Workflow orchestration tools
  • Data warehouse modeling experience
  • DevOps experience