API Engineering

Job Title: Data Analyst – API & Data Lake
Job Overview
We are looking for a Data Analyst with strong 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.
Good 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.
Strong understanding of banking/financial data, particularly commercial banking.

Work arrangement
No