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 aworkplace culture of inclusion that is welcoming, respectful and safe for allstaff. It is critical to Covenant House Toronto success to eliminate barriersand promote the inclusion of equity groups. Equity groups have been, andcontinue to be, underrepresented and marginalized in the workforce, leadershiproles, and in some specific occupations. Equity groups include but may not belimited to Indigenous persons, racialized people, gender diverse people,2SLGBTQIA+ people, and people with disabilities.

In accordance with the Ontario Human RightsCode, Accessibility for Ontarians with Disabilities Act and Covenant HousePolicy on Accommodation, a request for accommodation will be accepted as partof the Covenant House recruitment process

#J-18808-Ljbffr