Postgres Data Architect

Job Details Role /

Job Title:

Postgres Data Architect with CDC Skills

Work Location:

250 Bishopsgate, London, UK Office Presence (Hybrid): 2 days per week

The Role Postgre

SQL Data Architect with strong hands-on experience in Change Data Capture (CDC). The candidate will design and implement robust data migration strategies, ensuring seamless integration between legacy systems and modern cloud-based architectures. Responsibilities Architect CDC Pipelines:
Design and optimize Change Data Capture workflows (IBM CDC or equivalent), including subscription design, bookmarks, resync, and replay strategies Cloud Migration & Hosting:
Lead Postgre

SQL migration from on-premises/mainframe to cloud platforms (AWS Aurora preferred), ensuring performance, security, and scalability Integration & ETL Pipelines:
Build robust pipelines using CDC Kafka/S3 Aurora with UPSERT/MERGE patterns; guarantee idempotency, ordering, and reliable delivery Data Encoding & Validation:
Manage EBCDIC UTF-8 conversions, packed decimal/binary numeric, and validate transformations with automated test suites Cutover & Governance:
Execute dual-run validations, reconciliation (counts, checksums), rollback strategies, and ensure compliance with masking, encryption, and IAM policies Performance & Observability:
Monitor lag, throughput, and error rates; develop dashboards (Cloud Watch/Grafana) and operational runbooks for proactive alerting Automation & Tooling:
Utilize schema conversion tools, IaC (Terraform), CI/CD pipelines (Git Lab), and AWS services (Glue, Athena, Redshift) for downstream analytics Data Modelling & Conversion (Good to have):
Transform Db2 schemas to Aurora Postgre

SQL; design logical/physical models, enforce referential integrity, and apply best practices for normalization/denormalization Your Profile Essential Skills / Knowledge / Experience Strong hands-on experience with Postgre

SQL (Aurora preferred) and advanced data modelling Expertise in CDC tools (IBM CDC or similar) and data migration strategies Proven experience in Postgre

SQL cloud hosting and migration Proficiency in ETL/ELT pipelines, Kafka, and AWS ecosystem Solid understanding of data encoding, transformation, and validation techniques Familiarity with IaC, CI/CD, and observability frameworks Excellent problem-solving and communication skills Desirable Skills / Knowledge / Experience Mainframe Modernization