Apps Dev Programmer Analyst 2

Citigroup Inc.; Tampa (FL); On-site; USD 85,000 - 115,000; Full time

Job summary

A global financial services company in Tampa is seeking an Applications Development Programmer Analyst to support the development and implementation of application systems. Candidates should have over 4 years of experience in Finance reporting applications, strong skills in Oracle SQL and Python, and the ability to work in a collaborative environment. This role includes contributing to the full development lifecycle and optimizing processes while adapting to new technologies.

Qualifications

• 4+ years in Finance reporting applications.
• 2+ years on Oracle and data mining tools.
• Strong knowledge of SQL and performance tuning.

Responsibilities

• Contribute to the full development lifecycle.
• Support application builds and migrations.
• Provide insights on development timelines.

Skills

Oracle SQL

Python

Snowflake

ETL

Data intelligence tools

Unix Shell Scripting

Apache Spark

Tableau

Education

Bachelor’s degree or equivalent experience

Tools

Ab-Initio

Autosys Scheduling

Bitbucket

Jenkins

Starburst Framework

Job description

Overview

The Applications Development 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/CRs utilizing Ab-Initio (ETL), Python, Oracle SQL/PLSQL, Snowflake and Cloud Technologies.
• Learn newer tools and technologies in cloud-based data analytics/Artificial intelligence arena and successfully deliver projects utilizing the same.
• Provide sound understanding of application development concepts/principles and a basic knowledge of concepts and principles in other technology areas. Develop/Modify/Test/Migrate Reports.
• Develop/Modify/Test/Migrate Python, Starburst Framework. Support application builds and migrations with new technologies, architecture and integration.
• Clearly articulate development and timeline dependencies. Improve team development related processes that accelerate delivery, drive innovation, lower costs, and improve quality.

Qualifications

• 4+ years of industry experience working in Finance reporting applications/warehouses.
• 2+ years of development experience on Oracle, data mining tools, and data intelligence tools.
• Strong knowledge of Oracle Database, SQL/Performance tuning, and understanding of the relational data model.
• Exposure to data modelling concepts is required.
• Prior working experience with Citi Financial system (especially General Ledgers) is a plus.
• Prior working knowledge on Inquiry framework.
• Prior experience with Citi tool – Inquiry Framework is a plus.
• Knowledge of Snowflake and S3 Buckets 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 Oracle PL/SQL, Python, Snowflake, Autosys Scheduling, Bitbucket, Jenkins, Unix Shell Scripting, Apache Spark, Starburst, Tableau.
• Exposure to GenAI tools for deriving data intelligence. Ability to coordinate across teams and adapt to new technologies and fast-paced environments.
• Ability to work independently as well as in a team environment and adapt to a rapidly changing environment.
• Excellent verbal and written communication skills, strong problem solving and analytical capabilities.

Competencies

• Excellent communication skills and ability to communicate with senior management.
• Self-motivated, a good team player, quick learner, and able to work in a fast-paced, dynamic environment.

Education

• Bachelor’s degree/University degree or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.