Data Engineer
Summary
Data Engineer at BizCover, an online business insurance comparison platform, owning end-to-end delivery of data pipelines, models, and tests. Core stack includes Snowflake, dbt Cloud, Fivetran, and MSSQL, in a hybrid Sydney-based role (3 days office, 2 days home).
Who are we?
We are the leading online platform for comparing and buying business insurance.
Not to toot our own horn, but we’re shaking things up in the SME business insurance market! We’re all about making it easy and efficient for small businesses to get the perfect coverage they need to stay protected. Say goodbye to headaches and hello to hassle-free insurance!
Role Purpose?
The purpose of this role is to contribute to changing how BizCover operates using data to drive decisions and exceed our strategic growth objectives.
We’re currently looking for two Data Engineers to join our team, with both roles based in Sydney.
Responsibilities:
- Own end-to-end delivery of data pipelines, models, and tests
- Implement reusable patterns and model structures in MSSQL, dbt Cloud, and Snowflake
- Monitor data quality, lineage, and job health
- Collaborate cross-functionally to define scalable data solutions
Requirements
- Ideally would have 4-6 years of experience.
- Technical experience with Snowflake, Fivetran, dbt Cloud, MSSQL
- Ability to model data using best practices
- Proficiency in writing tests, implementing observability, and improving reliability
- Strong documentation and technical communication skills
- Hands-on experience using AI-assisted development tools (e.g., SQL/dbt copilots, LLMs for documentation, testing, or refactoring) to improve productivity and code quality.
- Interest in learning and adopting emerging AI capabilities within the modern data stack.
Benefits
- Hybrid working model with flexibility to work from home 2 days and the 3 days in the office
- Exciting and rewarding team culture
- Quarterly recognition awards
- Business Casual dress code
- Rewarding Employee Incentive Program
- Employee benefits package
- Growing company with progression opportunities
We are an equal opportunity employer and we do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or any other protected status. We encourage applications from people of all backgrounds, identities, and perspectives. We are committed to creating a diverse and inclusive workplace where everyone can thrive and grow.
Skills
As published by workable · 5 questions · 3 written answers
Basics
First name, Last name, Email, Headline, Address, Phone, Education, Experience, Summary, Resume
Short answers (1)
- What are your salary expectations (excluding Super)?
Pick from a list (1)
- Do you have full rights to work in Australia? Please select "NO" if you're on a visa.
Written answers (3)
- You receive a daily file containing customer records. The file may contain new customers, updated customers and customers that have been deleted from the source. How would you design ingestion and transformation process to identify and handle these changes?
- A daily pipeline reports that the number of policies has dropped by 35%. What would you investigate and how would you determine whether it is a real business change or data issue?
- You have two versions of product configuration file. Write SQL to identify new, changed, and deleted records between two versions. Explain how you would make the comparison reliable.