Experience Inc. Jobs

Job Information

Citigroup Senior IT Business Analyst (SQL, Finance) in Mississauga, Ontario

Senior Business Analyst in Securities Reference data with Capital Markets and SQL knowledge.

Job Description:

• Financial Data Modeling Capabilities

• Strong SQL knowledge required

• Data Analysis for complex system

• Reverse engineering functional specifications from data

• Work closely with End Users/Clients to understand Business Process/Industry Standards/Regulatory Mandate requirements.

• Work closely with IT and Operations partners

• Work with external data vendors (i.e., Bloomberg, Reuters, IDC, Markit, etc) and standards organizations

• Able to execute projects Independently

• Conduct Systems Integrated Testing (SIT) and User Acceptance Testing (UAT)

• Create Function Specification Documents (FSD), System Requirement Specification (SRS), and test plans


• Working experience of [8] years min. as Business Analyst

• Strong background in financial reference/indicative data and capital markets

• SQL knowledge (able to query data, analyze and troubleshooting)

• Strong Data analysis and Mapping skills (able to query data, analyze and map)

• Data Oriented with an excellent attention to detail

• Experience/understanding of business process reengineering and business modeling concepts, systems development lifecycle

• Strong analytical skills and writing skills with experience in writing functional and technical specifications

• Must possess good communication skills with the ability to be assertive

• Ability to focus on high quality work while under pressure

• Experience utilizing various SDLC methodologies like Waterfall, Agile (JIRA etc.)

• Comprehensive knowledge of the Testing Lifecycle with SIT, UAT, and Production.

Preferred Skills/Experienceualifications

• Experience working with major vendor data providers (i.e., Bloomberg, Reuters, IDC, Markit)

• Experience with vendor product implementation

• Project lead experience

• Experience working closely with IT Project managers and development teams

• Knowledge of MS Excel, Visio


• College degree, specialized training or equivalent work experience

Citi Canada is an equal opportunity employer. Accordingly, we will make accommodations to respond to the needs of people with disabilities (including, without limitation, physical and mental health disabilities) during the recruitment process and otherwise in accordance with law. Individuals who view themselves as Aboriginals, members of visible minority or racialized communities, and people with disabilities are encouraged to apply.

Job Family Group:


Job Family:

Applications Development

Time Type:

Full time

Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries ("Citi”) invite all qualified interested applicants to apply for career opportunities. 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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm) .

View the "EEO is the Law (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf) " poster. View the EEO is the Law Supplement (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf) .

View the EEO Policy Statement (http://citi.com/citi/diversity/assets/pdf/eeo_aa_policy.pdf) .

View the Pay Transparency Posting (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf)

Citi is an equal opportunity and affirmative action employer.

Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.