Data Engineer: Lead Projects & Mentor Enterprise Teams

Pivot Analytics; Australia; On-site; AUD 80,000 - 110,000; Full time

Job summary

Pivot Analytics in Australia is looking for a Data Engineer with 2-3 years of experience to work directly with clients. In this role, you will help build data pipelines and lead projects while mentoring junior members. Strong SQL skills and knowledge of dimensional modeling are essential.

The ideal candidate will communicate effectively with client teams, adapt to modern architectures, and enjoy mentoring others. This position offers an opportunity to work on important data projects that impact enterprise organizations.

Qualifications

• At least 2-3 years of data engineering experience at a structured organization.
• Strong SQL skills with emphasis on joins, CTEs, and query optimization.
• Fundamentals of dimensional modeling including star schemas.

Responsibilities

• Contribute to client projects and learn enterprise data engineering.
• Take technical lead on projects while mentoring junior team members.
• Own the success of the solutions we build with client teams.

Skills

SQL skills

Dimensional modeling

Cloud data warehouse experience

Exposure to dbt

Git fundamentals

Client-facing experience

Job description

Pivot Analytics in Australia is looking for a Data Engineer with 2-3 years of experience to work directly with clients. In this role, you will help build data pipelines and lead projects while mentoring junior members. Strong SQL skills and knowledge of dimensional modeling are essential.

The ideal candidate will communicate effectively with client teams, adapt to modern architectures, and enjoy mentoring others. This position offers an opportunity to work on important data projects that impact enterprise organizations.