Position- Senior Data Engineer

Exp- 7+yrs

Skill- Redshift

Job Type- Contract

Location- Sydney/Melbourne

JD-

- Hands-on experience with Redshift and Data Engineering technologies.
- The work is mainly on Red Shift and would prefer candidates with Personal Injury reporting experience.

Essential Skills and Experience-

- Proven hands-on experience with Amazon Redshift in a data warehousing or data engineering environment.
- Strong SQL skills, including complex joins, CTEs, window functions, aggregations, and query optimisation.
- Experience designing and developing ETL/ELT pipelines and data transformation workflows.
- Strong understanding of data warehouse architecture, dimensional modelling, star schemas, and slowly changing dimensions.
- Experience with AWS data services, particularly Amazon S3 and AWS Glue.
- Knowledge of incremental loading, data reconciliation, error handling, and data quality management.
- Experience troubleshooting data pipeline failures and improving data processing performance.
- Ability to work effectively with technical teams and business stakeholders in an Agile delivery workplace.

Responsibilities-

- Design, develop, and maintain scalable data pipelines and ETL/ELT processes using AWS data engineering technologies.
- Develop complex SQL queries, stored procedures, views,



and data transformation logic in Amazon Redshift.
- Build and maintain data warehouse solutions to support operational reporting, analytics, and business intelligence.
- Optimise Redshift query performance through appropriate data modelling, distribution styles, sort keys, workload management, and query analysis.
- Integrate data from multiple source systems, including databases, APIs, files, and cloud storage platforms.
- Develop and maintain data models, including fact and dimension tables, to support reporting and analytical requirements.
- Implement incremental data loads, data validation, reconciliation, and data quality checks.
- Work with AWS services such as Amazon S3, AWS Glue, AWS Lambda, and IAM to build reliable data solutions.
- Collaborate with business analysts, reporting teams, and stakeholders to understand requirements and translate them into technical solutions.
- Monitor data pipeline performance, troubleshoot production issues, and ensure data accuracy, availability, and reliability.
- Follow data governance, security, privacy, and documentation standards relevant to Australian business and regulatory requirements.

Interested candidates can share their updated resumes on [email protected] OR reach out to me on +61 2 90559939.

📌 Senior Data Engineer/Redshift (Sydney)
🏢 CareCone Group
📍 Sydney