Data Engineer

3 weeks ago

Toronto ON, Canada Kaizen Lab Inc. Full time

Data Engineer

Hybrid, Downtown Toronto

1 Year full-time Contract from start date

Level 8

Purpose of the Position:

The Data Engineer is responsible for the development and management of Covenant House Toronto’s Data Warehouse that is essential to the day-to-day tactical planning and the longer-term investment planning of the Development and Communications Department.

The Data Engineer establishes and maintains the data warehouse architecture frameworks, standards, and principles within the CRM, marketing automation and the data integration software and tools that extract key data from internal and external business systems and transforms and loads it to our data warehouse and data analytics environment.

Working with cross-functional teams this position is responsible for developing the data architecture, models and integration services that provide the capability to view and analyze CRM data and other marketing data from the Data Warehouse. The individual will interact affectively with business owners, data analyst, and other teams within the department to bring new features and platform enhancements from conception to release by following best practices in data governance, communicating, documenting, and interacting effectively with both technical and non-technical professionals.

Duties / Responsibilities:

  • Define and implement data architectures that align with business requirements to support on premise CRM and Marketing Automation
  • Develop and maintain data models, ensuring they support scalability, performance, and data integrity both on premise and on cloud.
  • Develop data architecture, models and integration services that provide a cross-cutting view of data from our Data Warehouse.
  • Create and maintain ETL Data Warehouse, SSIS Package on premise and on cloud.
  • Ensure ETL pipelines are produced with the highest quality standards, metadata and validated for completeness and accuracy.
  • Managing schema changes and ensuring data consistency.
  • Implement Event Handlers in managing various events in the ETL process
  • Create and maintain secured data connectivity via REST API to Engaging Networks, Payment Gateway (iATS), AKA Raisin and Canada Post
  • Keep up with the technology trend of Data Warehouse, Marketing Automation, Data Integration, Data Visualization and Analytics
  • Responsible for the completion of high quality, well designed, and well tested data ETL pipelines (data streams) which tailored to marketing and CRM needs.
  • Establish quality assurance and data integrity checks to ensure accurate reporting and data records.
  • Implementing error handling and recovery mechanisms for ETL process failures.
  • Implement the second tier of quality check in the Data Warehouse ETL process. All the error and mismatch codes will be treated as exceptions.
  • Making sure all business rules is translated correctly into technical specification.
  • Implement best practices in data governance, data management, security, and privacy, with a focus on CRM and marketing data.
  • Collaborate with cross-functional teams to understand project requirements and translate to technical specifications to deliver data engineering solutions on time, within scope and on budget.
  • Prioritize and manage multiple tasks and projects effectively.
  • Provide status updates
  • Document data engineering processes, data models, and architecture changes to maintain a clear and up-to-date record of the system.
  • Document data engineering processes and solutions to facilitate knowledge sharing within the team and promote a culture of continuous learning.
  • Conduct training sessions and share knowledge with team members.
  • Other duties as assigned.

Qualifications / Experience

  • Bachelor's degree or College Diploma in Computer Science/Math/Engineering
  • Minimum of 5 years of relevant experience in a similar role.
  • Strong understanding of data warehouse best practices, data governance, data modeling, and data architecture
  • Advanced knowledge in python scripts and SQL scripts
  • Advanced knowledge with Microsoft SQL Server SSIS Package, Stored Procedures, or other ETL tools like Azure Data Factory
  • Advanced SQL skills, including experience Data Warehouse ETL, running and writing queries and stored procedures, performing inserts and updates
  • Experience using Python or other tools to support automation considered an asset.
  • Experience implementing data governance principles and experience implementing security measures to protect sensitive data
  • Experience in project management, including task prioritization, time management, and delivering projects within deadline and within the budget working through cross-functional teams.
  • Experience working with CRM and marketing data required.

What we offer:

  • Meaningful work.
  • Competitive compensation.
  • Benefits such as Health, Dental, Vision, Personal Days, Employee Assistance Program, Tuition Reimbursement and more.
  • Employee perks which include discounts on gym membership, city bike rentals, auto & home insurance and more.

Interested candidates are welcome to apply directly to this posting on or by April 2, 2024 date. Only those selected to move forward in our recruitment process will be contacted. No agencies or phone calls please.

