Data Architect Data Analytics
2 weeks ago
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 Architect Data Analytics
2 weeks ago
Kitchener, ON, Canada ApplyBoard Full timeThe data engineering team is an experienced team, responsible for supporting our product development and the entire organization. In addition to building ETL pipelines to automate analytics and building integrations between systems , the team is responsible for building and maintaining the infrastructure used to host these pipelines and integrations. The...
-
Data Architect
1 day ago
Toronto, ON, Canada Equifax, Inc. Full timeSynopsis of the role The Data Architect is an organizational thought leader recognized internally and externally as the lead designer of our data assets. Leveraging Data Fabric as an enabler for business transformation, this leader is responsible for designing high level data architecture that enables the organization's transformation from a credit...
-
Data Analyst
2 weeks ago
Toronto, Canada Data SEA Consulting Full timeData 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 timeData 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
2 weeks ago
Toronto, Canada Data SEA Consulting Full timeData 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
2 weeks ago
Toronto, Canada Data SEA Consulting Full timeData 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 Architect
3 weeks ago
Toronto, Ontario, Canada Project X Full timeRole SummaryAs a Data Architect at Project X Ltd., you will be providing our clients with your knowledge and experience in making sense of messy, unstructured data. The Data Architect will be responsible for designing, implementing, and overseeing end-to-end solutions that address designing scalable and efficient data solutions, and complex business...
-
Data Architect
3 weeks ago
Toronto, ON, Canada Project Limited Full timeRole Summary As a Data Architect at Project X Ltd., you will be providing our clients with your knowledge and experience in making sense of messy, unstructured data. The Data Architect will be responsible for designing, implementing, and overseeing end-to-end solutions that address designing scalable and efficient data solutions, and complex business...
-
Data Architect Data Analytics
6 days ago
Toronto, ON, Canada Bow River Solutions Full timeBased in Calgary, Alberta, Bow River Solutions provides Business Intelligence solutions that transform your data into actionable insights. Our successful projects across Canada and the USA, spanning diverse sectors such as Energy, Technology, Finance, and more, have solidified our position as a trusted and respected leader in the Calgary analytics...
-
Data Architect Data Analytics
3 weeks ago
Toronto, ON, Canada Procom Labs Full timeIn 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 management) of...
-
Senior Data Engineer
2 weeks ago
Toronto, ON, Canada Tiger Analytics, LLC Full timeTiger 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...
-
Coordinator / data analyst / data entry clerk
2 weeks ago
London, ON, Canada Abs Data Full timeInstall Coordinator/Data Analyst/Data Entry Clerk/Part Time Install Coordinator/Data Analyst/Data Entry Clerk/Part Time be responsible for analyzing and interpreting large datasets to provide valuable insights and recommendations to the business. They will work closely with cross-functional teams to gather and analyze data, develop reports, and provide...
-
Data Architect
2 days ago
Old Toronto, Canada Equifax, Inc. Full timeSynopsis of the role The Data Architect is an organizational thought leader recognized internally and externally as the lead designer of our data assets. Leveraging Data Fabric as an enabler for business transformation, this leader is responsible for designing high level data architecture that enables the organization's transformation from a credit...
-
Data Architect
1 day ago
Old Toronto, Canada Equifax, Inc. Full timeSynopsis of the role The Data Architect is an organizational thought leader recognized internally and externally as the lead designer of our data assets. Leveraging Data Fabric as an enabler for business transformation, this leader is responsible for designing high level data architecture that enables the organization's transformation from a credit...
-
Data Architect
2 days ago
Old Toronto, Canada Equifax, Inc. Full timeSynopsis of the role The Data Architect is an organizational thought leader recognized internally and externally as the lead designer of our data assets. Leveraging Data Fabric as an enabler for business transformation, this leader is responsible for designing high level data architecture that enables the organization's transformation from a credit...
-
Data Architect
2 days ago
Old Toronto, Canada Equifax, Inc. Full timeSynopsis of the role The Data Architect is an organizational thought leader recognized internally and externally as the lead designer of our data assets. Leveraging Data Fabric as an enabler for business transformation, this leader is responsible for designing high level data architecture that enables the organization's transformation from a credit...
-
Data Architect
2 weeks ago
Toronto, Canada hireVouch Full timeData ArchitectAbout Us: We're committed to leveraging data to drive insights, innovation, and strategic decision-making. As a Data Architect, you'll play a pivotal role in shaping our (and our clients) data infrastructure and ensuring the integrity, efficiency, and accessibility of our data assets.Job Description:As a Data Architect, you will be responsible...
-
Senior Data Architect
2 weeks ago
Toronto, ON, Canada Mortgage Automator Inc. Full timeSenior Data Architect – Business Intelligence & Analytics Toronto Full-time 60% Office, 40% Home Reports To: CTO | Revision Date: March 2024 | Department: Data Analytics Key Responsibilities Data Integration and Management: Responsible for connecting and integrating Mortgage Automator’s backend system with platforms such as Power BI or...
-
Data Architect
2 weeks ago
Toronto, ON, Canada Blanc Labs Inc. Full timeBlanc Labs is a premier partner for global enterprises, leading the way in digitization, automation, and the development of next-generation digital products and services. Our expertise in digital transformation powers businesses to accelerate service delivery, drive customer engagement, and foster growth. The Data Architect will be responsible for...
-
Senior Data Engineer
2 weeks ago
Toronto, Canada Tiger Analytics Full timeTiger 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 firms,...
