Job Description

Role Purpose

We are seeking a highly skilled and experienced Data Architect cum Data Modeler who excels in conceptual, logical, and physical data modeling and has a strong business acumen. The ideal candidate will have a holistic understanding of data architecture, be proficient in relational and non-relational data modeling, and possess the ability to design JSON schemas for real-time events, APIs, and GraphQL specifications. This role requires a critical thinker who can independently connect the dots, drive discussions with business stakeholders, and deliver robust data models that align with organizational goals.  

͏

Key Responsibilities

1. Data Modeling and Architecture:

1. • Design and develop conceptual, logical, and physical data models for relational and non-relational databases.
   • Create and maintain JSON schemas for real-time event processing and API design.
   • Define and design GraphQL schemas to support modern API-driven architectures.
   • Ensure data models align with business requirements and technical constraints.

2. Business Engagement:

2. • Collaborate with business stakeholders to understand requirements and translate them into data models.
   • Drive critical discussions with business teams to ensure data models meet current and future needs.
   • Provide a holistic view of data architecture and its impact on business processes.

3. Data Integration and Mapping:

3. • Perform complex data mapping analysis across multiple data sources and publishing methods (e.g., real-time vs. batch).
   • Define data integration strategies and ensure seamless data flow between systems.

4. Tool Proficiency:

4. • Use data modeling tools such as PowerDesigner, Erwin, or like create and manage data models.
   • Document and maintain metadata for all data models and schemas.

5. Cloud and Modern Architecture:

5. • Leverage knowledge of AWS, Azure, or GCP cloud platforms to design scalable and efficient data architectures.
   • Apply Medallion Architecture principles for data lake and data warehouse design.

6. SQL and Programming:

6. • Write and optimize SQL queries for data analysis and validation.
   • Use PL/SQL for legacy system analysis and migration efforts (preferred).

7. Real-Time and Batch Processing:

7. • Design data pipelines for both real-time and batch data processing.
   • Ensure data models support diverse publishing methods and meet performance requirements.

8. Industry Expertise:

8. • Apply knowledge of the Payment Processing industry to design domain-specific data models.
   • Ensure compliance with industry standards and best practices.

͏

Required Skills and Qualifications

• Degree/Experience

• • Bachelor’s or master’s degree in computer science, Information Systems, or a related field or equivalent years of experience.

• Data Modeling Expertise:

• • Strong experience in conceptual, logical, and physical data modeling.
  • Proficiency in designing schemas for relational databases and non-relational data structures (e.g., JSON, GraphQL).

• Business Acumen:

• • Ability to understand and align data models with business goals.
  • Strong communication skills to drive discussions with business stakeholders.

• Critical Thinking:

• • Ability to independently analyze complex problems and connect the dots across systems and processes.

• SQL Proficiency:

• • Advanced skills in SQL for data analysis, validation, and optimization.

• Data Modeling Tools:

• • Proficiency in tools like PowerDesigner, Erwin, or similar.

• Data Integration:

• • Experience in performing complex mapping analysis across multiple data sources and publishing methods (real-time vs. batch).

• Cloud Knowledge:

• • Familiarity with AWS, Azure, or GCP cloud platforms.

• Preferred Skills:

• • Knowledge of Medallion Architecture for data lake and warehouse design.
  • Experience in the Payment Processing industry.
  • PL/SQL programming skills for legacy system analysis.
  • Familiarity with ETL/ELT processes and modern data integration tools.
  • Experience working in data modelling of real-time event-driven architectures and API design.

͏

Key Attributes

• Critical Thinker: Able to independently analyze and solve complex problems.
• Holistic Vision: Understands the big picture and aligns data architecture with business strategy.
• Self-Starter: Works independently and takes ownership of tasks.
• Collaborative: Effectively engages with business and technical teams to deliver results.

Competencies