Regulatory Data Developer

As a Regulatory Data Developer, you will play a key role in creating, migrating, and maintaining regulatory reporting systems on Google Cloud Platform (GCP). The Regulatory Data team is a crucial function of the Data Engineering department, responsible for building and maintaining near real-time and batch reporting systems to fulfil regulatory requirements. The team utilises complex Business logic to transform internal data models into those required by industry regulators and third parties. Using your passion for delivering innovative solutions you will support our continued migration from on-premise SQL Server systems to GCP as the team creates new GCP reporting systems. You will support this migration while also developing new cloud-native solutions and exploring AI-driven development and automation to improve efficiency, consistency and reliability across the team's processes. Developing and maintaining regulatory data submission systems, both existing on-premise and new cloud-based solutions in GCP/BigQuery. Building and maintaining automated data pipelines for ingestion, transformation, and loading of regulatory data. Supporting the migration of legacy SQL Server solutions to BigQuery, working closely with seniors and technical leads on architecture and data modelling. Implementing data validation, monitoring, and alerting to ensure accuracy, consistency, and reliability of regulatory submissions. Leveraging AI tooling, such as Claude Code, and contributing to the team's automation strategies to reduce manual effort and improve quality. Participating in code reviews and adhere to departmental standards and the development process. Conducting QA to ensure solutions are accurate, efficient, and performant. Creating and maintaining relevant documentation. Collaborating with other team members to deliver high-quality solutions within required timeframes.

Experience with Google BigQuery. SQL development experience, with the ability to write complex queries, stored procedures, and performance-tune data-intensive workloads. Familiarity with GCP services such as Cloud Storage, Cloud Functions, Pub/Sub, or Cloud Composer. Experience with data pipeline development (ETL/ELT) and orchestration tooling. Exposure to Infrastructure as Code such as Terraform, and CI/CD pipelines such as Git, GitLab. Methodical, with high attention to detail and the ability to break down complex requirements into simple solutions. Interest in AI-assisted development tooling, such as Claude Code. Ability to work to deadlines in a fast-paced, reactive environment. SQL Server experience to support legacy systems during migration.