Data Engineering Consultant

Position Description:

We are seeking an experienced Data Engineering consultant to support enterprise data initiatives with a strong focus on data migration pipeline development and data platform optimization. This role plays a critical part in ensuring the accuracy integrity and accessibility of data across systems. The ideal candidate will combine strong technical expertise with the ability to collaborate across functional teams to deliver scalable reliable data solutions that support business operations and decision-making.
Key Responsibilities:
The successful candidates responsibilities will include:

. Lead and support data migration activities including extraction cleansing mapping transformation validation and reconciliation.
. Collaborate with functional teams to align migration logic with business and system requirements.
. Develop and optimize SQL PL/SQL and T-SQL code to support enterprise data workflows across Oracle and SQL Server.
. Build data pipelines monitor them and troubleshoot operational or data issues.
. Review existing operations data research open issues and collaborate with engineering and operations teams on new and ongoing projects.
. Design tools and infrastructure to analyze large volumes of data.
. Assist the team with troubleshooting root cause analysis and thorough defect resolution.
. Ensure the accuracy integrity and security of data within the organization.

Qualifications:
The ideal candidate for this position will have:

. Degree or Diploma in Computer Science Information Systems or related field.
. 5 years of experience as a Data Engineer or similar role.
. Proficiency in Python PySpark data modeling ETL/ELT processes and data integration using Microsoft technologies.
. Strong SQL experience with Oracle and SQL Server including query tuning and analysis.
. Advanced SQL skills for data transformation and querying on Azure data services (e.g. Data Factory Databricks Synapse Fabric Purview).
. Experience with Power BI or other BI tools.
. Familiarity with DevOps practices including CI/CD.
. Strong understanding of data pipeline engineering and big data design principles.
. Experience with database data warehouse or data lake solutions.
. Exceptional communication skills with the ability to translate technical concepts for diverse stakeholders.

Use of the term engineering in this job posting refers to the technical sense related to Information Technology (IT) and does not imply that the individual practices engineering or possesses the requisite license as prescribed by the applicable provincial or territorial engineering regulator. We are seeking individuals with expertise in IT engineering-related functions but licensure from an engineering regulator is not a prerequisite for this position. Engineering is a regulated profession in Canada which is restricted in terms of use of titles and designation.

Skills:

• Azure Data Lake
• Azure Service Fabric
• Data Warehousing
• ETL
• Python
• SQL
• Transact-SQL

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer being able to perform your best during the recruitment process is important to us. If you require an accommodation please inform your recruiter.

To learn more about accessibility at CGI contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our teamone of the largest IT and business consulting services firms in the world.