Lead a 3-month assessment of a PostgreSQL (PSI) database environment (Impact and Qlikview/Qliksense scope), define the target architecture, and drive the migration strategy toward the SCIB Data Lake aligning with the bank data governance standards.
Main responsibilities
AS IS assessment
- Comprehensive analysis of the existing PostgreSQL environment
- Document schemas, tables, relationships, constraints, triggers, and stored proceduresIdentify data producers, ETL processes, and upstream source systems
Target architecture (TO BE) & migration strategy
- Work with global CTO to define the target structure on SCIB Data Lake
Align design with the Bank data governance standards
-Define migration roadmap, rollback plan, phases, and timelin
Requirements
- +7 years of experience with Data
- Experience as a Data Architect
- Advaced SQL
- Data base migration
- Strong architecture + hands-on backend development profile
- Backend focus — no frontend-only profile
- CTE, query tuning, indexing, execution plans
- English fully fluent required
What we offer:
- 100% Remote opportunity
- Payment in USD
- Modality of contract: Contractor