Citi Group Solution Architect 

Canada, Ontario 

479721287

• The Solution Architect 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 tosimplify/rationalize/refactorthe 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, PISMO
• Liaise closely with Product Owners to translate the User Stories to well-defined Technical requirements and solutions

• 5-8 years relevant industry experience
• 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.
• Extensive experience with Data Integration patterns.
• Extensive experience with Real/Near Real time streaming patterns.
• Strong background in Data Management, Data Governance, Transformation initiatives preferred.
• PreferredExperience/Familiaritywith one or more of these tools
  • Big data platforms - Hadoop, Apache Kafka
  • Relational SQL, NoSQL, and Cloud Native databases - Postgres, Cassandra, Snowflake
  • Experience with data pipeline and orchestration tools - Azkaban, Luigi, or Airflow
  • Experience with stream-processing engines - Apache Spark, Apache Storm, or Apache Flink
  • Experience with ETL tools - Talend, Ab Initio
  • Experience with DataAnalytics/visualizationtools - Looker, Mode, or Tableau

Time Type:

View the " " poster. View the .

View the .

View the