Data Engineering Consultant - Halifax Regional Municipality, Canada - CGI

Description

Position Description:

As a Data Engineer, you will be responsible for designing, building, and maintaining data pipelines, databases, and analytics solutions.
Your expertise in data engineering tools and platforms will drive the efficient processing, storage, and retrieval of data.
You'll collaborate with data scientists, analysts, and other stakeholders to ensure data availability, quality, and reliability.

Your future duties and responsibilities:

Responsibilities:

Data Pipeline Development:

•Design, implement, and optimize data pipelines for ingesting, transforming, and loading data from various sources.

•Use ETL (Extract, Transform, Load) processes to move and transform data efficiently.

•Ensure data consistency, accuracy, and timeliness.
Database Management:

•Work with relational databases (such as PostgreSQL, MySQL, or Oracle) and NoSQL databases (like MongoDB or Cassandra).

•Design schema, create tables, and manage data storage.

•Optimize database performance and query execution.

Tech Stack:

•Programming Languages: Proficiency in Python, Java, or Scala for data processing and scripting.

•Big Data Technologies: Familiarity with Apache Hadoop, Spark, and Kafka.

•Data Warehousing: Experience with data warehousing solutions (e.g., Amazon Redshift, Google BigQuery, Snowflake).

•Cloud Platforms:
-Google Cloud Platform (GCP):
-Designing and deploying scalable, highly available, and fault-tolerant systems on GCP.
-Managing and provisioning GCP infrastructure using Infrastructure as Code tools (e.g., Terraform, Google Cloud Deployment Manager).
-Automating GCP operations using scripting languages (Python, Bash) and GCP SDKs or APIs
Collaboration:

•Work closely with data scientists and analysts to understand their data requirements.

•Collaborate with cross-functional teams to ensure seamless integration of data solutions.

•Participate in architectural discussions and provide technical guidance.

Required qualifications to be successful in this role:

Qualifications:
Education: Bachelor's or Master's degree in Computer Science, Information Technology, or related fields.

Experience:

•Minimum 3-5 years of experience in data engineering.

•Proficiency in SQL and database design.

•Familiarity with data modeling and schema design.
Desired Skills:

•Data Security: Understanding of data security best practices.

•Monitoring and Troubleshooting: Ability to monitor and troubleshoot data pipelines using tools like GCP Stackdriver and Cloud Monitoring.

•Automation: Experience automating data processing tasks using scripting languages (Python, Bash).

#LI-MT1

Skills: