Data Engineer

We are looking for Data Engineer for our client in Toronto, ON Job Title: Data Engineer Job Location: Toronto, ON Job Type: Contract Job Description: Responsibilities:

• Obtains tasks from the project lead or Team Lead (TL), prepares functional and design specifications, approves them with all stakeholders.
• Ensures that assigned area/areas are delivered within set deadlines and required quality objectives.
• Provides estimations, agrees task duration with the manager and contributes to the project plan of the assigned area.
• Analyzes scope of alternative solutions and makes decisions about area implementation based on candidate experience and technical expertise.
• Leads functional and architectural design of assigned areas.
• Makes sure design decisions on the project meet architectural and design requirements.
• Addresses area-level risks, provides and implements mitigation plan.
• Reports about area readiness/quality, and raises red flags in crisis situations which are beyond candidate AOR.
• Responsible for resolving crisis situations within candidate AOR.
• Initiates and conducts code reviews, creates code standards, conventions and guidelines.
• Suggests technical and functional improvements to add value to the product.
• Constantly improves candidate professional level.
• Collaborates with other teams.

Must Have:

• 5+ years of professional experience.
• University degree in Computer Related Sciences or similar.
• Advanced proficiency in Complex SQL.
• In-depth knowledge of Data Warehousing and Data Modeling techniques.
• Proficiency in Python programming languages.
• Proficiency in Airflow for efficient workflow automation.
• Experience with Spark/EC2/S3 will be helpful.
• Expertise in Analytics and Reporting.
• Familiarity with Snowflake/Data bricks.
• 3+ years of experience in ETL orchestration and workflow management tool Airflow.
• Expert in Database fundamentals, SQL and distributed computing.
• Experience in Spark, Snowflake & Data bricks.
• Excellent communication skills and experience working with technical and non-technical teams.
• Able to clear hacker rank code test.

Nice To Have:

• Experience in AWS (EC2/S2/IAM).
• 3+ years of experience with the Distributed data/similar ecosystem (Hive, Presto) and streaming technologies such as Kafka/Flink.
• Experience working with Redshift, PostgreSQL and/or other DBMS platforms.