Job Title: Data Analyst – API & Data Lake
Job Overview We are looking for a Data Analyst with robust experience in data analysis, data lake environments, Spark, MongoDB, APIs, and reporting. The resource should have a good understanding of commercial banking data structures and the ability to analyze data across multiple banking domains, including Mainframe, CCM, Payments, Cards, Deposits, and Lending.
Key Responsibilities Analyze and interpret data within the
Citizens Data Lake
environment. Understand and work with data structures across various commercial banking systems. Perform data analysis using
Apache Spark
and
MongoDB . Work with
APIs
to extract, integrate, and validate data from different systems. Develop and maintain data reports and provide meaningful insights to business stakeholders. Understand data relationships and mappings between different source systems. Analyze data corresponding to: Mainframe CCM Payments – ACH, FED,



etc. Cards Deposits Lending Perform data validation, reconciliation, and troubleshooting across different data sources. Collaborate with technical and business teams to understand data requirements and resolve data-related issues.
Required Skills Strong
Data Analysis
experience. Understanding of
Data Lake
architecture and data structures. Hands-on experience with
Apache Spark . Experience with
MongoDB
or similar NoSQL databases. Positive understanding of
REST APIs / API-based data integration . Experience in
reporting and data analysis . Strong SQL and data querying skills. Ability to understand complex data structures and relationships. Solid understanding of
banking/financial data , particularly commercial banking.

📌 Api Engineering Hyderabad (India)
🏢 Blue Spire
📍 India