Data Modeler
Job Description
Implement data products based on business and technical requirements.
Design, develop, and maintain data ingestion, transformation, and integration pipelines.
Create source-to-target mappings and implement logical and physical data models.
Develop and optimize SQL transformations, reconciliations, and data validation processes.
Build automation frameworks, utilities, and integrations using Python.
Integrate enterprise and operational systems through APIs and ETL/ELT frameworks.
Work closely with architects, business analysts, and stakeholders to deliver scalable data solutions.
Contribute to DataOps, CI/CD, DevOps, and operational monitoring practices.
Mandatory Skills
Experience in Data Engineering, ETL Development, Data Integration, or Analytics Engineering.
Strong Python programming skills.
Experience in developing ETL/ELT pipelines and integration frameworks.
Good understanding of Data Modeling concepts and Source-to-Target Mapping.
Experience with Git and version control practices.
Understanding of CI/CD pipelines and deployment processes.
Preferred Skills
Hands-on experience with: Azure Data Factory (ADF),Azure Synapse,Databricks,Apache Spark
Experience with DataOps, DevOps, and Infrastructure as Code (IaC).
Understanding of Oil & Gas Exploration & Production business processes.
Exposure to cloud-native data architectures and scalable data platforms.
Ideal Candidate Profile
Data Engineering, Data Integration, or Data Platform development.
Strong expertise in SQL and Python development.
Experience building enterprise-scale data pipelines and data products.
Strong understanding of dimensional modeling, metadata management, and data governance.
Ability to work in fast-paced Agile delivery teams.
What You'll Love About Working Here
Opportunity to work on large-scale Energy & Utilities transformation programs.
Exposure to modern cloud, data, and AI technologies.
Flexible work environment and collaborative culture.
About Capgemini
At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world's most innovative companies unleash their potential. We combine deep industry expertise with cutting-edge technologies across cloud, data, AI, and digital engineering to deliver sustainable business outcomes.