data engineer

Princeton IT Services; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in the IT sector is seeking a Data Engineer in Toronto. This role offers a unique opportunity for professional growth within an innovative team focused on data management and optimization. Key responsibilities include managing scalable data solutions and collaborating with various development teams to enhance performance. Candidates should bring extensive experience in MySQL and Snowflake, coupled with a strong aptitude for problem-solving and attention to detail.

Qualifications

• Master's Degree required.
• 5+ years of relevant work experience, especially with Snowflake and AWS.
• Expertise in database administration and data pipeline construction.

Responsibilities

• Develop and optimize data ingestion/extraction strategies.
• Collaborate with development teams to enhance database performance.
• Manage ETL processes and oversee data security best practices.

Skills

MySQL

SQL Optimization

ETL

Data Lakehouse Management

Python

Data Engineering

Database Security

Snowflake

AWS Services

Apache Tools

Education

Master's Degree

Job description

Posted onJuly 07, 2025 by Employer details Princeton IT Services

To add a job posting to your favourites, you need a Job Bank account. Sign in or sign up now!

data engineer

Posted onJuly 07, 2025 by Employer details Princeton IT Services

Add to favourites

To add a job posting to your favourites, you need a Job Bank account. Sign in or sign up now!

Sign in Sign up for a Plus account

• Email

Job details

*Job Title:* Data Engineer*Location:* Toronto*Type:* Full-Time Contract*Job Overview: *This is a great opportunity to learn, grow and become a SME in data management and database optimization in cloud technology, becoming a key player on our infrastructure team. Join our growing organization and you will get the chance to be in the driver seat of innovation and change here at Payfare as we think about new ways to better leverage data in support of our increasing mandate.As a data engineer, you will be joining a team of mixed background technologists. Our mandate is to provide flexible and stable platform solutions that empower our feature development teams to create the highest quality services for our customers. On an ongoing basis, we expand our developing, testing, and deploying reliability and resiliency features. All of this continues to require a strong backbone of database solution and design facilitating data ingestion / extraction in the most optimized way, while also ensuring data protection, integration, and ensuring data availability.We need someone with experience working in a scalable and critical environment, with hundreds of pipelines and tables*Reports To: *Data Engineering Manager*Responsibilities and Duties** Strong MySQL experience enabling platform growth and scale.* Advanced expertise and experience on schema design improvements with both tactical and strategic lens to ensure data ingestion / extraction for our warehouse database, supporting current data functions team, external reports, and operations teams.* Experience working in collaboration with development teams to optimize schema and queries for new features before they go out into production.* ETL and Data Lakehouse management expertise required.* Knowledge and experience related to migrations from MySQL to PostgreSQL would be a definite plus.* Python highly desirable, to support current ETL ingestion scripts.* Proactively identify improvements to continually improve platform and data resiliency.* Analyze system problems including root cause determination and manage any needed recovery process to ensure a quick restoration of service without loss of data.* Strong attention to detail in all daily activities.*Qualifications and Skills** Degree in Computer Science, Software Engineering or similar* 5+ years of relevant work experience* Experience in the following areas of expertise: database administration, data engineering, ETL data load and ingestion, data classification and normalization, SQL and schema optimization.* Experience in building fault-tolerant, high performant, scalable, data pipelines, in a large and complex environment, e.g. in financial services.* Strong expertise in Snowflake, including its various features.* Experience with various AWS services such as Lambda, Redshift, DMS* Experience with various Apache tools such as Airflow, Superset, Kafka* Expertise in Linux system administration, web servers, and networking would be an asset.* Kubernetes experience would be an asset.* Experience with implementation of database security hardening best practices, including collaboration among cross-functional teams to encourage safe and zero-trust access.* Experience with other cloud vendors with similar technologies is a plus* A deep curiosity that motivates you to keep on top of technical trends and informs your ability to suggest tools and approaches to interesting problems.* The ability to empathize with and communicate clearly to all the other parts of the business.Job Type: Full-timePay: $50.00-$53.00 per hourSchedule:* Monday to FridayAbility to commute/relocate:* Toronto, ON: reliably commute or plan to relocate before starting work (required)Education:* Master's Degree (required)Experience:* Data Engineer: 6 years (required)* Snowflake: 6 years (required)* AWS services such as Lambda, Redshift, DMS: 4 years (required)* Apache tools such as Airflow, Superset, Kafka: 4 years (req

• Location Toronto , ON
• Workplace information On site
• Salary $ 50.00 to $ 53.00 HOUR hourly
• Terms of employment Full time
• Starts as soon as possible
• vacancies 1 vacancy
• Source indeed.com #9803862858

• Toronto, ON

View the full job posting on indeed.com

Important notice: This job posting has been provided by a partner site. Job Bank is not responsible for this content.

Report a problem with this job posting * What’s wrong? This job posting contains incorrect information Inaccurate salary Inaccurate job title Link to full job posting / Expired or closed job posting Provide more details: Report potential misuse of Job Bank

Thank you for your help!

You will not receive a reply. For enquiries, please contact us .

Sign up for a Plus account to get the most out of your job search and access all the tools available on Job Bank!

The median wage is the salary of a given occupation where half the workers earn more than that amount, and half earn less. This information is presented on job postings to help job seekers determine how the salary compares to the amount earned by other workers working the same job. Job Bank preferred indicating the median wage, which is less affected by extremely high or low wages, rather than the average wage which is calculated by adding up all the salaries of a group of people and then dividing that total by the number of people.