StartupSoft

ABOUT CLIENT

A dynamic wellness tech venture offering innovative tools to support proactive health management. Its primary product is a smart scale equipped with cutting-edge BIA technology, delivering precise data on key body metrics such as fat percentage, lean mass, and hydration. By merging advanced engineering with a seamless digital experience, it empowers users to make informed decisions about their health.
 

PROJECT TECH STACK

BigQuery SQL, GCP, TypeScript, Cloud Run.
 

PROJECT STAGE

Live product.
 

REQUIREMENTS:

• Strong BigQuery SQL and dimensional data modeling
• Experience building streaming or near-real-time ingestion pipelines on GCP (Pub/Sub, Cloud Run, Dataflow)
• Familiarity with Dataform, dbt, or equivalent
• Working knowledge of Tableau (data sources, extracts, calculations)
• Comfort with semi-structured/JSON data and schemaless document databases
• English level: B2 or higher
   

NICE TO HAVE:

• Experience with Firestore BigQuery extension or similar CDC patterns
• Data observability tooling
• SCD Type 2 / point-in-time historical modeling
• Terraform or IaC for GCP resources
   

RESPONSIBILITIES:

• Build streaming ingestion from Pub/Sub into BigQuery bronze layer using the Storage Write API
• Design silver-layer entity models: flatten nested Firestore documents into typed, deduplicated tables
• Build gold-layer star schema tables optimized for Tableau
• Develop and schedule incremental transforms (Dataform or dbt)
• Create and maintain Tableau data sources, extracts, and calculated fields
• Monitor pipeline health: ingestion lag, data quality, schema drift
• Document data models for stakeholder self-service
   

YOU WILL GET:

• Competitive financial reward and other social benefits;
• Possibility to work with minor supervision and low-bureaucracy;
• Flexible schedule and friendly working atmosphere;
• Tight-knit team with an inclusive and transparent culture.