logo

View all jobs

Data /ETL Engineer

Vaughan, Ontario
The impact you will have:
This is a unique opportunity for individuals who are truly passionate about operational and technological support and love to grow in the rule. This opportunity requires the ability to collaborate with colleagues from many functional departments including finance, sales, operations, marketing and IT to build the next generation of our business intelligence and business analytics platform.

What you’ll do:
  • Provide information management and delivery leadership and support for the business groups and Analytic & Reporting Platforms (Data Warehouse & Data Lake)
  • Design and build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, NoSQL, on-premise or cloud (AWS or Azure)
  • Partnering with assigned business areas to understand and prioritize information needs and translate business requirements into systems solutions
  • Consult with business and IT partners in strategizing, planning and implementing larger, multifaceted projects within designated time and budget constraints
  • Responsible for various types of technical documentation. Specific documents include business requirements, functional/technical specifications, process flows, unit test plans, QA tests and user acceptance plans
  • Implement and deploy solution based on standards developments procedures and best practices
  • Facilitate discussions with user groups on how system solutions can help enable new business initiatives

 

What you’ll bring to the table:
  • Progressive experience in business analysis, data analysis systems, including working in a DW/BI/Data Lake environment
  • Client focus - collaborate directly with owners and subject matter experts (SMEs) of the business process; eager to understand the needs of the business and support sales, marketing, and technical services divisions
  • 7+ years of proven experience in the design and implementation of modern data lake/warehouse architecture: Cloud (AWS), Data Delivery/Analytics, Data Modeling, ETL/ELT Tools Master Data Management and of developing highly automated and documented solutions
  • Project experience through complete lifecycle build of BI system, major release iterations, DG compliance
  • Strong Experience with AWS would be a big asset 
  • Experience with REST API, Data Platforms (IaaS, PaaS), SQL (MSSQL, TSQL), and NoSQL & Stored Procedures
  • Experience with Python, NodeJS or Golang
  • Able to work with business group leadership to provide analytical insight
  • Solid knowledge of marketing datasets such as Salesforce, CRM, Eloqua and Google Analytics
  • Experience working with Power BI or other visualization tools
  • Good understanding of data modeling concepts
  • Self-motivated individual capable of executing on multiple projects simultaneously within with cross functional teams

Share This Job

Powered by