Senior Data Modeler - VP - C13 - PUNE

The Applications Development Technology Lead Analyst is a senior level position responsible for establishing and implementing new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to lead applications systems analysis and programming activities.

Responsibilities:

• The Lead Analyst will be responsible for re-engineering the interaction of incoming and outgoing data flows from the Core Accounts DDA platform to Reference Data platforms, Data Warehouse, Data Lake as well as other local reporting systems which consume data from Core Accounts
• Drive the data architecture and roadmap for eliminating non-strategic point to point connections and batch handoffs
• Define canonical data models for key entities and events related to Customer, Account, Core DDA in line with the Data Standards
• Assess opportunities to simplify/rationalize/refactor the existing database schemas paving way for modularization of the existing stack
• Provide technical guidance to Data Engineers responsible for designing an Operational Data Store for intra-day and end-of-day reporting. Implementing data strategies and developing logical and physical data models.
• Formulate efficient approach to rationalize and formulate strategy to migrate reports
• Build and nurture a strong engineering organization to deliver value to internal and external clients
• Acts as SME to senior stakeholders in business, operations, and technology divisions across upstream and downstream Organizations.
• Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users.
• Exposure to Industry Core Banking Platforms is must eg Flexcube
• Liaise closely with Product Owners to translate the User Stories to well-defined technical requirements and solutions

Qualifications

• Significant experience in Data modeling, Data lineage analysis, Operational reporting, preferably in a global organization
• Proven architecture experience in solutioning of horizontally scalable, highly available, highly resilient data distribution platforms
• Proficient in message queuing, stream processing, and highly scalable ‘big data’ data stores.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Experience with Data Integration patterns and with Real/Near Real time streaming patterns.
• Strong background in Data Management, Data Governance, Transformation initiatives preferred.
• Preferred Experience/Familiarity with one or more of these tools
  • Big data platforms - Hadoop, Apache Kafka
  • Relational SQL, NoSQL, and Cloud Native databases - Postgres, Cassandra, Snowflake
  • Experience with ETL tools - Talend, Ab Initio
  • Experience with Data Analytics/visualization tools - Looker, Mode, or Tableau
• 12+ years relevant industry experience

Education:

• Bachelor’s degree/University degree or equivalent experience
• Master’s degree preferred