Developer Programmer Sydney Engineering

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