SIDRAM TECHNOLOGIES · 1 day ago
Data Architect
Chicago, IL
Full-time
Onsite
Senior Level
5+ years expSidram Technologies is seeking a Data Architect to support a cloud-native data platform. The role involves database design, data modeling, schema evolution, and managing ETL pipelines while collaborating with onshore and offshore teams.
Computer Software
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
Snowflake, DOMO - Analytics and Reporting is a must
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
SIDRAM TECHNOLOGIES
SidRam Technologies is a smart technical solution provider and services company that changes the way world see Energy saving.
51-200 employees
H1B Sponsorship
SIDRAM TECHNOLOGIES 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
2025 (4)
2024 (35)
Funding
Current Stage
Growth StageCompany data provided by crunchbase