Data Modeler & Python
Job Summary
Company Profile:
At CGI were a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72000 professionals located in 40 countries. Founded in 1976 CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources expertise stability and dedicated professionals needed to achieve. At CGI were a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72000 professionals located in 40 countries. Founded in 1976 CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources expertise stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at .
This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position however only candidates selected for interviews will be contacted. No unsolicited agency referrals please.
Direct Responsibilities
. Data Design: Build and maintain conceptual (high level business concepts) logical (attributes and relationships) and physical (database specific schemas) models.
. Design and implement database schemas tables views indexes and other structures that align with application requirements.
. Design develop and maintain Python applications services and automation scripts that work alongside the PL/SQL layer (e.g. data processing batch jobs and API based integrations).
. Design develop and maintain complex PL/SQL packages procedures functions triggers and views to support data driven applications.
. Build and consume REST APIs (FastAPI / Flask) that expose CRM data and services to the 60 connected systems with proper validation error handling and versioning.
. Develop Oracle connected Python components using python oracledb / SQLAlchemy with connection pooling bulk operations (executemany) ref cursors and calls to PL/SQL packages.
. Build batch and data pipelines in Python (Pandas / Polars) for transformation reconciliation and data quality checks scheduled through Control M or Airflow (NTH).
. Apply secure coding practices in Python: secrets management OAuth2 / JWT based service authentication input validation and dependency vulnerability scanning.
. Implement structured logging error handling and monitoring for Python services and jobs to support production operations and L3 support.
. Write optimize and troubleshoot advanced SQL queries to ensure efficient data processing and retrieval.
. Performance Optimization: Tune database performance using indexing partitioning and efficient normalization or dimensional techniques
. Define and enforce data integrity and quality standards within the database design.
. Design implement and maintain ETL processes to integrate data from multiple sources using PL/SQL and Python to transform and validate data (NTH).
. Create Python based API led services under the strangler pattern in line with the target architecture.
. Ensure data consistency accuracy and completeness across different systems and processes.
. Support large scale data migrations and database transformations.
. Act as a technical point of contact for complex database issues offering solutions and recommendations to resolve them.
. Project Coordination and Stakeholder Collaboration
Collaborate with project managers business analysts and stakeholders to understand business requirements and translate them into technical solutions.
Communicate project status timelines and potential risks to stakeholders ensuring alignment with project goals.
. Quality Assurance and Testing
Develop and oversee testing strategies for PL/SQL and Python code (e.g. unit tests with utPLSQL and pytest) ensuring high quality performance and compliance with business requirements.
Collaborate with QA teams to validate data quality ensure accuracy and troubleshoot issues identified during testing.
Define and document acceptance criteria for database functions and processes.
. Documentation and Standards
Create and maintain comprehensive documentation for database designs PL/SQL and Python code and data flow processes.
Ensure adherence to data governance and regulatory requirements including security and compliance standards.
Maintain version control and change management processes to ensure data integrity and consistency.
Participate in code reviews and follow CI/CD practices to ensure high quality deliverables.
Contributing Responsibilities
. Good knowledge of logical and physical Data Modeling using normalizing techniques.
. Oracle PL/SQL programming experience SQL experience at least 5 years.
. Python programming experience (Pandas NumPy cxOracle / python oracledb or SQLAlchemy) at least 3 years.
. Write clean maintainable and well tested Python following PEP 8 type hints and code quality tooling (flake8 / pylint black SonarQube).
. Proficiency in business analysis tools (e.g. JIRA).
. Deliver simple & medium work on time with optimum utilization of time; implemented solution is performant robust efficient pragmatic (design & implementation).
. Experience in manipulating and analyzing data from varying sources.
. All new components and/or changes to existing components are well documented.
. Results oriented team player and self motivated with a strong initiative to deliver.
. Excellent communication and listening skills; attention to detail is a must.
Technical & Behavioral Competencies
. Data Modeler (at least 3 years) Strong command of SQL Relational Database Management Systems (RDBMS like Oracle MySQL SQL Server)
. Oracle PL/SQL (at least 5 years)
. Python (at least 3 years) with the following technical depth:
Core Python: OOP decorators generators context managers exception handling type hints virtual environments and dependency management (pip / poetry)
Concurrency and performance: asyncio multithreading / multiprocessing profiling and memory efficient processing of large datasets
Data libraries: Pandas NumPy Polars (NTH) PySpark (NTH)
Frameworks and APIs: FastAPI / Flask / Django REST Pydantic OpenAPI / Swagger SOAP / REST integration JSON / XML parsing
Database connectivity: python oracledb (cxOracle) SQLAlchemy connection pooling bulk DML transaction handling calling PL/SQL from Python
Messaging and integration: Kafka / IBM MQ / RabbitMQ client exposure (NTH)
Testing: pytest unittest mocking test data management coverage reporting
DevOps and tooling: Git Jenkins / Azure DevOps CI/CD Docker Linux shell scripting
Orchestration and observability: Airflow / Control M logging frameworks monitoring and alerting (NTH)
. Data Blending High volume and Multidimensional Data Processing
. Experience in manipulating and analyzing simple and medium high volume high dimensionality data from varying sources
. Query optimization and performance enhancements
. Team Player Self motivated and Quick Learner
. Good analytical skills and attention to detail
. Independent and strong sense of ownership
Experience Level: 7 years
Skills Referential (Required knowledge skills and abilities)
Transversal Skills:
o Active Listening
o Client Focused
o Ability to deliver / Result driven
Behavioral Skills:
o Analytical Thinking & Structured Problem Solving
o Ownership & Accountability under Governance Gates
o Stakeholder Management & Clear Communication
o Attention to Detail in Compliance Sensitive Work
- English
- DevOps
- GIT
- Oracle
- Python
- RESTful (Rest-APIs)
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.
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.
Come join our teamone of the largest IT and business consulting services firms in the world.
About Company
The COMPANY is one of the few end-to-end consulting firms with the scale, reach, capabilities and commitment to meet clients’ enterprise digital transformation needs. Our 77,500 consultants and professionals work side-by-side with clients in 10 industries across more than 400 location ... View more