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 organization's 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
Bachelor's 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).
Your future duties and responsibilities
Required qualifications to be successful in this role
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll 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. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll 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.
You’ll shape your career by joining a company built to grow and last. You’ll 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 team—one of the largest IT and business consulting services firms in the world.
