Senior Data Extraction Engineer

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Your Role

As a Senior Data Engineer - Google Cloud Platform at Capgemini, you will play a key role in building and evolving enterprise-scale data platforms that power analytics, reporting, AI, and business-critical data products. You will combine strategic architecture thinking with hands-on engineering expertise to design, build, deploy, and support production-grade data solutions on Google Cloud Platform (GCP).

You will own data pipelines end-to-end, from initial architecture and design through implementation, deployment, monitoring, and operational support. Working closely with Product Owners, Data Architects, Business Stakeholders, and Engineering teams, you will help establish scalable data foundations that enable trusted and accessible enterprise data.

This role requires a builder mentality, strong cloud expertise, and a passion for transforming both structured and unstructured data into valuable business assets.

Responsibilities & Scope

Cloud Data Architecture & Platform Design

• Design end-to-end data platform architectures supporting data ingestion, transformation, storage, and consumption.
• Define scalable, maintainable, and cost-effective cloud data solutions leveraging Google Cloud Platform services.
• Establish reusable architecture patterns, standards, and best practices across the data ecosystem.
• Evaluate and select appropriate technologies and architectural approaches for:
• Batch Processing
• Stream Processing
• Event-Driven Architectures
• Structured Data Workloads
• Unstructured Data Workloads
• Translate business and operational requirements into scalable technical solutions.

Data Pipeline Engineering

• Design, develop, deploy, and support enterprise-grade data pipelines.
• Build ingestion frameworks for enterprise source systems including:
• Oracle
• CRM Platforms
• Internal Business Applications
• Engineering Systems
• Develop ELT and ETL processes that support enterprise analytics and operational data requirements.
• Implement data quality validation, reconciliation, and monitoring capabilities.
• Support production operations and continuously optimize pipeline performance.

Google Cloud Platform Engineering

• Design and implement solutions using:
• BigQuery
• Cloud Storage (GCS)
• Dataflow
• Apache Beam
• Pub/Sub
• Cloud Composer (Airflow)
• Cloud Functions
• Cloud Run
• Vertex AI
• Manage data storage architecture, lifecycle policies, security controls, and cloud resource optimization.
• Implement Infrastructure-as-Code (IaC) and deployment automation practices.
• Contribute to cloud governance, reliability, scalability, and operational excellence.

AI & Unstructured Data Processing

• Develop processing pipelines for unstructured and multimodal data including:
• PDF Documents
• Excel Files
• PowerPoint Presentations
• Audio Recordings
• Videos
• Engineering Drawings
• Enterprise Documentation
• Leverage Google AI services such as:
• Document AI
• Vision AI
• Speech-to-Text
• Video Intelligence API
• Vertex AI
• Build intelligent data extraction workflows that convert unstructured content into trusted structured datasets.
• Support AI and GenAI initiatives through scalable data preparation and orchestration frameworks.

LLM & Data Product Enablement

• Implement Large Language Model (LLM)-based solutions to:
• Classify content
• Extract information
• Summarize documents
• Generate structured output
• Build reusable data products that support AI, analytics, and reporting use cases.
• Develop semantic and business-aligned data models that improve accessibility and usability across business domains.

Data Modeling & Common Information Models

• Design and maintain Common Information Models (CIM) that align technical data structures with business concepts.
• Support enterprise semantic layers that enable consistent interpretation of data across multiple business functions.
• Implement:
• Dimensional Models
• Medallion Architecture (Bronze, Silver, Gold)
• Data Products
• Business Semantic Layers
• Support downstream BI, analytics, AI, and operational reporting solutions.

Security, Governance & Reliability

• Implement enterprise security best practices across cloud environments.
• Configure and maintain:
• IAM Policies
• Service Accounts
• Role Management
• Workload Identity
• Access Controls
• Establish observability frameworks including:
• Logging
• Monitoring
• Alerting
• SLA Tracking
• Data Quality Monitoring
• Ensure compliance with governance, security, and operational standards.

Technical Leadership & Collaboration

