Data Engineer

Job Offer: Data Engineer

Location: Toronto

Contract Duration: 6 months

Work Mode: Hybrid

Start Date: March 10th

Why Join Us?

Astek is a global leader in technology consulting. With 9,600 experts
worldwide, we guide our clients through digital transformation by
developing innovative solutions.

In Canada, we excel in IT and engineering. We collaborate with
leading companies to tackle major technological challenges, putting
innovation, collaboration, and excellence at the heart of our actions.

Join a passionate and committed team ready to bring your ideas to
life.

About the Role

On behalf of our client in the Banking industry, Astek Canada is
seeking a motivated Data Engineer ready to take on new challenges.

Your Responsibilities

As a Data Engineer, you will be responsible for:

Develop automated data pipelines and data stores from multiple systems
including designing, implementing, testing, debugging, and deploying.
Develop complex SQL queries, stored procedures, and scripts for data
manipulation and retrieval.
Build metadata-driven solutions that are reusable and highly
configurable.
Optimize data warehouse performance through effective data modeling,
partitioning, and indexing strategies.
Spearhead the design and implementation of ETL processes.
Collaborate with various system owner to understand data requirements
and deliver precise reporting and analytical solutions.
Ensure data integrity and security within the data environment,
complying with industry regulations and standards.
Work on an agile team to quickly iterate and release solutions.
Provide technical expertise and support for warehouse to internal
teams, including troubleshooting and resolving issues.
Stay up to date with data features and updates, continuously improving
and expanding our data warehouse capabilities.
Develop and maintain documentation for processes, systems, and
procedures.
Implement data governance and data quality frameworks to ensure the
accuracy and reliability of data within the environment.
Integrate warehouse with other data sources and platforms, including
both cloud-based and on-premises systems.

Your Qualifications

Education/Experience:

Bachelor's degree in technology and information systems.
8+ years of experience in database administration, automation
implementation, administration, configuration and support.

Key Skills:

In-depth proven experience with complex SQL data manipulation.
Java experience.
Working knowledge of data warehouse.
XML, XLSX, JSON, CSV and other data source experience.
Nice to have : Powershell experience, Sailpoint experience with bean
shell knowledge.

Personal Qualities:

Analytical and solution-oriented mindset.
Team collaboration and teamwork skills.
Autonomy and rigor in managing priorities.