Core SQL Applications Development Senior Programmer Analyst Assistant Vice President

CITI; Mississauga; On-site; CAD 130,000 - 196,000; Full time

Job summary

A leading financial services provider is seeking an SQL Applications Development Intermediate Programmer Analyst in Mississauga. The role requires extensive experience in applications development, strong analytical skills, and knowledge of financial markets. You will contribute to data governance and perform data lineage analysis among other responsibilities. A bachelor's degree in Computer Science or equivalent experience is essential.

Qualifications

• 4+ years of experience in Applications Development role.
• Strong analytical and data skills required.
• Excellent written and verbal communication abilities.

Responsibilities

• Perform data lineage analysis and documentation.
• Analyze existing data models and systems.
• Contribute to data governance initiatives.

Skills

PL/SQL

UNIX Shell scripting

Core Java

Data profiling

Data mapping tools

Data governance

Financial Markets knowledge

GitHub/Version Control Systems

Kafka

Education

Bachelor’s degree in Computer Science or equivalent

Job description

Job Description

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: Languages/Frameworks: PL/SQL, UNIX Shell scripting, Core Java
• 4+ years of experience and proficiency in Java, SQL, data profiling, and data mapping tools
• 3+ years of 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
• Consistently demonstrates clear and concise written and verbal communication
• Demonstrated problem-solving and decision-making skills
• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements
• Experience in the Financial Service 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 Details

Job Family Group: Technology

Job Family: Applications Development

Time Type: Full time

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

Most Relevant Skills

Please see the requirements listed above.

Other Relevant Skills

Data Mapping, Data Modeling, Data Warehousing (DW), Structured Query Language (SQL).

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their 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 review Accessibility at Citi. View Citi’s EEO Policy Statement and the Know Your Rights poster.