Photon Logo

Photon

Data Architect _US

Posted 2 Days Ago
Be an Early Applicant
In-Office or Remote
Hiring Remotely in United States
52K-182K Annually
Expert/Leader
In-Office or Remote
Hiring Remotely in United States
52K-182K Annually
Expert/Leader
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.
The summary above was generated by AI

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

Similar Jobs

An Hour Ago
Remote or Hybrid
143K-235K Annually
Senior level
143K-235K Annually
Senior level
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.
2 Hours Ago
Remote or Hybrid
CA, USA
37K-73K Hourly
Mid level
37K-73K Hourly
Mid level
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Provide white-glove technical support and onboarding for high-value resellers: troubleshoot integrations, manage escalations, run onboarding and training, track and drive issue resolution with engineering, and collaborate cross-functionally to improve processes and product experience for enterprise sellers.
Top Skills: APIsGoogle MeetsJIRASdksThird-Party Integrations
6 Hours Ago
Remote or Hybrid
176K-308K Annually
Senior level
176K-308K Annually
Senior level
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead AI FinOps governance to track and optimize AI spend across multi-cloud providers. Build KPI frameworks, anomaly detection, guardrails, and cost-reduction programs. Coordinate engineering, finance, and cloud vendors, deliver VP-level reporting, and operate as an independent program owner driving measurable savings and contractual correctness.
Top Skills: AnthropicAWSAws BedrockAws BudgetsAzureAzure Cost ManagementAzure OpenaiBilling ApisGCPGcp Billing ControlsGcp Vertex AiGenai GatewayLlm Proxy PlatformsOpenaiPythonSQLToken Metering

What you need to know about the Austin Tech Scene

Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.

Key Facts About Austin Tech

  • Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
  • Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
  • Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
  • Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account