What you will do
Engineer scalable pipelines(e.g. Glue/Databricks Step Functions Lambda) to delivertimely reliable data.
Partner with Marketing and Martech in defining the business dataneeds;producerequirements sourcetotarget mappings and data dictionaries.
BuildtwowayintegrationbetweenVanguard Australias modern data analytics platformand Adobe Experience Platform (batch/stream) including secure ingestion andbackwriteof activation outcomes.
Work collaboratively within a team environmentpartneringclosely with PI Data Analysts to translate analytical requirements into scalable data solutionswhile also working effectively with the broader data engineering community within CDAO.
Embed data quality & governancewith automated profiling validation reconciliation lineage and monitoring.
Support & optimiseexisting data infrastructure with the wider Data & Analytics team to meet SLAs.
Enableselfserviceanalyticsby publishing trusted datasets andmaintainingTableau/Power BIdashboards.
Document clearly(requirements functional specs data dictionaries runbooks).
Lift team capabilitythrough knowledgeshare sessions and collaboration in an Agile delivery model.
Whatyoullbring
Strong SQL(PySpark& Spark SQL)and Python.
Experience with pipeline tooling (Glue Step Functions/Lambda).
Proficiencyin building and optimising data pipelines using Databricks across the medallion architecture
Understanding of data modelling (dimensional/ELT/medallion) privacy/compliance anddataqualitypractices.
Solid understanding of version control systems specifically Git.
Collaborative mindsetcomfortable working with marketers analysts and engineers in sprints; strong written documentation.
Proven stakeholder management and communication skills.
Ability to document requirements challenge assumptions and design efficient solutions.
Comfort working independently in complex data environments.
Nice to have
Familiarity across the Adobe Experience Cloud stack (AEP AJO AEM Target Analytics) for data activation personalisation and journey optimisation.
Basics of Tableau/Power BIand API integrations; AWS experience andIAC (Infrastructure as code).
Why This Role Is Unique
Blend of business analysis engineering.
Direct impact on data strategy solution design and business decision-making.
Great fit for someone who enjoys both solving technical problems and working with people.
Target start
EarlymidMarch 2026 aligned to ongoing recruitment for a Data Engineer in PI Analytics.
How We Work
Vanguard has implemented a hybrid working model for the majority of our crew members designed to capture the benefits of enhanced flexibility while enabling in-person learning collaboration and connection. We believe our mission-driven and highly collaborative culture is a critical enabler to support long-term client outcomes and enrich the employee experience.
Required Experience:
IC
Search the latest roles and opportunities at Vanguard. Apply today to join our industry-leading crew.