Prospect Infosystem Inc. · 1 day ago
Senior Data Architect
Dallas, TX
Contract
Onsite
Senior Level
5+ years expProspect Infosystem Inc. is seeking a Senior Data Architect to support a cloud-native data platform. The role involves leading database design, data modeling, schema evolution, data migrations, and ETL pipelines, while collaborating with both onshore and offshore teams.
Information Technology
Hiring Manager
Hari Prasad B.
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
Qualification
Required
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
Preferred
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
Company
Prospect Infosystem Inc.
IT takes talent and Prospect Infosystem, Inc. delivers.
51-200 employees
H1B Sponsorship
Prospect Infosystem Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
2022 (4)
2021 (11)
2020 (34)
Funding
Current Stage
Growth StageCompany data provided by crunchbase