Data Engineer - MS SQL | BI & Data Warehouse Expert

CareCone Group; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

CareCone Group is seeking a data engineering/BI professional in Sydney to design and implement robust data models and scalable ETL/ELT pipelines. The role emphasizes Star schema and Kimball-style modelling, data lake/mesh concepts, and cloud-based analytics.

You will work with AWS services, BI tooling, and reporting dashboards, collaborating with stakeholders to deliver reliable data solutions and actionable insights in a fast-paced environment.

Qualifications

• Database and data warehouse modelling experience (Star schema, Kimball, Snowflake) valued.
• ETL/ELT pipelines or data analytics experience.
• Familiar with Agile and Waterfall methodologies.
• DevOps/CI/CD experience desirable.
• Experience with Data Lake, Data Mesh, AWS Cloud and analytics is advantageous.
• Strong SSIS/SSRS/SSMS and scripting (bash/sh, PowerShell).
• Experience with AWS S3, Airflow, Glue, Qlik or SAP BO desirable.
• Atlassian Jira/Confluence or MS SharePoint experience desirable.
• Experience with incident management tools.
• Strong understanding of data platforms, models and reporting.
• Customer-focused with excellent communication to C-Level.

Skills

Data modelling

ETL/ELT pipelines

Agile & Waterfall

DevOps CI/CD

Cloud data platforms

Data Lake / Data Mesh

BI Stack (SSIS/SSRS/SSMS)

Scripting (Unix/PowerShell)

AWS S3 / Airflow / Glue

Atlassian Jira/Confluence

Communication with C-level

Data reporting & dashboards

Financial analysis

Tools

SSIS

SSRS

SSMS

Unix/Linux scripting

PowerShell

AWS S3

Apache Airflow

Glue

Qlik

SAP Business Objects

Confluence

Jira

MS SharePoint

CI/CD tooling

Job description

CareCone Group is seeking a data engineering/BI professional in Sydney to design and implement robust data models and scalable ETL/ELT pipelines. The role emphasizes Star schema and Kimball-style modelling, data lake/mesh concepts, and cloud-based analytics.

You will work with AWS services, BI tooling, and reporting dashboards, collaborating with stakeholders to deliver reliable data solutions and actionable insights in a fast-paced environment.