Description
At SEEK, we serve a noble purpose: to help people live more productive and fulfilling working lives and to help organisations succeed.
We are looking for a Senior Data Engineer to join the Marketing Technology Team, working closely with the MarTech Data & Insights Manager and Data Team to shape the data structures and models that underpin marketing technology.
The Senior Data Engineer is a vital part of the Marketing Technology Team, working closely with stakeholders to translate marketing and customer requirements into clear, trusted and scalable data models that support segmentation, personalisation, analytics and activation across ANZ and Asia.
Key Responsibilities:
- Work with key stakeholders, business analysts, data analysts and development teams to understand requirements and define fit-for-purpose data modelling solutions.
- Lead the design and documentation of conceptual, logical, physical and dimensional data models for data warehouses, datamarts and analytical use cases.
- Define entities, attributes, relationships, keys, grain, hierarchies and business definitions in partnership with subject matter experts.
- Design and evolve scalable data warehouse, datamart and analytical schemas that support consistent reporting, segmentation, personalisation and activation.
- Analyse source systems and perform source-to-target mapping, identifying data meaning, dependencies, gaps and transformation requirements.
- Partner with data engineers to implement models through reliable ETL/ELT and data processing pipelines.
- Use advanced SQL to validate models, transformations and data quality, and to support data discovery and troubleshooting.
- Apply modelling standards and contribute to consistent naming, documentation, metadata, lineage and governance practices.
- Review and optimise model performance, query efficiency, physical schemas and underlying system resource utilisation.
- Support end users of data assets by helping them find, understand and use trusted data, and by resolving modelling or data quality issues.
- Identify and resolve data quality issues by working with source-system owners and delivery teams.
- Contribute to operational support of data systems, including incident response, monitoring and alerting, CI/CD and relevant database administration.
- Understand the marketing, sales and service customers your team supports, using their needs to guide modelling priorities and maximise business impact across APAC.
- Drive continuous improvement in the data modelling and engineering process, communicating progress, risks and changes that may affect stakeholders.
- Contribute to an environment of collaboration, knowledge sharing and continuous learning within the team.
Qualifications:
- 8–10 years of data modelling experience, ideally in data warehousing, datamarts or analytical data platforms.
- Proven experience designing and delivering conceptual, logical, physical and dimensional data models.
- Advanced SQL development skills, including the ability to profile, validate and troubleshoot data models and transformations.
- Strong understanding of database design, including normalisation, denormalisation, schema design and database performance optimisation.
- Experience analysing source systems, defining source-to-target mappings and translating business requirements into robust data structures.
- Experience implementing data models through ETL/ELT, orchestration and data processing pipelines.
- Experience with modern data platforms or big data technologies, such as Hadoop/EMR, Spark/Presto or MPP relational databases.
- Experience with AWS or comparable cloud data platforms.
- Exposure to Martech tools/Platforms.
- Understanding of data quality, governance, metadata and lineage practices, with an appreciation of how data is consumed through reporting and visualisation tools.
Perks and benefits:
- Annual Performance Bonus Plan.
- Support of flexible working, including a mix of office and work from home days depending on your role.
- Frequent events including sports days, annual Christmas party, hackathon, and trivia.
- Free kick-start breakfast every morning and fresh fruit available all day in our offices.
- Casual dress – every day.