Engineering-L2 Associate-Software Engineering

As a Data Engineer in the Lakehouse and AI Data Platform team, you will design, build, test and support data pipelines and curated datasets on the firm s modern data platform. You will work across ingestion, transformation, modelling, optimisation and data quality, helping to deliver data products that are reliable, scalable and fit for purpose. Where there are gaps in platform functionality, you may also contribute to shared tooling or framework components that improve how the platform is used and operated.

The role is suited to engineers who are comfortable writing code, working with SQL and distributed data processing, and solving practical delivery problems in a team environment. More experienced candidates may also contribute to technical design, platform standards and the shaping of delivery approaches across a wider set of use cases.

Key Responsibilities

Pipeline Engineering

• Build, enhance and support batch and streaming data pipelines on the Lakehouse and AI data platform.
• Refactor or modernise existing data flows where needed to improve reliability, performance and maintainability.
• Where needed, build reusable tooling to improve delivery, consistency and operational support.
• Ensure data pipelines are production-ready, well tested and operationally supportable.

Data Modelling and Curation

• Develop raw, refined and curated datasets that support analytics, reporting and AI use cases.
• Apply sound data modelling principles to represent business entities, relationships and historical change accurately.
• Work with consumers to shape data products that are usable, well documented and aligned to business needs.

Data Quality and Reconciliation

• Implement controls to validate completeness, accuracy and consistency of data across pipelines and datasets.
• Use reconciliation approaches to build confidence in production outputs and investigate breaks where they arise.
• Contribute to clear standards for testing, monitoring and issue resolution.
• Contribute to practical improvements in testing, monitoring or reconciliation tooling where these strengthen platform reliability and day-to-day delivery.

Skills and Experience

Required

• 3+ years of experience
• Bachelor s or master s degree in a relevant discipline, or equivalent practical experience, with evidence of strong quantitative skills or data engineering expertise.
• Strong hands-on programming experience in Python or Java .
• Good working knowledge of SQL , including troubleshooting, optimization and data analysis.
• Ability to learn new tools, internal platforms and delivery workflows quickly.
• Familiarity with software engineering fundamentals, including version control, testing, release discipline and CI/CD practices.

Data Engineering Capability

• Understanding of temporal data modelling, including the handling of historical state and change over time.
• Knowledge of schema design, schema evolution and data compatibility considerations.
• Understanding of partitioning, clustering and other techniques used to improve data performance at scale.
• Ability to make sensible design choices across normalized and denormalized models, and between natural and surrogate keys.
• Practical approach to data quality, reconciliation and root-cause analysis.
• Experience building or supporting production data pipelines in a collaborative engineering environment.
• Experience working with distributed data processing frameworks such as Apache Spark .
• Working knowledge of common data formats such as JSON , Avro and Parquet .
• Stronger ownership of technical design across multiple datasets or pipeline domains.
• Experience guiding implementation standards, code quality and engineering practices within a team.
• Ability to lead delivery for a workstream, manage dependencies and support less experienced engineers.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.