Senior Data Engineer (Remote)

REMOTE / Toronto, Ontario, Canada �-�Permanent
This job allows you to work remotely�

Job Description

Are you an experienced Data Engineer looking for a new challenge? Do you thrive in a dynamic environment and enjoy working with cross-functional teams? Look no further! We are seeking an experienced Data Engineer to join our team and contribute to the overall success of our Data teams.

Must Have Skills:

What You've Done:

- You have 5+ years of experience in a Data Engineer role
- You have attained a Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field
- You have advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
- You have experience building and optimizing �big data� data pipelines, architectures, and data sets
- You have experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
- You have strong analytic skills related to working with unstructured datasets
- You have built processes supporting data transformation, data structures, metadata, dependency, and workload management
- You have a successful history of manipulating, processing and extracting value from large disconnected datasets
- You have a working knowledge of message queuing, stream processing, and highly scalable �big data� data stores
- You have strong project management and organizational skills
- You have experience supporting and working with cross-functional teams in a dynamic environment
- You have strong data analysis and modeling experience for complex environments.

What You'll Be Doing:

- Creating and maintaining optimal data pipeline architecture
- Assembling large, complex data sets that meet functional / non-functional business requirements
- Identifying, designing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Building the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS �big data� technologies
- Building analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics
- Working with stakeholders including the Executive, Product, Data, and Design teams to assist with data-related technical issues and support their data infrastructure needs
- Keeping our data separated and secure across national boundaries through multiple data centers and AWS regions
- Creating data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader
- Working with data and analytics experts to strive for greater functionality in our data systems

Tech Stack You'll Be Working With:

- Data Integration
- Query Optimization
- Python (Programming Language)
- Amazon S3
- Snowflake
- DBT
- Airflow
- PostgreSQL
- SQL
- Pentaho
- Extract, Transform, Load (ETL)
- Business Intelligence (BI)
- SQL
- DBT
- Snowflake
- DBT unit testing
- DBT CI/CD
- Airflow

What's In It For You:

- Competitive salary and benefits package
- Opportunity to work with a dynamic and passionate team
- Chance to contribute to the overall success of our Data teams
- Opportunity for growth and advancement within the company
- Fun and collaborative work environment

Don't miss out on this exciting opportunity! Apply now to join our team as a Data Engineer.