Developer Programmer Sydney Engineering

2 weeks ago


Council of the City of Sydney, Australia Traffyk Full time

We’re a rapidly growing tech company based in Sydney’s Barangaroo district, specialising in building scalable AI solutions for enterprise clients. We have a strong focus on code quality and performance leveraging the best tools and practises.

The Candidate

We’re seeking an experienced, skilled, mid to senior Developer Programmer to join our technical team. The ideal candidate will be expert in SQL optimisation, cloud application and development platforms, and modern data tools. They will have a passion and curiosity to develop new solutions to difficult problems. You’ll be responsible for designing and implementing efficient data pipelines, optimising query performance, and collaborating with data analysts/scientists to deliver robust ML/AI solutions.

Why This Role Is Different

- No tech debt – ability to focus on modern data engineering practices

- Direct impact on architectural decisions and best practices

- Opportunity to work with cutting‑edge tools and cloud technologies

Requirements & Core Skills

SQL

- Advanced query optimization and performance tuning

- Experience with window functions, CTEs, and complex joins

- Knowledge of indexing strategies and query plan optimisation

- Ability to write efficient and maintainable SQL code

- Ability to write recursive functions

- Experience with incremental logic in production data pipelines

- Expert in creation and maintenance of feature stores for AI models

- Strong understanding of dimensional modelling

- Experience with DBT and modern data warehouse design

- Knowledge of data normalisation and denormalization trade‑offs

- Ability to track data lineage for tables and fields using visual tools

- Experience with medallion data architectures

Technical Requirements

- Hands‑on experience with at least one(AWS/GCP/Azure)

- Understanding of cloud cost optimisation

- Experience with at least one cloud‑native data warehouse (Snowflake, Redshift, BigQuery)

- Experience in a cloud admin role with abilityto create and delete production datasets

- Proficiency with DBT for data transformation

- Experience with pipeline orchestration tools(Airflow, Dagster)

- Knowledge of streaming data processing

Programming

- Python proficiency for data processing and automation

- Experience with version control (Git) and CI/CD practices

- Fluent with CLI languages and cloud connections to local machines

- Experience with social network analysis tools

Nice to Haves

- Experience with NoSQL databases (MongoDB,Cassandra)

- Experience with scalable sequence modelling

- Knowledge of data mesh architecture

- Experience with real‑time data processing

- Experience with data quality monitoring tools

- Experience with feature stores and vector databases for ML/AI models

Ideal Candidate Profile

We’re particularly interested in candidates who:

- Have 5+ years of experience in software development and data engineering or related field

- 3+ years in a consultancy role

- Demonstrate strong problem‑solving abilities

- Have experience optimising large‑scale cloud applications and data heavy systems

- Show enthusiasm for learning new technologies and tackling new problems

- Have experience in large, complex organisations where you have lived and breathed the problem of excessive workforce communications

- Team leadership experience

- Must have the right to live and work in Australia without additional visa requirements

Culture and Environment

What We Offer

- Regular knowledge sharing sessions

- Modern tech stack and tools

- Flexible working arrangements possible

- Competitive salary and benefits package

Work Arrangement

- Modern office with excellent facilities in a central location

#J-18808-Ljbffr



  • Council of the City of Sydney, Australia Sydney Metro Full time

    Update your details, view your application and progress. Project Engineer, Sydney (Royal Prince Alfred Hospital Redevelopment) At CPB Contractors, we know what it takes to construct a better future. Our track record speaks for itself – more than 90 years’ experience in transforming communities to help people live, work and move better. Today we are...


  • Council of the City of Sydney, Australia Nike Sydney Full time

    Nike - 3IC - Sydney WHO WE ARE AF1 Pty. Ltd. is an Authorised Nike Dealer that has been in business since 2006, having expanded to 7 locations across Sydney including Sydney City, Bondi Junction, Burwood, Castle Hill, Chatswood, Neutral Bay and Warringah Mall. Leading the way with our staff development and culture, we pride ourselves in providing an...


  • Council of the City of Sydney, Australia GrainCorp Full time

    Overview Role: Senior Analyst Programmer Location: Sydney Salary Range: $155k - $175k (inclusive of superannuation) About the role As the Senior Analyst Programmer, reporting to the Development Manager, you will develop high quality, robust, performant IT systems and support the business critical IT system. Responsibilities - Provide operational support...

  • Team Leader

    3 weeks ago


    Council of the City of Sydney, Australia Sutherland Shire Council Full time

    Join our Development Services team as Team Leader – Development Engineering and play a key role in shaping the region’s future. From stunning coastlines to thriving bushland, Sutherland Shire offers a unique setting for innovative and sustainable development. Lead a specialist team, drive sustainable development outcomes, ensure regulatory compliance,...


  • Council of the City of Sydney, Australia De Air Full time

    ## In the Community### Engineering Graduate – Sydney## Engineering Graduate – SydneyThe goal is simple: to provide our graduates with a broad overview of mechanical contracting, from site operations and engineering to estimating and project management, while building their working knowledge.More specifically, the D&E Graduate Engineering Program aims to...

  • AEM Developer

    4 weeks ago


    Council of the City of Sydney, Australia Ayan Infotech Full time

    Overview AYAN InfoTech is looking for AEM Developer to join an exciting project based in Sydney. The role offers you the opportunity to contribute towards an extremely well structured and mature environment, working on sophisticated enhancement projects. Role Details Role: AEM Developer Location: Sydney Contract Duration: 6 Months with high possible...


  • Sydney, New South Wales, Australia Synechron Full time $80,000 - $110,000 per year

    We are looking for talentedDeveloper Programmersto join our teamSydney, Full time permanentSalary Range $80,000 to $110000 per annumNo of positions - 4Experience – 3+ yearsWho are we?Synechron Company, is a global provider of Information Technology outsourcing services focused on the banking, finance and payments industry. We provide a broad range of IT...


  • City of Brisbane, Australia RCP Melbourne Full time

    About Us RCP is a specialist provider of independent planning, programming, delay claim analysis and project management advisory services to clients in the building, construction and infrastructure industries. RCP’s expertise and capability is backed by over 40 years’ of combined knowledge and experience and a multi-disciplinary team of industry leading...


  • Sydney NSW, Australia Synechron Australia Full time $80,000 - $110,000 per year

    We are looking for talented Developer Programmers to join our teamSydney, Full time permanentSalary Range $80,000 to $110000 per annumNo of positions - 4Experience – 3+ yearsWho are we?Synechron Company, is a global provider of Information Technology outsourcing services focused on the banking, finance and payments industry. We provide a broad range of IT...


  • Council of the City of Sydney, Australia GPA Engineering Full time

    For over 35 years, GPA Engineering has been a trusted, Australian‑owned consultancy delivering engineering, procurement and construction management services across water, energy, renewables, defence, mining, and hydrogen. We develop and implement projects that drive critical infrastructure and support industries across Australia. With offices nationwide...