GCP Senior Technical Specialist

Job Summary

The Senior Technical Specialist will be responsible for implementing and optimizing solutions using Google Big Query, SQL, Python, Google Dataflow, and CA Erwin Data Modeler. The role entails working on data transformations, analytics, and modeling to provide valuable insights to the organization.

Key Responsibilities

1. Design, develop, and maintain google bigquery data pipelines for efficient data processing.
2. Utilize sql for querying and analyzing large datasets in google bigquery.
3. Develop and implement python scripts for automation and data manipulation tasks.
4. Create and optimize data processing pipelines using google dataflow.
5. Collaborate with stakeholders to understand data modeling requirements and utilize ca erwin data modeler for effective data modeling.
6. Monitor data quality, troubleshoot issues, and ensure data integrity across systems.
7. Stay updated with the latest technological advancements in data analytics and contribute to process improvements.

Skill Requirements

P1 – Critical / Must‑Have Skills

Strong experience in conceptual, logical, and physical data modelling

Solid Markets domain knowledge (trades, instruments, lifecycle events, reference data)

Proven experience designing data models for data products (not single systems)

Ownership of entity definitions, relationships, keys, and constraints

Experience with enterprise data modelling tools (IDERA ER/Studio and/or ERwin)

Ability to translate business concepts into robust data structures

Strong understanding of data governance, lineage, and auditability

Ability to collaborate effectively with data engineers and SMEs

Clear communication of modelling decisions and trade‑offs

P2 – Important / Value‑Adding Skills

Experience modelling regulatory or surveillance data (e.g. Market Abuse)

Practical experience designing Big Query‑optimised schemas, including:

Denormalisation patterns

Partitioning and clustering

Cost/performance trade‑offs

Experience aligning models to ODP / FDP / CDP layering

Familiarity with ISDA Common Domain Model (CDM)

Experience working in cloud‑native data platforms (GCP)

Ability to define and enforce modelling standards and naming conventions

Supporting impact analysis and controlled model evolution

P3 – Desirable / Differentiating Skills

Deep hands‑on experience applying ISDA CDM in real implementations

Experience influencing or shaping enterprise data modelling standards

Exposure to data cataloguing, lineage, or governance tooling

Experience mentoring or reviewing models created by others

Ability to challenge requirements that lead to unnecessary complexity

Strong experience balancing operational vs analytical modelling needs

Prior work in large‑scale transformation or strategic programmes

Other Requirements

1.Relevant certifications in Google Big Query, SQL, Python, Google Dataflow, or CA Erwin Data Modeler would be a plus.