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.
Technologies You’ll Use
- Cloud Data Warehouses
Snowflake
Google BigQuery
- Data Ingestion
Fivetran
- Modeling & Transformation
dbt
- Pipeline Orchestration
Apache Airflow
- Languages
SQL
Python
- Version Control
GitHub
- AI Agents
Claude Code
- Nice to Have
Dagster- GitHub Actions
Terraform
Power BI
dlt
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.