Back to jobs

Data Modeler & Python

Pay
Pay not listed
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: FULL_TIME
From the employer’s posting

What you’ll work on

Full posting
  • Build and maintain conceptual, logical and physical data models and database schemas

  • Build and consume REST APIs (FastAPI / Flask) that expose CRM data to 60+ systems

  • Develop and maintain complex PL/SQL packages, procedures, functions, triggers and views

  • Build Python batch and data pipelines for transformation, reconciliation and data quality checks

  • Write, optimize and troubleshoot advanced SQL queries and tune database performance

From the employer’s posting
Build and maintain conceptual (high level business concepts), logical (attributes and relationships), and physical (database specific schemas) models.
Build and consume REST APIs (FastAPI / Flask) that expose CRM data and services to the 60+ connected systems
Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers, and views to support data driven applications.
Build batch and data pipelines in Python (Pandas / Polars) for transformation, reconciliation, and data quality checks
Write, optimize, and troubleshoot advanced SQL queries to ensure efficient data processing and retrieval.
Apply at CGI

Posting record

Report an error

Actively hiringFirst seen by us 5 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 16, 20265 days ago
Recorded sightings
5
Last seen by us
Nov 20, 2026
Employer says posted
Nov 11, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 5

Early. Similar jobs usually come down between day 7 and day 51.

From 1,783 similar postings that came down. Coming down is not always a hire.

CGI is hiring

163 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • PL/SQL
  • Python
  • Shell
  • SQL
  • Azure
  • Docker
  • Kafka
  • MySQL
  • Oracle
  • SQL Server
  • Airflow
  • Django
  • FastAPI
  • Flask
  • NumPy
  • pandas
  • Polars
  • PySpark
  • SQLAlchemy
Where the posting names them
. 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.
. 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.
. 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).
. 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.
. 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.
. 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.
. 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, cx_Oracle / python oracledb or SQLAlchemy) – at least 3 years.
. 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:
Frameworks and APIs: FastAPI / Flask / Django REST, Pydantic, OpenAPI / Swagger, SOAP / REST integration, JSON / XML parsing Database connectivity: python oracledb (cx_Oracle), SQLAlchemy, connection pooling, bulk DML, transaction handling, calling PL/SQL from Python Messaging and integration: Kafka / IBM MQ / RabbitMQ client exposure (NTH)
. 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.
. 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.
. 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.
. 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.
. Oracle PL/SQL programming experience, SQL experience – at least 5 years. . Python programming experience (Pandas, NumPy, cx_Oracle / 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).
. Python programming experience (Pandas, NumPy, cx_Oracle / 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).
. 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)
. 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
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)
. 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
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)
Database connectivity: python oracledb (cx_Oracle), 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
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 (cx_Oracle), SQLAlchemy, connection pooling, bulk DML, transaction handling, calling PL/SQL from Python
. 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.
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

Your next step

Complete your application on cgi.njoyn.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

Company Profile:

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 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, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 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 www.cgi.com.

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, cx_Oracle / 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 (cx_Oracle), 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

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 21% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 81, the most 168, and the latest week had 91.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Mumbai, MH, IN

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.