Data Engineer Revenue Oakville

Job description

Data Engineer

Application Deadline: 20 January 2023

Department: Revenue

Employment Type: Full Time

Location: Oakville

Description Why this opportunity at Calligo? Connect with colleagues globally Working closely with colleagues across the UK, Europe and North America we have vibrant, modern office spaces all over the world! This is an exciting role for an individual to join us as a Data Engineer to excel in the design, creation, management and business use of extremely large datasets. Supportive and dynamic team You’ll be joining our award-winning, talented team and you'll get to know the clever humans at Calligo. We know how hard our team works and that our success comes from our people – a safe and supportive culture and employee wellbeing are at the heart of what we do. Interested? The role would be well suited to an individual who is an expert in the architecture of data warehousing solutions for the Enterprise using multiple platforms. You should have excellent business and communication skills to be able to work with business analysts and engineers to determine how best to design the data warehouse for reporting and analytics. You will be responsible for designing and implementing scalable ETL processes in the data warehouse platform to support the rapidly growing and dynamic business demand for data, and use it to deliver the data as service which will have an immediate influence on day-to-day decision making. You should have the ability to develop and tune SQL to provide optimized solutions to the business.

Key Responsibilities
  • Contribute to the architecture, design and implementation of next generation BI solutions – including streaming data applications
  • Manage AWS resources including EC2, RDS, Redshift, Kinesis, EMR, Lambda etc
  • Collaborate with BIEs and BAs to deliver high quality data architecture and pipelines.
  • Interface with other technology teams to extract, transform, and load data from a wide variety of data sources.
  • Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers
Skills, Knowledge and Expertise
  • 3+ years of Industry experience in software development, data engineering, business intelligence, data science, or related field with a track record of manipulating, processing, and extracting value from large datasets
  • Experience working with AWS data technologies (EMR, Redshift, S3, AWS Glue, Kinesis and Lambda for Serverless ETL)
  • Hands-on experience and advanced knowledge of SQL
  • Basic scripting skills using Python and Scala
  • Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets
  • Demonstrated strength in data modelling, ETL development, and data warehousing
  • Proven success in communicating with users, other technical teams, and senior management to collect requirements, describe data modelling decisions and data engineering strategy
  • Training and development for career growth
  • 25 Days Holiday, increasing with length of service
  • RRSP
  • Healthcare
  • Life Insurance
  • Flexible working

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.