European Union•Ukraine
Remote
Mid Level
Full Time
remotedata analyticsdbtSQLcloud data warehouseBigQueryClickHouse
Requirements
- •Strong SQL experience with a deep understanding of analytical modeling concepts
- •Hands-on experience with dbt (models, tests, docs, macros)
- •Experience working with cloud data warehouses such as BigQuery or ClickHouse
- •Understanding of data modeling patterns
- •Familiarity with data engineering concepts (ELT/ETL, orchestration, version control, CI/CD)
- •Experience with data quality frameworks or implementing validation logic
- •Ability to translate complex business processes into clean analytical datasets
- •Strong documentation skills and attention to detail
- •Experience collaborating with cross-functional teams and supporting analysts with reliable data
What You'll Do
- •Design, build, and maintain dbt models based on business needs
- •Develop scalable SQL transformations and ensure efficient, cost-effective query performance
- •Implement data quality tests and maintain high data reliability
- •Create and maintain documentation for datasets, data lineage, business logic, and transformation rules
- •Collaborate with Data Engineers on improving raw data structures, ingestion patterns, and source readiness
- •Partner with Data Analysts, Product Managers, and Marketing teams to translate business requirements into clean, reusable data models
- •Monitor data pipelines and marts, resolve issues, and prevent inconsistencies in reporting
- •Support governance initiatives including naming conventions, taxonomy, schemas, metric definitions, and standardization
- •Contribute to continuous improvement of data modeling frameworks, performance tuning, and technical decision-making
Nice to Have
- •Knowledge of Python
- •Experience with orchestration tools (Airflow, Dagster)
- •Experience working with marketing, product, or billing datasets
- •Exposure to metric layers, semantic layer design, or BI governance
- •Basic understanding of observability tooling (Grafana, Prometheus)
- •Experience optimizing BigQuery costs or ClickHouse performance
Benefits
- •Remote Work Environment
- •Unlimited PTO
- •Paid National Holidays
- •Company-provided MacBook
- •Flexible Independent Contractor Agreement
