ODP Developer Data Engineer

Position Description:

As part of a major client program the **Operational Data Platform (ODP)* is entering a new phase focused on integrating additional data sources and expanding the organizations data analytics capabilities. To accelerate data integration efforts support ongoing development activities and ensure the successful delivery of project objectives through 2027 we are seeking an **ODP Developer**. The successful candidate will play a key role in the design development optimization and maintenance of data integration solutions while ensuring the performance reliability and availability of the ODP platform.

Key Responsibilities
Data Development & Integration
Analyze business and technical requirements related to new data integration initiatives.
Design develop and maintain data acquisition pipelines within the Operational Data Platform (ODP).
Configure and integrate new data sources into the platform.
Enhance and adapt existing data acquisition processes to meet evolving business requirements.
Design develop and maintain **SQL Server Integration Services (SSIS)* packages for data ingestion and transformation.
Contribute to the ongoing development and evolution of the enterprise data platform.

Performance Optimization
Optimize SQL scripts and data processing workflows to improve reporting and data integration performance.
Continuously improve the overall performance of the ODP platform.
Identify opportunities for optimization and implement development best practices.
Ensure data quality consistency and integrity across the platform.

Production Support & Maintenance
Provide advanced technical support for ODP data processing activities.
Diagnose and resolve production incidents affecting the ODP platform.
Investigate and remediate failed data feed jobs.
Monitor daily data ingestion processes.
Ensure the proper operation of ODP dashboards and platform components.
Participate in on call support and production support activities when required.

Automation & Continuous Improvement
Design and develop automation mechanisms for data processing workflows.
Contribute to the continuous improvement of data integration and operational processes.
Produce and maintain up to date technical documentation.
Participate in code reviews and promote development standards and best practices.

Collaboration
Collaborate closely with Application Infrastructure Business Intelligence (BI) and business teams.
Participate in technical analysis solution design and architecture workshops.
Support business users and project teams during the onboarding of new data sources.
Contribute to knowledge sharing within the Data Engineering team.

Responsibilities
The ODP Developer is accountable for:
Delivering high quality maintainable development work.
Ensuring the reliability and availability of data pipelines.
Optimizing SQL queries SSIS packages and overall platform performance.
Maintaining the stability and operational efficiency of the ODP platform.
Investigating and resolving data processing incidents.
Applying development standards BI best practices and data engineering principles.

Required Technical Skills
Microsoft SQL Server
Advanced T SQL
SQL Server Integration Services (SSIS)
ETL / ELT Development
Data Engineering
Data Modeling
SQL Performance Tuning
Production Support and Incident Management
Git or Azure DevOps

Preferred Skills
Azure Data Factory
Azure SQL Database
Power BI
Python
Data Warehouse concepts
CI/CD pipelines
Process Automation

Candidate Profile
Bachelors degree in Computer Science Data Engineering Information Systems or a related discipline.
Minimum **3 to 7 years* of experience in Business Intelligence or Data Engineering.
Strong hands on experience with Microsoft SQL Server technologies.
Proven experience in designing and implementing data integration solutions.
Good understanding of data warehouse and business intelligence architectures.
Strong analytical and problem solving skills with the ability to work independently.
Experience working in an international and multidisciplinary environment.
Professional proficiency in English (written and spoken).

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:

• English
• French
• Azure DevOps
• Data Modeling
• ETL
• Incident Management
• MS SSIS

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.

That same commitment to fairness extends to how we use technology. To support our recruitment team AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

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.