What are the responsibilities and job description for the Google Cloud Platform Data Architect position at Prospect Infosystem Inc?
Job Details
Google Cloud Platform Data Architect Position --Onsite
Title:Google Cloud Platform Data Architect
Location: Springfield, MO / Dallas, TX / Chicago, IL
Job Description:
We are looking for a Data Architect with strong Google Cloud Platform, 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).
The candidate will act as a Data Architect 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 Google Cloud Platform, 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
linkedin.com/in/narra-venkat-69967b250
Title:Google Cloud Platform Data Architect
Location: Springfield, MO / Dallas, TX / Chicago, IL
Job Description:
We are looking for a Data Architect with strong Google Cloud Platform, 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).
The candidate will act as a Data Architect 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 Google Cloud Platform, 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
linkedin.com/in/narra-venkat-69967b250
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.