Data Engineer

genius office; India; Hybrid; INR 1,500,000 - 2,100,000; Full time

Job summary

genius office seeks a data engineer to own data warehouses, pipelines and models from initial conversations through production, partnering with clients across North America, Europe and India.

You will design Snowflake/BigQuery warehouses, pull data with Fivetran, model with dbt, and orchestrate with Airflow while mentoring peers and shaping the data platform strategy.

Qualifications

• 3+ years in data engineering with production experience on Snowflake and/or BigQuery.
• Strong SQL and Python.
• Deep data modeling skills (Kimball, star schemas, slowly changing dimensions).
• Hands-on dbt experience in production.
• Data ingestion with Fivetran in production.
• Pipeline orchestration with Airflow.
• Solid Git workflow.
• Real experience using AI coding agents (Claude Code or similar).
• Clear communication with both technical and non-technical people.
• Flexibility to overlap with North American, European and Indian time zones.

Responsibilities

• Design and build cloud data warehouses on Snowflake and BigQuery.
• Ingest data from business systems with Fivetran and keep it up to date.
• Model data for business users with dimensional modeling and dbt.
• Build and orchestrate reliable pipelines with Airflow.
• Use Claude Code and agentic development workflows to ship faster with guardrails.
• Collaborate with client teams to translate business processes into data models.
• Monitor and improve production pipelines for data quality, cost and performance.
• Mentor other engineers and shape how the team builds data platforms.

Skills

SQL

Python

Data modeling

dbt

Fivetran

Airflow

Git

AI coding agents

Communication

Time zone overlap

Tools

Snowflake

BigQuery

Dagster

Power BI

Terraform

dlt

GitHub Actions

Job description

The Role

Design and build the data platforms clients base their decisions on. You own warehouses, pipelines and data models from the first conversation through to production, and stay involved as they evolve. You’ll work with clients and teammates across North America, Europe and India.

What You’ll Do

• Design and build cloud data warehouses on Snowflake and BigQuery
• Bring data in from business systems with Fivetran, and keep it complete and up to date
• Model data that business users can trust, using dimensional modeling and dbt (tests, documentation, sources, snapshots)
• Build and orchestrate reliable pipelines with Airflow
• Use Claude Code and agentic development workflows to ship faster, with good review and guardrails
• Sit with client teams to understand how their business runs, and turn that into the right data model
• Monitor, troubleshoot and improve production pipelines for data quality, cost and performance
• Mentor other engineers and help shape how the team builds data platforms

What You’ll Bring

• 3+ years in data engineering, with production experience on Snowflake and/or BigQuery
• Strong SQL and Python
• Deep data modeling skills (Kimball, star schemas, slowly changing dimensions)
• Hands-on dbt experience in production
• Data ingestion with Fivetran in production
• Pipeline orchestration with Airflow
• Solid Git workflow
• Real experience using AI coding agents (Claude Code or similar) day to day, and judgment about where they help and where they need review
• Clear communication with both technical and non-technical people
• Flexibility to overlap with North American, European and Indian time zones

Nice to Have

• Consulting or client-facing experience
• Dagster or other pipeline orchestration tools
• CI/CD for data with GitHub Actions
• Terraform or other infrastructure-as-code
• BI tools such as Power BI
• Other ingestion tools such as dlt
• Experience supporting ML or operational AI workloads

About the Company

genius office has built business systems since 1994, starting with custom ERP. It now serves businesses in 17 industries across North America, Europe and India, covering connected systems, trustworthy data, practical AI and reliable cloud operations.

Why genius office

Real business problems across many industries with measurable results, a team using modern data tooling and agentic development every day, and a global team with offices in Canada and India.