Data Engineer

Cloudwerx; Adelaide; On-site; AUD 110,000 - 170,000; Full time

Job summary

Cloudwerx is seeking multiple Data Engineers to design, build and optimize data solutions on modern cloud data platforms. You will shape end-to-end data pipelines, ensuring secure, scalable and high-performing data processing across Snowflake, Databricks and Salesforce ecosystems.

The role emphasizes ETL/ELT development, data quality, testing and collaboration with both technical and non-technical stakeholders to translate data into actionable insights.

Qualifications

• 3+ years designing and implementing modern data stacks.
• Hands-on experience in Data Engineering, ETL/ELT development or Data Migration.
• Strong SQL knowledge with joins, transformations and validation queries.
• Experience with Python, Java or similar scripting languages.
• Experience with cloud-based data platforms and modern data engineering technologies.
• Good understanding of relational databases, keys, relationships and data-quality principles.
• Experience testing data processes and investigating reconciliation discrepancies.
• Familiarity with version control and structured software development practices.

Responsibilities

• Extracting and profiling source data to identify missing values, duplicates, and inconsistencies.
• Developing and maintaining SQL scripts, data preparation routines and ETL/ELT processes.
• Designing scalable data solutions on cloud data platforms like Snowflake and Databricks.
• Implementing source-to-target mappings and transformation rules.
• Performing data validation, reconciliation and unit testing.
• Loading data into Salesforce and Snowflake using established engineering patterns.
• Supporting migration testing, rehearsals and post-migration validation.

Skills

SQL

Python/Java

Data integration

Collaboration

Data quality

Documentation

Communication

Tools

Snowflake

dbt/Coalesce

Fivetran

Databricks

Salesforce CRMA/Data Cloud

Job description

Cloudwerx is a modern Salesforce, Snowflake & AI consultancy founded in 2018 to do things differently. We design and deliver clever, scalable and human-centred data and cloud solutions that create real impact for clients across the public sector, education, health, financial services, utilities and more.

From data modernisation on Snowflake and Databricks to analytics, AI and Salesforce Data Cloud enablement, we help organisations turn data into trusted, actionable insights.

The Role

We’re looking for multiple Data Engineers with strong experience in cloud-based data engineering and modern data stacks. You’ll design and implement scalable, secure, and high-performing data solutions using technologies such such as Snowflake, DBT/Coalesce, Fivetran, Databricks, and Python/Java, while also building capability in Salesforce CRMA and Data Cloud

What You’ll Be Working On

• Extracting and profiling source data to identify missing values, duplicates, inconsistent formats and relationship issues
• Developing and maintaining SQL scripts, data preparation routines and ETL/ELT processes
• Designing and implementing scalable data solutions using modern cloud data platforms
• Implementing approved source-to-target mappings and transformation rules
• Performing data validation, reconciliation and unit testing
• Investigating rejected records, migration defects and data discrepancies
• Loading data into Salesforce and Snowflake using agreed engineering patterns
• Supporting migration testing cycles, rehearsals, cutover and post-migration validation
• Working with technologies such as Snowflake, dbt/Coalesce, Fivetran and Databricks
• Developing data processing and automation solutions using Python and/or Java
• Supporting and building capability across Salesforce CRM Analytics and Data Cloud
• Maintaining mapping specifications, technical documentation and operational runbooks
• Following version control, testing, deployment and secure data-handling standards
• Collaborating with technical and business stakeholders to identify and resolve data issues

What We’re Looking For

• 3+ years’ experience designing and implementing modern data stacks
• Hands-on experience in Data Engineering, ETL/ELT development or Data Migration
• Strong SQL knowledge, including joins, transformations and validation queries
• Experience with Python, Java or another scripting/programming language
• Experience working with cloud-based data platforms and modern data engineering technologies
• Good understanding of relational databases, keys, relationships and data-quality principles
• Experience testing data processes and investigating reconciliation discrepancies
• Familiarity with version control and structured software development practices
• Strong attention to detail and good technical documentation skills
• Ability to collaborate effectively across technical and business teams
• Ability to proactively identify, communicate and escalation data-quality or migration issues

Good to Have

• Experience with Snowflake, Databricks
• Experience using dbt and/or Coalesce
• Experience with Fivetran or similar data integration tools
• Experience with Salesforce data loading,Salesforce CRM Analytics (CRMA) and Data Cloud
• Exposure to SQL Server, DB2 or other enterprise database platforms
• Experience with cloud integration tools or automated data testing
• Experience working with sensitive information in controlled environments

Why Join Cloudwerx?

You’ll have the opportunity to work across modern data platforms, cloud technologies and Salesforce ecosystems while contributing to meaningful transformation programs across a diverse range of industries.

If you enjoy solving complex data problems, building modern data solutions and making sure data moves accurately and reliably from one system to another, we’d love to hear from you.