Developer Programmer (mid to senior)

JOB DESCRIPTION

Developer Programmer (mid to senior)

About Us

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

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.

• 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

• Advanced query optimisation 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 denormalisation 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 ability to create and delete production datasets

• Proficiency with DBT for data transformation
• Experience with pipeline orchestration tools (Airflow, Dagster)
• Knowledge of streaming data processing

• 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
• Experience building and integrating vector databases and RAG pipelines

• 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

• Professional development budget
• Regular knowledge sharing sessions
• Modern tech stack and tools
• Flexible working arrangements possible
• Competitive salary and benefits package

• Location: Sydney Barangaroo. No remote.
• Modern office with excellent facilities in a central location

8 May 2025