Data Analyst

Overview of the Role:

Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments, and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management.

As a bank with a brain and a soul, Citi creates economic value that is systemically responsible and in our clients’ best interests. As a financial institution that touches every region of the world and every sector that shapes your daily life, our Enterprise Operations & Technology teams are charged with a mission that rivals any large tech company. Our technology solutions are the foundations of everything we do from keeping the bank safe, managing global resources, and providing the technical tools our workers need to be successful to designing our digital architecture and ensuring our platforms provide a first-class customer experience. We reimagine client and partner experiences to deliver excellence through secure, reliable, and efficient services.

Our commitment to diversity includes a workforce that represents the clients we serve from all walks of life, backgrounds, and origins. We foster an environment where the best people want to work. We value and demand respect for others, promote individuals based on merit, and ensure opportunities for personal development are widely available to all. Ideal candidates are innovators with well-rounded backgrounds who bring their authentic selves to work and complement our culture of delivering results with pride. If you are a problem solver who seeks passion in your work, come join us. We’ll enable growth and progress together.

The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.

Responsibilities:

• Contribute to full development life cycle, including requirements analysis, functional design, technical design, programming, testing, documentation, implementation, and on-going technical support.

• Contribute to projects/CR’s utilizing Ab-Initio (ETL), Python, Oracle SQL/PLSQL, Snowflake and Cloud Technologies.
• Ability and willingness to learn newer tools and technologies in cloud-based data analytics/Artificial intelligence arena and successfully deliver projects utilizing the same.
• Expected to provide sound understanding of application development concepts / principles and a basic knowledge of concepts and principles in other technology areas.
• Expected to Develop/Modify/Test/Migrate Reports using IFW Application.
• Expected to Develop/Modify/Test/Migrate Python,Starburst  Framework.
• Support application builds and migrations with new technologies, architecture and integration.
• Expected to clearly articulate development and timeline dependencies.
• Improve team development related processes that accelerate delivery, drive innovation, lower costs, and improve quality.

Knowledge/Experience:

BE or equivalent undergraduate degree. 5+ year of Industry experience working in Finance reporting applications/warehouses. 3+ years of Development experience on Oracle, Data mining tools, Data intelligence tool . Strong knowledge of Oracle Database, SQL/Performance tuning, understanding of the Relational Data Modal. Exposure to data modelling concepts is required. Prior working experience with Citi Financial system (Specially General Ledgers) is a Big PLUS Prior working knowledge on Inquiry framework. Prior experience with Citi tool – Inquiry Framework is a big PLUS Knowledge of the Snowflake and S3 Buckets is plus and is preferred. Experience in production support and troubleshooting issues Experience in Process optimization – SQL, ETL etc.

Skills:

Comfortable with Oracle SQL and SQL tuning. Comfortable with multiple database concepts, i.e. RDBMS, OODB, ODS, Warehouse. Hands on with tools like, Oracle PL/SQL, Python, Snowflake, Autosys Scheduling, Bitbucket, Jenkins, RLM, Unix Shell Scripting and Apache Spark, Starburst,Tableau. Exposure to GenAI tools for deriving data intelligence. Prior experience of working with multiple teams (local, virtual/global) and ability to coordinate track and expedite tasks. Ability to pick up ne