Position
Data Architect
Experience
10+ years
Location
Offshore (working closely with onshore architects)
Role Overview
We are looking for a Database Lead with strong GCP, database, and ETL experience to support a cloud-native data platform. The role involves database design, data modeling, schema evolution, data migrations, ETL pipelines, and data streaming across MySQL, PostgreSQL, and Google Cloud databases (Spanner, Cloud SQL, AlloyDB) .
Snowflake, DOMO - Analytics and Reporting is a must
The candidate will act as a technical lead , collaborating with onshore architects and leading offshore DB/ETL resources as additional team members are onboarded.
Key Responsibilities
- Lead data modeling, schema design, and database architecture across MySQL, PostgreSQL, Spanner, Cloud SQL, and AlloyDB .
- Own data migrations (one-time migrations, incremental/delta loads, and ongoing data synchronization).
- Design and manage config-driven ETL / ELT pipelines , with table-level configuration files and minimal transformations.
- Support on-demand onboarding of new tables and manage schema changes / evolution .
- Design and support data streams for batch and near-real-time ingestion.
- Work across teams on event-driven architectures , ensuring reliable data publishing and downstream consumption.
- Enable CI/CD deployments for database changes, ETL jobs, dataflows, and configurations.
- Monitor and troubleshoot ETL pipelines, data syncs, and streaming jobs ; support reprocessing and recovery.
- Prepare and maintain playbooks, runbooks, and operational documentation .
- Lead and mentor offshore DB/ETL engineers , review designs, guide implementation, and ensure delivery quality.
Mandatory Skills & Experience
- 5–8 years of experience in database and data engineering roles.
- Proven expertise in data modeling, schema design, and data migrations .
- Strong hands-on experience with MySQL and PostgreSQL .
- Experience with Google Cloud databases : Spanner, Cloud SQL, AlloyDB .
- Experience with ETL / ELT pipelines , data integration, and data streaming.
- Strong understanding of schema evolution, delta processing, and data synchronization .
- Advanced SQL skills.
- Experience working on GCP , including services like Pub/Sub, Dataflow, BigQuery, and Cloud Storage .
- Experience with CI/CD pipelines for data and database deployments.
- Ability to technically lead offshore teams and work with onshore stakeholders.
Nice to Have
- Exposure to other databases / technologies such as AS/400, MongoDB, Cassandra , and GraphQL .
- Experience in enterprise data modernization or legacy-to-cloud programs .
- Professional Cloud Certifications (Google / Microsoft / AWS), including:
- Google Professional Data Engineer
- Google Cloud Architect
- Google Cloud Engineer
