Data Engineer/BI Engineer

India - Remote

Canibuild Au Pty Ltd

Site plan software allowing residential contractors and home builders to determine site suitability, position and price point for any build remotely.

View all jobs at Canibuild Au Pty Ltd

Apply now Apply later

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

Apply now Apply later

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  0  0  0

Tags: Agile Airflow APIs Architecture Athena AWS Data Analytics Data quality Data visualization Data warehouse ELT Engineering ETL JSON Lambda MS SQL NumPy Pandas Pipelines PostgreSQL Power BI Python Redshift SQL Tableau T-SQL

Perks/benefits: Competitive pay

Regions: Remote/Anywhere Asia/Pacific
Country: India

More jobs like this