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. They use complex business logic to transform internal data models into those required by industry regulators and third parties. You will support the migration from on‑premise SQL Server systems to GCP as the team creates new GCP reporting systems, develop new cloud‑native solutions, and explore AI‑driven development and automation to improve team processes.
Main Responsibilities
* Experience with Google BigQuery.
* SQL development experience, including writing complex queries, stored procedures, and performance‑tuning data‑intensive workloads.
* Familiarity with GCP services such as Cloud Storage, Cloud Functions, Pub/Sub, and 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 and 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.
Qualifications and Skills
* 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 adhering 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 deadlines.
#J-18808-Ljbffr