Data Engineer

Role:
Data Engineer

Location:

Toronto, ON Canada

Employment Type:

Contract

Responsibilities and Duties:

Extensive experience with MySQL to support platform growth and scalability.

Expertise in both tactical and strategic schema design enhancements, ensuring optimal data ingestion and extraction for our warehouse database to support BI, external reporting, and operations teams.

Collaborate with development teams to fine-tune schemas and queries for new features prior to production release.

Skilled in ETL processes and Data Lake management.

Familiarity with MySQL to Postgre

SQL migrations is a strong asset.

Experience with  snowflake .

Experience with Python or Go is desirable, to assist with current ETL ingestion scripts.

Proactively seek opportunities to enhance platform and data resilience.

Diagnose and resolve system issues, determine root causes, and manage recovery processes to ensure rapid restoration of services with no data loss.

Maintain precise attention to detail in all tasks.

Qualifications and Skills:

Degree or diploma in Computer Science, Software Engineering, or a related field.

At least 3 years of relevant professional experience.

Background in one or more of the following:
Database administration, Data Engineering, ETL loading and ingestion, data classification and normalization, SQL and schema optimization.

Skills in Linux system administration, web server management, and networking are beneficial.

Experience with Kubernetes is an advantage.

Knowledge of database security best practices, including collaboration across teams to ensure safe and zero-trust access.

Proficiency with AWS services such as Lambda, Redshift, DMS.

Experience with Apache tools like Airflow, Superset, Kafka.

#J-18808-Ljbffr