About Cittabase

Company overview
Our Approach
Our Values and Core Principles
Careers
Events

Department: Data Analytics

Project Location(s): Chennai, TN, India

Education: Professional Degree

Job Description

We are looking for a Data Engineer with strong expertise in SQL, advanced data warehousing concepts, and programming skills in Python or Java. The role requires hands-on experience with GCP BigQuery, Dataflow, Cloud Composer, and robust exposure to Dataplex for governance and data management. All transformations are built using dbt, so familiarity with dbt development and best practices is essential. Experience with Snowflake or Databricks is a plus. Understanding of Workday data structures and HR analytics is good to have.

Responsibilities

Build scalable data pipelines using BigQuery, Dataflow, and Cloud Composer.
Develop ELT transformations and data models using dbt following modular, testable, and governed practices.
Apply advanced data warehousing techniques, performance optimization, partitioning, clustering, and data modeling patterns.
Implement data governance,



quality rules, lineage, and metadata workflows through Dataplex.
Develop production-ready code in Python/Java for orchestration, automation, and data processing.
Collaborate with analytics, product, and business teams (including HR/Workday domains) to define data requirements.
Ensure secure, reliable, and cost-optimized data pipelines aligned to best practices.
Support CI/CD, monitoring, troubleshooting, and continuous improvement of pipelines and dbt models.

Experience: 4-8 Years

Location: Chennai

Employment Type: Full-time

Qualifications

4–8 years of experience in data engineering, data warehousing, or analytics engineering roles.
Strong expertise in SQL and advanced data warehousing topics (modelling, performance tuning, optimization).
Hands-on experience with GCP BigQuery, Dataflow, Cloud Composer, and Dataplex.
Practical experience developing transformations and models in dbt.
Profi

📌 Data Engineer (Chennai)
🏢 Cittabase Solutions
📍 Chennai