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 PostgreSQL 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.

Posted By