Lead database design, data modeling, schema evolution, migrations, and ETL/ELT pipelines across MySQL, PostgreSQL, and Google Cloud databases. Build streaming and batch ingestion, enable CI/CD for data deployments, troubleshoot pipelines, produce runbooks, and mentor/lead offshore DB/ETL engineers while collaborating with onshore architects.
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
Compensation, Benefits and Duration
Minimum Compensation: USD 52,000
Maximum Compensation: USD 182,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is available for independent contractors
No applications will be considered if received more than 120 days after the date of this post
Photon San Francisco, California, USA Office
San Francisco, United States
Similar Jobs
Fintech
Senior Solutions Architect responsible for designing and implementing enterprise Azure hybrid cloud architectures (AKS, IaaC, networking, security, observability). Provide technical leadership, prototype cross-platform solutions, partner with product and engineering teams, ensure scalable, resilient, and secure deployments using Infrastructure-as-Code, CI/CD, and cloud best practices.
Top Skills:
App Service Environment (Ase)Application Security Group (Asg)Arm TemplatesAzure AdAzure Ad B2CAzure Api ManagementAzure App ServiceAzure Application InsightsAzure CliAzure Container Registry (Acr)Azure Container Service (Acs)Azure DevopsAzure Key VaultAzure Kubernetes Service (Aks)Azure Log AnalyticsAzure MonitorAzure Public CloudAzure Security CenterAzure SentinelAzure SqlAzure Virtual NetworkCi/CdCosmos DbDatadogDockerDomain Driven Design (Ddd)Event HubsExpressrouteHstsKubernetesMicroservicesAzureMicrosoft Cloud Adoption FrameworkNetwork Security Group (Nsg)Nginx Ingress ControllerOpenid ConnectPowershellService BusService MeshSite-To-Site VpnSsl/TlsSysdigTerraformTwistlockUser Defined Routes (Udr)
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
Lead full-cycle recruiting for Finance and core business roles, partner with hiring leaders and cross-functional teams, maintain TA systems, and build/test agentic AI bots and Skills using Claude Code/OpenAI Codex to automate recruiting workflows and improve process quality, governance, and candidate experience.
Top Skills:
Claude CodeGemGoogle WorkspaceLinkedin RecruitermacOSModernloopOpenai CodexSlackWorkday
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Lead SnackFutures Ventures investments in early and growth-stage companies, manage deal sourcing, screening, negotiation, and portfolio oversight, coordinate cross-functional teams, contribute to investment strategy, and support exits or handovers to Corporate Development.
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
