Hybrid Consultant, Data Engineer – Snowflake, dbt

at INTELLIGEN

• Job title: Consultant, Data Engineer – Snowflake, dbt
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: No Education Requirement
• Tech skills: ETL, SQL
• Location requirements: Hybrid, Sydney, Australia

About the role

• Consultant Data Engineer for modern data transformations at Intelligen. Work on dbt and Snowflake projects for enterprise clients to optimize data pipelines.

Responsibilities

• Re-engineer and refactor existing dbt models to align with domain-driven design principles.
• Optimise and uplift existing Snowflake datasets, data structures, and transformation pipelines
• Contribute to solution design, technical decisions, and modelling best practices
• Work closely with client data teams to ensure maintainability, performance, and clarity of lineage.
• Support CI/CD, testing, and documentation of all aspects of data engineering projects.
• Collaborate with the broader Intelligen consulting practice as part of a multi-resource delivery team.
• Contribute to ongoing consulting engagements beyond the initial project as part of our integrated consulting pool.

Requirements

• 3–5+ years’ experience in data engineering or analytics engineering roles.
• Strong, hands-on ETL expertise
• Solid Snowflake experience, including schema design, performance tuning, and warehousing best practices.
• Ideally experience with SQL, data modelling (dimensional/domain), and modern data stack tooling.
• Ability to operate in “doer mode” — comfortable rolling up sleeves and delivering quickly in line with agreed standards
• Consulting experience is a plus but not required; strong communication and problem-solving skills are essential.
• ****Must-have's...**
• Advanced dbt capability (the strongest requirement)
• Strong, practical Snowflake engineering experience
• Ability to deliver independently within a structured consulting engagement.**

Benefits

• We’re not just delivering AI and data projects.. we’re humanising them. That means we care deeply about the how, not just the what. We value curiosity, creativity, and a willingness to challenge the status quo. We look for people who are driven to build a business, get curious, and offer opinions and ideas.
• You’ll join a team that’s smart, kind, and ambitious. You’ll have real influence - in your projects, your practice, and the broader business. And as we grow, so will you.
• Here’s what that looks like:
• **Grow With Purpose**
• Structured development pathways so you always know what you’re working toward.
• Paid certifications across all major cloud and data technologies — because mastery matters
• Weekly training, guilds and knowledge exchanges where practitioners share real project insights.**
• **Support That Helps You Thrive**
• A dedicated support lead to mentor, guide and help you navigate your career
• Regular 360° feedback loops, giving you clear direction and honest insight into your progress.**
• **A Community You’ll Enjoy Being Part Of**
• Innovation days where you can experiment, prototype and sharpen new skills.
• Team days, social catchups, many new community clubs…
• Opportunities to lead, influence and shape our growing practice as we expand across the region.**
• If you want to be part of a team that cares just as much about *how* we deliver as *what* we deliver; where curiosity is valued, ideas matter, and your impact is felt - drop us a message and start the conversation today...