Job Summary
The Senior Technical Specialist will be responsible for implementing and optimizing solutions using Google BigQuery, 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 BigQuery‑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