Job Posting

Review the details of this job and apply below.

Back to job listing

Data Engineer

  • Location: Toronto, Ontario
  • Department: Data Engineering
  • Published on: June 1, 2022

Summary

We are looking for a Data Engineer to join our diverse and rapidly growing team. As a Data Engineer, you will help support our clients and your colleagues by building automated processes to transform data and move it from one system to another. The right fit is a curious person and a systems thinker. You are someone who likes to figure out how things work and are genuinely interested in how the processes you design fit into the bigger picture. If you are eager to work with different clients and own solutions from inception through to deployment this role would be a good fit.

Success in this role will require you to be non-dogmatic in your approach and leverage your knowledge of technology to come up with solutions outside your comfort zone. As a rapidly growing company, you will play a key role in defining our processes and work on building solutions that are future-proof and can scale across use cases.

What you will do

  • Design, develop, and maintain new and existing data processing solutions to help our clients extract business value from their data.
  • Write production quality Python to develop data pipelines that move data to and from a wide variety of data sources.
  • Use third-party APIs to build integrations with various SaaS platforms used by our clients.
  • Develop complex SQL queries to merge and transform data, generate reports, and identify anomalies.
  • Audit, document and critically analyze data architecture and generate recommendations for improvements.
  • Communicate with clients’ technical and non-technical staff through meetings, presentations and written reports.
  • Perform ad-hoc data loads and extracts from and to databases, and automate these manual processes where possible.
  • Work with AWS technologies to deploy custom data applications, common ones we work with are EC2, ECS, S3, DynamoDB, Lambda and API Gateway.

What you have

This the role will require:

  • Bachelor’s degree in a technical field or equivalent experience.
  • Experience working as a Software Engineer, DBA or Data Engineer.
  • Experience working with a wide variety of technologies and tools.
  • Advanced SQL knowledge and experience working with relational databases (e.g. PostgreSQL, SQL Server, Oracle, MySQL) is essential.
  • Experience in shipping and writing production quality python code.
  • Experience working directly with clients or other stakeholders to analyze project needs and translate user needs into data requirements
  • Experience developing and deploying code to cloud services such as AWS (Preferred), GCP, or Azure.

The successful candidate will also have a few of the following:

  • Experience with Massively Parallel Processing databases (e.g. AWS Redshift, Vertica, Snowflake).
  • Knowledge of schema design, dimensional modelling, data warehousing, and ETL best practices.
  • Some knowledge of Javascript and front-end development.
  • Experience in developing for the Salesforce ecosystem.
  • Experience working with marketing data and tools (e.g. Facebook, Google Ads, clickstream data, tagging and page tracking)
  • Experience building data pipelines with Talend or other traditional ETL tools (e.g. SSIS, Informatica, Pentaho, DataStage)
  • Bilingual in French and English.

What We Offer

  • A fast-paced work environment where every day is different
  • The opportunity for professional development through funded courses, conferences and certifications
  • A startup office space and the opportunity to join a growing, multi-disciplinary team
  • A competitive health package including dental
  • Remote work while Covid-19 measures are in place

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 [email protected]

  • Location: Toronto, Ontario
  • Department: Data Engineering
  • Published on: June 1, 2022