Data Engineer/BI Engineer

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.

• 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.

• 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