Job Description

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.

Requirements

4+ years of experience in data engineering, ETL/ELT pipeline development, and database management. Strong expertise in SQL (T-SQL, MS SQL) with a focus on query optimization and database performance tuning. Proficiency in Python (including data-specific libraries such as Pandas, NumPy, etc.) and Airflow for ETL/ELT processes. Experience extracting and managing data from third-party APIs (REST, JSON). Proven experience in designing and developing data warehouse solutions on AWS. Strong expertise in Power BI for data visualization, dashboard creation, and connecting to SQL Server/PostgreSQL Aurora. Familiarity with agile methodologies and a continuous improvement mindset. Demonstrated ability to think critically and evaluate multiple technical solutions in the broader context of system architecture and business goals. Excellent problem-solving skills and the ability to proactively identify and implement alternative solutions. Strong communication skills and ability to work collaboratively in a team-oriented environment. Willingness to upskill in AI-driven data solutions and contribute to AI-powered applications.

Preferred Qualifications

Exposure to AWS cloud data services such as RedShift, Athena, Lambda, Glue, etc. Experience with additional BI tools like Tableau. Knowledge of data lake architectures and best practices. Experience with AI-driven data analytics, or integrating AI models with BI solutions.

Benefits

Work with a talented team of data and AI professionals on meaningful, industry-transforming projects. Opportunity to gain hands-on experience with AI technologies and modern data engineering practices. Competitive salary, benefits, and opportunities for growth. A collaborative, fast-paced, and innovative culture that values initiative, ownership, and smart solutions. * Flexible remote work opportunities