About Covenant House Toronto

Covenant House helps youth ignite their potential and reclaim their lives. As Canada’s largest agency serving youth who are homeless, trafficked or at risk, we offer the widest range of services to hundreds of young people every day.

More than a place to stay, we provide life-changing care with unconditional love and respect. We meet youth’s immediate needs and then we work together to achieve their future goals. We offer 24/7 crisis shelter transitional housing options on-site and, in the community, health and well-being support, training and skill development, and ongoing care once youth move into the community.

For over 40 years, Covenant House has been dedicated to its mission of serving youth on the street and to protect and safeguard all youth with absolute respect and unconditional love. Since 1982, Covenant House has supported more than 100,000 young people.

At Covenant House Toronto we believe in a workplace culture of inclusion that is welcoming, respectful and safe for all staff. It is critical to Covenant House Toronto success to eliminate barriers and promote the inclusion of equity groups. Equity groups have been, and continue to be, underrepresented and marginalized in the workforce, leadership roles, and in some specific occupations. Equity groups include but may not be limited to Indigenous persons, racialized people, gender diverse people, 2SLGBTQIA+ people, and people with disabilities.

In accordance with the Ontario Human Rights Code, Accessibility for Ontarians with Disabilities Act and Covenant House Policy on Accommodation, a request for accommodation will be accepted as part of the Covenant House recruitment process

