Data Engineer

2 weeks ago

Old Toronto, Ontario, Canada Kaizen Lab Inc. Full time

Data Engineer

Hybrid, Downtown Toronto

Full-time, Permanent

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 develops 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 effectively 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 quality check in the Data Warehouse ETL process. All the error and
    mismatch codes will be treated as exceptions.
  • Making sure all business rules are translated correctly into
    technical specifications.
  • 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 of the Data Warehouse project to the
    stakeholders.
  • Document data engineering processes, data models, and architecture
    changes to maintain a clear and up-to-date record of the system.
  • Facilitate knowledge sharing within the Data
    Services 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, Snowflake.
  • Advanced SQL skills, including experience Data Warehouse ETL,
    running and writing queries and stored procedures, performing inserts and
    updates.
  • 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 Jun 21,
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 Engineer

    2 weeks ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Data Engineer to join our team in Toronto, Ontario (CA-ON), Canada (CA).Data Engineer Responsibilities-Create and...

  • Data Engineer

    2 weeks ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Data Engineer (Snowflake/Python) - Remote Canada Position Day to Day / Job Responsibilities: As a Snowflake/Python...

  • Senior Data Engineer

    2 weeks ago

    Toronto, Ontario, Canada NTT DATA Full time

    Job Description Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Senior Data Engineer to join our hybrid team.Data Engineer Responsibilities- (Informatica, Snowflake,...

  • Sr Data Engineer

    4 weeks ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Sr Data Engineer to join our team in Toronto, Ontario (CA-ON), Canada (CA).Data Engineer Responsibilities-Create and...

  • Sr Data Engineer

    1 month ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Sr Data Engineer to join our team in Toronto, Ontario (CA-ON), Canada (CA).Data Engineer Responsibilities-Create and...

  • Sr Data Engineer

    2 weeks ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Sr Data Engineer to join our team in Toronto, Ontario (CA-ON), Canada (CA).Data Engineer Responsibilities-Create and...

  • Data Engineer with banking Domain – 5

    2 weeks ago

    Old Toronto, Ontario, Canada DATA MART Consulting GmbH Full time

    #HiringImmediately#contractjobs//CANADA //Toronto, ON. Please share resumes Position:Data Engineer with banking Domain – 5Location:Toronto, ONJob Type:ContractCandidate Requirements/Must Have Skills:1) 10+ years of progressive experience as Data Engineer, Software Developer, or similar technical roles.2) 5+ years' experience with SQL/NOSQL and relational...

  • Cloud Platforms Automation Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada NTT DATA Full time

    NTT DATA Services is looking for top-notch individuals who are passionate about cloud platforms and automation to join their team! This fully remote position is open to candidates across Canada.Job Title: Cloud Platforms Automation Engineer (REMOTE)The Cloud Platforms Automation Engineer will play a key role in establishing and managing automated...

  • DevOps Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada Ntt Data Services Full time

    NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a DevOps Engineer (Onsite) to join our team in Halifax, Nova Scotia (CA-NS), Canada (CA). Platform Solutions team is...

  • Data Engineer, Forecasting Core Data Engineering

    2 weeks ago

    Old Toronto, Ontario, Canada Amazon Development Centre Canada ULC Full time

    Amazon Forecasting Team Data EngineerAmazon Forecasting team is looking for a Data Engineer to join the team. We are pioneers in the fields of Amazon demand analysis and forecasting. Forecasting data engineers build scalable data transformation pipelines to ingest data from different data sources, and provides big data sources for machine learning models to...

  • Data Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada Zortechsolutions Full time

    Role: Data Engineer (DE) Location: Remote/Canada Duration: 12+ Months Job DescriptionWhat you'll do: Build and maintain scalable data infrastructure that offers a best-in-class experience for internal stakeholders including consistent extraction of value from the data Drive data ingestion and processing in innovative ways that inform strategic priorities and...

  • Data Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada Spirit Omega Inc. Full time

    Data EngineerCompany OverviewJob Reference:RFP Hours of work: 40Location: Toronto, ON (100% Remote)Contract Duration: 3 monthsLanguage: EnglishKey Responsibilities:Design, build and productionize modular and scalable data pipelines and data infrastructure leveraging the wide range of data sources across the organization.Implement curated common data models...

  • Data Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada Quantexa Full time

    We are in search of an experienced Data Engineer to join our awesome team at Quantexa in Toronto, Ontario, Canada.Growing your career as a hybrid Data Engineer is an incredible opportunity to develop fundamental skills.If you are strong in planning, research and have the right drive for the job, then apply for the position of Data Engineer at Quantexa...

  • Data Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada Highbrow LLC Full time

    Job Title: Data EngineerJob ID: Job Location: Toronto, ON (2 days/week onsite)Job Travel Location(s):# Positions: 4Employment Type: W2Duration:Long term# of Layers:0Work Eligibility:All Work Authorizations are Permitted – No Visa TransfersKey Technology:PySpark, SQL, Databricks, Alteryx, Tableau, PythonJob Responsibilities:Work and develop in the Data...

  • Data Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada The Home Depot Full time

    Data Engineer Job At The Home Depot in Toronto, ONM3C 3N6The Home Depot Canada is a unique opportunity for you to become part of a transformative team as we continue on our mission to provide the best interconnected shopping experience to our customers. As part of the Analytics team, you will be tasked with absorbing billions of rows of data from dozens of...

  • Data Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada Alpha Consulting Corp. Full time

    We are currently seeking a "Data Engineer" for a contract role with one of our clients in Toronto, ON. Please apply you would be interested and available for it.Duration: 6+ MonthsResponsibilitiesWhat you¬タルll do¬Architecture, design, development, and delivery of enterprise-grade analytics solutions based on Azure and Databricks...

  • Cloud Platforms Automation Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada NTT DATA, Inc. Full time

    Company: NTT DATA ServicesNTT DATA Services is actively looking for a Cloud Platforms Automation Engineer (REMOTE) to be part of their team. This role allows you to work from anywhere in Canada.The Cloud Platforms Automation Engineer will focus on creating and managing automated infrastructure for the cloud platforms, handling tasks like provisioning,...

  • Data Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada Finance Professionals Inc. Full time

    Typical Day in Role:• Collaborate with business lines and other stakeholders and identify opportunities to drive business value by leveraging data engineer.• Efficiently handle large volumes of structured and unstructured data through ingestion, modeling, transformation, and storage across diverse data stores. Leverage distributed computing tools (e.g.,...

  • Data Engineering Manager

    2 weeks ago

    Old Toronto, Ontario, Canada EightSix Network Inc Full time

    The Toronto hub will serve as the base of our new Data/AI team, dedicated to building a modern data infrastructure for advanced analytics and the development of responsible AI. This strategic investment is integral to for organization's vision for the future, aiming to develop cutting-edge Generative AI and analytical capabilities that will underpin the...

  • Data Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada Kinross Gold Corporation Full time

    Start DateASAPHybrid Work Environment(3 days in office, 2 days remote with flexible hours)Dress CodeBusiness CasualLocationDowntown Toronto, Outside of Union Station (TTC & GO accessible)A Great Place to WorkWho We AreKinross is a Canadian-based global senior gold mining company with operations and projects in the United States, Brazil, Mauritania, Chile and...