Data Analytics Engineer II (Canada Remote)

What you'll do

• You will collaborate across functions such as analytics, product, and operations to understand their data
• Using that insight, you will 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
• Working with other data engineers you will 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

What you bring to the table

• 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.

Bonus

• Experience writing and implementing data transformation pipelines in Argo, Airflow or similar Workflow orchestration tools
• Data warehouse modeling experience
• DevOps experience
• Write us a cover letter explaining why data engineering is of special interest to you

What we can offer you

• Generous PTO and competitive pay
• Fullscript’s RRSP match program for financial health
• Flexible benefits package and workplace wellness program
• Training budget and company-wide learning initiatives
• Discount on Fullscript catalog of products
• Ability to work Wherever You Work Well*