Data Engineer

Hi Greeting you from Capco At Capco, our Values guide how we work, how we lead, and how we make decisions every day. They define what we stand for as a company and set the standards we hold ourselves to — with our clients, our colleagues, and our communities. Our Values are the foundation of who we are. They reflect our people-first culture and remind us that our success is built on integrity, collaboration, and purpose. Role

Key Responsibilities ✅ Data Engineering & Development

• Design, develop, and maintain

scalable ETL/ELT pipelines

• Write

complex SQL queries, stored procedures, functions, and triggers

• Optimize database performance through indexing, query tuning, and partitioning
• Work with

structured and semi-structured data ✅ Data Warehousing & Modeling

• Build and maintain

data warehouse/data mart structures

• Implement

data models (star schema, snowflake schema)

• Ensure data quality, integrity, and consistency

✅ Cloud & GCP (Nice-to-Have / Preferred)

• Work with GCP services such as:
• BigQuery (data warehouse)
• Cloud Storage
• Dataflow / Dataproc
• Pub/Sub
• Migrate on-premise data pipelines to cloud (if applicable)

✅ Data Pipeline & Integration

• Integrate data from multiple sources (APIs, databases, flat files)
• Build batch and (preferably)

near real-time pipelines

• Work with ETL tools or build custom pipelines

✅ Collaboration & Delivery

• Collaborate with

Data Analysts, Data Scientists, and Product teams

• Translate business requirements into scalable data solutions
• Participate in code reviews and maintain documentation

🔹 Required Skills (Primary) 🟢 Core SQL / PL-SQL Expertise

• Strong hands-on experience in:
• Advanced SQL (joins, window functions, CTEs, aggregations)
• PL/SQL programming (procedures, packages, cursors)
• Experience with databases like:
• Oracle / SQL Server / PostgreSQL / MySQL

🟢 Data Engineering Fundamentals

• Strong understanding of:
• ETL/ELT frameworks
• Data warehousing concepts
• Data modeling techniques
• Experience handling large datasets

🔹 Preferred / Secondary Skills 🔵 GCP Ecosystem

• Experience with:
• BigQuery
• Cloud Composer (Airflow)
• Dataflow / Apache Beam
• Understanding of distributed processing

🔵 Additional Skills

• Programming:

Python / Shell scripting

• Tools: Airflow, Informatica, Talend, dbt
• Knowledge of

CI/CD pipelines

• Exposure to

Apache Spark / Hadoop ecosystem

🔹 Experience Required

• 3–8 years (customize based on role level)
• Relevant experience in

data engineering / database development