• Provide technical leadership and mentorship to engineering teams.
• Create technical designs, architecture documentation, and implementation standards.
• Collaborate with Product Managers, Business Stakeholders, Architects, and Data Consumers.
• Participate in architecture reviews, design workshops, and strategic data initiatives.
• Promote engineering excellence and continuous improvement within the Data Engineering organization.

Your Profile

• Architect and builder mindset - Equally comfortable defining architectures and writing production code.
• Cloud-native engineer - Passionate about building scalable and resilient platforms on Google Cloud.
• Problem solver - Skilled at designing solutions for complex enterprise data challenges.
• Innovation-driven professional - Interested in AI, GenAI, analytics, and modern data architectures.
• Collaborative leader - Enjoys partnering with business and technical teams to deliver impactful solutions.
• Continuous learner - Keeps current with evolving cloud, AI, and data engineering technologies.

Qualifications & Preferred Skills

Required Skills

Google Cloud Platform

Strong hands-on experience with:

• BigQuery
• Google Cloud Storage (GCS)
• Dataflow
• Apache Beam
• Cloud Composer (Airflow)
• Pub/Sub
• Cloud Run
• Cloud Functions
• Vertex AI
• Cloud IAM

Data Engineering

• Advanced Python development skills.
• Strong SQL expertise, including BigQuery SQL.
• Experience building production-grade ETL/ELT pipelines.
• Data modeling and dimensional modeling expertise.
• Experience with dbt and data transformation frameworks.
• Strong understanding of data quality, reliability, and observability practices.

AI & Unstructured Data Processing

Experience working with:

• Google Document AI
• OCR technologies
• Vision AI
• Speech-to-Text
• Video Intelligence API
• LLM-based data extraction
• Unstructured document processing

Cloud Security & Governance

• IAM architecture and administration.
• Service accounts and workload identities.
• Least-privilege security design.
• Storage security and data governance.
• Audit logging and compliance practices.

DevOps & Automation

• Terraform and Infrastructure-as-Code.
• Git-based development workflows.
• CI/CD pipelines.
• Automated testing and deployment practices.

Preferred Skills

• Experience implementing Common Information Models (CIM).
• Knowledge of IEC 61968 / IEC 61970 standards.
• Experience within Energy, Utilities, Infrastructure, or Engineering domains.
• Experience designing Data Products and Data Mesh architectures.
• Exposure to Generative AI, RAG architectures, and Agentic AI solutions.
• Experience supporting enterprise modernization and cloud transformation programs.

What You'll Love

• Opportunity to build enterprise-scale cloud data platforms from the ground up.
• Exposure to cutting-edge technologies across GCP, AI, GenAI, and advanced analytics.
• Collaboration with global teams specializing in Data Engineering, AI, Cloud, and Digital Transformation.
• Access to certifications, advanced technical training, and continuous learning opportunities.
• Career growth opportunities within Capgemini's global Data & AI practice.
• Innovative and collaborative work environment focused on engineering excellence.

Need to Know

Career Development in Spanish & English: Access to cloud certifications, technical academies, mentorship programs, and learning paths focused on Google Cloud, Data Engineering, Analytics, and Artificial Intelligence.

Community Engagement: Participate in innovation programs, technical communities, hackathons, knowledge-sharing initiatives, and networking opportunities across Capgemini.

About Capgemini

Capgemini is a global business and technology transformation partner, helping organizations accelerate their dual transition to a digital and sustainable world while creating tangible impact for enterprises and society. It is a responsible and diverse organization with more than 340,000 team members in over 50 countries.

With a strong heritage of more than 55 years, Capgemini helps clients unlock the value of technology through end-to-end services and solutions, leveraging capabilities in strategy and design, engineering, AI, generative AI, cloud, and data, combined with deep industry expertise and a strong partner ecosystem.

At Capgemini Mexico, we are committed to fostering a diverse and inclusive workplace where everyone has equal opportunities. We welcome applications from all qualified candidates and evaluate them based on merit, skills, qualifications, and experience relevant to the role.