Core SQL Applications Development Senior Programmer Analyst Assistant Vice President

Citigroup Inc.; Mississauga; On-site; CAD 94,000 - 142,000; Full time

Job summary

A global financial institution is seeking a SQL Applications Development Intermediate Programmer Analyst in Mississauga. The role involves participation in applications systems analysis and programming, with responsibilities including data lineage analysis and data governance initiatives. Candidates should have over 4 years of experience with PL/SQL, Core Java, and strong analytical skills. This position offers a salary range of $94,300 to $141,500, along with additional benefits.

Qualifications

• 4+ years of relevant experience in Applications Development role.
• Experience in data transformation, system integration, or data warehousing.
• Strong analytical and data skills.

Responsibilities

• Perform data lineage analysis, mapping data flow between systems.
• Identify and document physical and logical data elements.
• Analyze existing data models and integration layers.

Skills

PL/SQL

UNIX Shell scripting

Core Java

Data profiling

Data mapping tools

Data lineage analysis

GitHub

Kafka

Education

Bachelor’s degree in Computer Science, Computer Engineering, or Information Technology

Tools

Oracle

Data Warehouse ETL

Job description

Overview

The SQL 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. We’re seeking a highly motivated analyst with strong analytical and data skills to support end-to-end system mapping, critical data element identification, lead requirements gathering, design and development across multiple technology platforms.

Responsibilities

• Perform data lineage analysis, mapping data flow between systems (source to target).
• Identify and document physical and logical data elements, including Critical Data Elements (CDEs) per regulatory or business criteria.
• Analyze existing data models, source systems, and integration layers to extract metadata.
• Actively contribute to data governance initiatives.

Qualifications

• 4+ years of relevant experience in Applications Development role
• 4+ years with the following: Languages/Frameworks: PL/SQL, UNIX Shell scripting, Core Java
• 4+ years experience and proficiency in Java, SQL, data profiling, and data mapping tools.
• 3+ years experience and understanding of logical and physical data models, data dictionaries, and metadata management.
• Experience working on projects involving data transformation, system integration, or data warehousing.
• Excellent communication skills with the ability to bridge between technical and non-technical stakeholders.
• Business knowledge of Financial Markets, Trading, Middle Office and Back Office function.
• Knowledge of GitHub/Version Control Systems, Kafka.
• Demonstrated problem-solving and decision-making skills; ability to work under pressure and manage deadlines or changing requirements.
• Experience in the Financial Services industry is preferred.

Education

• Bachelor’s degree/University degree in Computer Science, Computer Engineering, Information Technology 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.

Job Family Group: Technology

Job Family: Applications Development

Time Type: Full time

Primary Location / Salary Range: $94,300.00 - $141,500.00

Most Relevant Skills

Please see the requirements listed above.

Other Relevant Skills

Data Modeling, Data Warehouse ETL, Data Warehousing (DW), Oracle, Scripting, Structured Query Language (SQL).

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. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity, please review accessibility options.