Data Engineer (SQL)

Job description

FinXL is seeking a Senior Data Engineer to join our consulting team and be deployed with a leading Banking client on a key transformation engagement.

FinXL Professional Services is a leading IT consultancy that partners with clients to bridge the gap between business needs and technology capabilities. Since 2003, we've been delivering high-value ICT services across government, finance, telecommunications, and enterprise sectors.

Responsibilities

  • Collaborate on a program to upgrade core infrastructure including data centre move and cloud services implementation.
  • Developed high-performance T-SQL ETL jobs for data deduplication, enrichment, and sliding-window aggregations.
  • Generated JSON/CSV deployment feeds that complied with CSM import formats and APIC object model payloads.
  • Implemented lineage tracking from aggregated tuples back to raw flows for audit and compliance.
  • Created Tidal job definitions, including retries, alerts, and exception queues for unmapped IPs.
  • Optimized partitioning, indexing, and query plans for very large NetFlow tables.

Key Skills & Experience

  • Proven experience as a Senior Data Engineer in a demanding enterprise environment.
  • Deep understanding of data warehousing and ETL/ELT best practices.
  • Expertise in MS SQL Server, including T-SQL, indexing, partitioning, window functions, and query tuning.
  • Skilled in producing controller-ready export formats (JSON/CSV) for APIC and CSM.
  • Familiarity with scheduled job orchestration (Tidal) and operational alerting frameworks.
  • Experience with Dask/Spark for prototyping and data lineage tooling is a plus.
  • Experience with PowerBI or similar visualisation tooling is beneficial.

What's on offer

  • 6-12 months contract engagement
  • Hybrid working with 2-3 days per week in the office in Sydney CBD & Norwest

Next Steps

  • Apply now highlighting relevant skills and experience and address your application to Julia Leung. Due to the high volume of applications only shortlisted candidates can be contacted.