Data Analytics Engineer

About the role :

Were hiring an Analytics Engineer to improve how the business accesses and uses datathrough durable modeling a strong semantic layer and stakeholder enablement. Reporting to the Head of Data and Analytics youll work closely with stakeholders while collaborating with a globally distributed data team.

This role focuses on excellence in data modeling and semantic layer design ensuring people (and AI-assisted workflows) can access reliable well-structured data. A meaningful portion of the role involves support and investigation work : diagnosing issues clarifying requirements and unblocking stakeholders.

Our core data team is based in Australia and this role is based in North America. Youll be a key partner for North American stakeholders often serving as the primary data contact for those based in Eastern & Pacific timezones while collaborating with the wider data team in Australia during overlapping hours.

The semantic layer work has a dual purpose : enabling business users today and laying the foundation for AI-assisted analytics over time. Clear metric definitions well-structured models and strong documentation are what make both human self-service and AI-driven analytics possible.

What youll do

Design build and maintain data models in dbt with attention to grain fact types and modeling best practices. Default to fixing problems at the right layer even when a shortcut exists.

Develop and maintain the semantic layer in Lookerstandardized metrics and reusable Explores over one-off fieldsto support scalable analytics and AI-assisted workflows.

Partner with stakeholders to deliver scalable solutionsprioritizing reusable metrics and Explores over one-off artifacts unless a bespoke solution significantly unblocks adoption.

Conduct end-to-end investigations when issues arise across the data stack (ingestion modeling BI reverse ETL).

Work across adjacent tools including Snowflake Segment Amplitude and Hightouch as needed.

Identify opportunities to improve data quality reduce costs and simplify the codebase.

Use AI tools daily for code generation investigation and documentation. AI is a draft; you own correctness through review and validation.

Enable AI-driven analytics (e.g. Snowflake Cortex Looker conversational analytics) by optimizing the semantic layer and curating high-quality context for these systems.

Champion engineering best practices : version control testing clear documentation and well-contextualized pull requests.

Qualifications :

What were looking for

Required :

Strong understanding of data modeling fundamentals : facts vs dimensions grain slowly changing dimensions immutability.

Advanced SQL skills on a modern data warehouse platform (we use Snowflake).

Experience contributing to production analytics codebases (e.g. dbt) with reviews testing and conventions.

Comfort working in Looker or similar BI tools with a focus on reusable patterns rather than one-off solutions.

Ability to engage proactively with stakeholders and communicate in business terms.

Willingness to spend time clarifying problems before jumping to solutions.

Daily use of AI tools with appropriate review and validation of outputs.

Comfort working autonomously and making sound judgment calls - especially when you cant get immediate input from the broader team due to timezones.

Nice to have :

Snowflake performance tuning and cost awareness.

Experience with Fivetran Segment Amplitude Hightouch or similar tools.

Proficiency in Python for automation and scripting.

Familiarity with tracking plans and product analytics concepts.

Experience with reverse ETL workflows.

Exposure to AI-assisted analytics workflows or building lightweight internal automations.

What success looks like :

In the first 90 days wed expect to see faster resolution on support requests clearer diagnosis of root causes and at least one meaningful contribution to team productivity or data quality. Stakeholders should feel well-supported with clearer answers fewer recurring definition disputes and more confidence using shared metrics.

Additional Information :

Why join us :

Join our global SaaS scale-up company where we foster a collaborative open and transparent culture and work without ego. Our team comprises curious and intelligent colleagues who embrace challenges. Heres what we offer :

• Employee share options from day one
• RRSP program with employer matching
• 20 days of accrued annual leave / vacation plus 10 wellbeing days to prioritize yourself and your loved ones
• Additional paid day off to celebrate your birthday along with volunteering leave
• Health dental and vision benefits starting immediately
• Annual education allowance reimbursement to support your professional development
• Employee recognition program
• Quarterly wellness allowance to invest in your personal wellness
• Paid subscriptions to Headspace and LifeWorks EAP
• Flexible working arrangements supported by WFH reimbursement and technology allowance to ensure your safety while working from home
• Personal tax return assistance (since were in the accounting business!)
• Paid parental leave

Experience comes in many forms and skills are transferable please consider applying even if you dont tick all the boxes.

Ignition is an equal opportunity employer providing fair consideration to all applicants regardless of background.

Ignition is committed to providing accommodations throughout the hiring process. If theres a fit well work with you to meet your accessibility needs. For questions requests or alternate formats contact us at

Compensation :

Our salary bands are designed to reflect the range of skills and experience needed for the position and to allow room for growth. The final offer amount for this role will be dependent on state / location applicable experience and skillset of the candidate.

For experienced individuals we typically hire at or around the midpoint of the band. The top portion of the salary band is reserved for employees who demonstrate sustained high performance and impact over the course of their tenure at Ignition.

This role has a minimum annual base of CAD $120000 and maximum annual salary of CAD $160000 (plus equity health insurance & other wellness perks).

Remote Work : Yes

Employment Type : Full-time

Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

Experience : years

Vacancy : 1