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
Top Skills
What We Do
We are a world-first, venture-backed, award-winning, hyper-growth prop tech that is transforming how construction companies sell homes, pools, granny flats, ADUs, and more