#J-18808-Ljbffr

  • Data Analyst

    3 weeks ago

    Toronto, Canada Data SEA Consulting Full time

    Data SEA Consulting – Data Analyst Company DescriptionData SEA Consulting focuses on helping mid-sized businesses harness the power of their data by leveraging the latest analytics tools and techniques. We work with Private Equity Funds and Independent Business Owners to find the unique data solutions that will drive the most value for their business....

  • Data Analyst

    4 weeks ago

    Toronto, Canada Data SEA Consulting Full time

    Data SEA Consulting – Data Analyst Company Description Data SEA Consulting focuses on helping mid-sized businesses harness the power of their data by leveraging the latest analytics tools and techniques. We work with Private Equity Funds and Independent Business Owners to find the unique data solutions that will drive the most value for their business....

  • Data Analyst

    3 weeks ago

    Toronto, Canada Data SEA Consulting Full time

    Data SEA Consulting – Data Analyst Company DescriptionData SEA Consulting focuses on helping mid-sized businesses harness the power of their data by leveraging the latest analytics tools and techniques. We work with Private Equity Funds and Independent Business Owners to find the unique data solutions that will drive the most value for their business....

  • Data Analyst

    3 weeks ago

    Toronto, Canada Data SEA Consulting Full time

    Data SEA Consulting – Data Analyst Company DescriptionData SEA Consulting focuses on helping mid-sized businesses harness the power of their data by leveraging the latest analytics tools and techniques. We work with Private Equity Funds and Independent Business Owners to find the unique data solutions that will drive the most value for their business....

  • Data Engineer

    3 weeks ago

    Toronto, ON, Canada Opencloudco Full time

    Roles and Responsibilities: Design, build, and maintain data infrastructure and pipelines to support data-driven initiatives. Develop and maintain ETL processes to extract, transform, and load data from various sources into our data warehouse. Design and implement data models and schema for efficient data storage and retrieval. Optimize data pipelines...

  • Data Engineer

    3 weeks ago

    Toronto, ON, Canada Tiger Analytics, LLC Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research...

  • iOS Engineer, Observability SDK

    4 weeks ago

    Toronto, Canada Data Theorem Full time

    Data Theorem is an exciting company focused on creating a more secure world for data. Rooted in a strong engineer first culture, every employee has an impact on product and direction. We are searching for exceptional talent pursuing an opportunity to grow and take ownership of the projects that resonate most with them.As an iOS engineer, you will be...

  • iOS Engineer, Observability SDK

    3 weeks ago

    Toronto, Ontario, Canada Data Theorem Full time

    Data Theorem is an exciting company focused on creating a more secure world for data. Rooted in a strong engineer first culture, every employee has an impact on product and direction. We are searching for exceptional talent pursuing an opportunity to grow and take ownership of the projects that resonate most with them.As an iOS engineer, you will be...

  • Manager, Data Engineering

    5 days ago

    Toronto, ON, Canada hireVouch Full time

    Manager of Data Engineering Location: Toronto/GTA Company Overview: Our client is a premier Data Cloud and Business Intelligence consulting company specializing in helping businesses harness the power of cloud technologies to drive data-driven decision-making and innovation. Our team of experts is dedicated to delivering cutting-edge solutions that...

  • Data Engineer

    5 days ago

    Toronto, ON, Canada Procom Labs Full time

    The role: In collaboration with the Business Intelligence (BI) Manager, the Data Engineer will undertake the responsibility of executing and managing Azure Data Factory Pipelines. This includes the design and implementation of the Data Lake, as well as the optimization of data refresh performance. The role encompasses ownership (both execution and...

  • Data Engineer

    4 weeks ago

    Toronto, ON, Canada Procom Labs Full time

    The role: In collaboration with the Business Intelligence (BI) Manager, the Data Engineer will undertake the responsibility of executing and managing Azure Data Factory Pipelines. This includes the design and implementation of the Data Lake, as well as the optimization of data refresh performance. The role encompasses ownership (both execution and...

  • Manager, Data Engineering

    7 days ago

    Toronto, ON, Canada DraftKings Full time

    We’re defining what it means to build and deliver the most extraordinary sports and entertainment experiences. Our global team is trailblazing new markets, developing cutting-edge products, and shaping the future of responsible gaming. Here, “impossible” isn’t part of our vocabulary. You’ll face some of the toughest but most rewarding challenges...

  • Senior Data Engineer

    3 weeks ago

    Toronto, ON, Canada Tiger Analytics, LLC Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research...

  • Senior Data Engineer

    4 weeks ago

    Toronto, ON, Canada GuruLink Full time

    Location: Toronto, Ontario Our client are on a mission to provide useful technological solutions that enrich and empower millions of people in their daily lives. They apply big data, artificial intelligence, and machine learning to bring the next generation of financial products and services to the Indian, Japanese and Canadian markets. They have created...

  • Sr. Data Engineer

    3 weeks ago

    Toronto, ON, Canada Paytm Full time

    About Paytm Labs: At Paytm Labs, we’re on a mission to provide useful technological solutions that enrich and empower millions of people in their daily lives. We apply big data, artificial intelligence, and machine learning to bring the next generation of financial products and services to global markets. We recently soft-launched Pi, our full...

  • Data Security Engineer

    5 days ago

    Toronto, ON, Canada Atlantis IT Group Full time

    Data Security Engineer TORONTO • Have 5+ years experienced in implementation of data security solutions comprises of Forcepoint DLP and integration with external solutions like AD, SIEM • Sound knowledge and experience with implementation of Enterprise Data leakage Protection, Data Discovery & Classification,. • Solid understanding of Network...

  • Data Security Engineer

    6 days ago

    Toronto, ON, Canada Atlantis IT Group Full time

    Data Security Engineer TORONTO • Have 5+ years experienced in implementation of data security solutions comprises of Forcepoint DLP and integration with external solutions like AD, SIEM • Sound knowledge and experience with implementation of Enterprise Data leakage Protection, Data Discovery & Classification,. • Solid understanding of Network...

  • Data Engineer

    3 weeks ago

    Toronto, ON, Canada Apply Digital Ltd. Full time

    Who we are: We’re a global digital transformation partner for change agents. We offer connected thinking to deliver connected results that realize a business’ vision. What we do: We empower enterprises to shift to evolving business opportunities, gain powerful insights and deliver experiences that drive growth. Who we help: Our 600+ digital...

  • Manager, Data Engineering and Platform

    5 days ago

    Toronto, ON, Canada hireVouch Full time

    Manager of Data Engineering Our client is a premier Data Cloud and Business Intelligence consulting company specializing in helping businesses harness the power of cloud technologies to drive data-driven decision-making and innovation. Our team of experts is dedicated to delivering cutting-edge solutions that empower our clients to unlock the full...

  • Data Engineer

    3 weeks ago

    Toronto, Canada Bitstrapped Full time

    We are looking for a hands-on Senior Data Engineer in a full-time salaried position. The Data Engineer will work with our Data Services Practice and work alongside our talented cloud architects to play a key role in our delivery teams. The Data Engineer will be involved in the design, programming, and implementation of data platform components and serve as a...