Data Engineer/BI Engineer

About Us

Canibuild automates the residential construction industry’s design, approval, and sales processes, allowing clients to answer 'Can I build this on this plot of land?' instantly. As a fast-growing SaaS platform backed by Australia’s largest hedge fund, we serve clients across Australia, New Zealand, Canada, and the US.

Role Overview

We are seeking a highly skilled Data Engineer / BI Engineer with experience in designing ETL/ELT pipelines, managing databases, and developing dashboards using Power BI. The ideal candidate will be responsible for handling end-to-end data workflows, from data extraction and transformation to visualization and insights generation.This role also provides opportunities to upskill and contribute to AI-driven data initiatives, making it an excellent fit for professionals eager to grow in a modern data ecosystem.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Python, Airflow, and SQL in an AWS environment.
• Manage and optimize data lake and data warehouse solutions on AWS.
• Develop and maintain data-driven dashboards and reports in Power BI, connecting to SQL Server and PostgreSQL Aurora databases.
• Extract and integrate data from third-party APIs to populate the data lake.
• Perform data profiling and source system analysis to ensure data quality and integrity.
• Collaborate with business stakeholders to capture and understand data requirements.
• Optimize SQL queries for performance and ensure efficient database operations.
• Implement best practices for data engineering, visualization, and database management.
• Participate in architectural decisions and contribute to the continuous improvement of data solutions.
• Follow agile and lean development practices for efficient project execution.
• Independently validate and assess the accuracy of data outputs before delivery, ensuring results align with business expectations.
• Proactively evaluate different technical approaches and suggest alternatives to ensure optimal outcomes within the broader system and business context.
• Stay updated on the latest AI and data engineering advancements, with opportunities to apply AI-powered solutions.