Data Architect

Required Skills & Experience

• 8+ years of experience in data architecture across OLTP and analytical systems.
• Deep hands-on expertise in AWS Aurora PostgreSQL and RDS PostgreSQL.
• Deep hands-on experience in AWS IAM, PostgreSQL role, and setup integration between the both.
• Understanding with IBM DB2 (LUW or z/OS) including schema design.
• Proven experience designing and implementing ODS and data warehouses (Snowflake, Redshift, etc.).
• Strong SQL, ETL architecture, and data integration experience.
• Familiarity with data warehousing principles, slowly changing dimensions, and dimensional modeling (Kimball/Inmon).
• Hands-on with AWS data services: DMS, Glue, S3, Lambda, CloudWatch.
• Knowledge of data governance, data quality, and compliance practices.

Key responsibilities

• Design end-to-end data architecture supporting OLTP systems, ODS layers, and downstream data warehouses.
• Architect ODS solutions to serve as a bridge between real-time transactional systems and analytical platforms.
• Develop and optimize relational data models in PostgreSQL and DB2 aligned to business needs.
• Define data modeling standards, schema designs, and partitioning/indexing strategies for transactional and ODS workloads.
• Implement & maintain data dictionary , ensure data lineage & traceability.
• Ensure data consistency, normalization, and integrity across heterogeneous systems.
• Collaborate with business, data engineering, and analytics teams to align OLTP and ODS architecture.