Responsibilities:
- Architect, optimize, and maintain scalable dbt models (Sources, Staging, Marts) that cleanly map raw source data to final analytical layers.
- Profile and optimize slow-running dbt models by tuning materialization strategies (Incremental models, Ephemeral layers, Cluster keys, and Partitioning).
- Establish strict data quality testing frameworks within dbt to catch data anomalies, schema drifts, and edge cases before they reach downstream business applications.
- Maintain high-quality dbt documentation and comprehensive lineage graphs, making data structures discoverable and clear for downstream business analysts.
- Run peer code reviews, establishing structural conventions for model naming, project organization, and compute cost control across the data team.
Requirements:
- 3+ years of deep, hands-on production experience architecting complex dbt Core or dbt Cloud projects.
- Master-level proficiency in writing highly complex, optimized, and readable SQL.
- Deep understanding of dimensional modeling (Kimball methodology), Data Vault 2.0, or wide-table strategies for analytics.
- Proven track record in configuring and managing large datasets within modern platforms like Snowflake, Google BigQuery, or Databricks.
- Strong version control experience using Git and setting up automated CI/CD workflows (e.g., Slim CI via GitHub Actions or GitLab CI) to test data changes before production deployment.
- Experience extending dbt functionality using Jinja templating, writing custom macros, and implementing standard packages (such as dbt_utils, dbt_expectations, or codegen).
- Proficiency in Python for writing advanced dbt extensions, orchestrating custom scripts, or building data extraction workflows.
Nice-to-Have:
- Official dbt Certified Developer credential.
- Experience with data orchestrators like Apache Airflow, Prefect, or Dagster.
- Knowledge of data quality and observability platforms (e.g., Monte Carlo, Great Expectations, or Elementary).
- Experience managing dbt Semantic Layer or building metrics definitions for self-service BI environments (like Looker, Tableau, or Lightdash).
Benefits:
- Get paid, not played.
- No more unreliable clients.
- Enjoy on-time monthly payments with flexible withdrawal options.
- Predictable project hours.
- Enjoy a harmonious work-life balance with consistent 8-hour working days with clients.
- Flex days, so you can recharge.
- Enjoy up to 24 flex days off per year without losing pay, for full-time positions found through Proxify.
- Career-accelerating positions at cutting-edge companies.
- Discover exclusive long-term remote positions at the world's most exciting companies.
- Hand-picked opportunities just for you.
- Skip the typical recruitment roadblocks and biases with personally matched positions.
- One seamless process, multiple opportunities.
- A one-time contracting process for endless opportunities, with no extra assessments.
- Enjoy the same pay, every month with positions landed through Proxify.
Зарплаты и спрос: Дата-инженер
Сейчас в каталоге 639 вакансий по этому направлению, удалённо можно работать в 39%.
Зарплата здесь не указана. Медиана по направлению: 245 000 ₽ в месяц. У половины вакансий от 160 000 ₽ до 294 000 ₽ (вакансий с вилкой: 38).
Навыки этой вакансии, которые чаще всего просят по направлению: Python (36%), SQL (34%), Git (11%). В скобках доля вакансий направления.