Business Data Analyst – Sql (Hybrid)

Job Id: 23651106

Organization & Department Overview

The Securities Master Central (SMC) is responsible for providing authoritative sources of securities indicative data to our clients across the organization, through implementing state of the art technologies and operational processes which promote the collection, storage, analysis, and distribution of product, pricing, account and corporate action data. SMC BA team is tasked with the enhancement to the system including integration of vendor feeds, data model enhancement and updates to existing data from vendors. This may involve analyzing multiple data sets manually or engineering automated solutions. The overall objective of this role is to understand business needs & conduct data analysis

:

• Reverse engineering functional specifications from data
• Conduct Systems Integrated Testing (SIT) and User Acceptance Testing (UAT)
• Data Analysis for complex system
• Create Function Specification Documents (FSD), System Requirement Specification (SRS), and test plans
• Work closely with End Users/Clients to understand Business Process/Industry Standards/Regulatory Mandate requirements.
• Able to execute projects Independently
• Financial Data Modeling Capabilities
• Work closely with IT and Operations partners
• Work with external data vendors (i.e., Bloomberg, Reuters, IDC, Markit, etc) and standards organizations

Qualifications:

• Ability to focus on high quality work while under pressure
• Strong SQL knowledge required (able to query data, analyze and troubleshooting)
• Must possess good communication skills with the ability to be assertive
• Strong analytical skills and writing skills, to include solid experience in writing functional and technical specifications
• Experience utilizing various SDLC methodologies like Waterfall, Agile (JIRA etc.)
• Strong background in financial reference data and capital markets
• Comprehensive knowledge of the Testing Lifecycle with SIT, UAT, and Production.
• Strong Data analysis and Mapping skill
• Working experience of [3] years min. as Business Analyst
• College degree, specialized training or equivalent work experience
• Data Oriented with an excellent attention to detail
• Experience/understanding of business process reengineering and business modeling concepts, systems development lifecycle

Preferred Skills

• Project lead experience
• Experience working with major vendor data providers (i.e., Bloomberg, Reuters, IDC, Markit)
• Experience with vendor product implementation
• Knowledge of MS Excel, Visio
• Experience working closely with IT Project managers and development teams

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:

Technology

-------------------------------------------------

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.

View the "EEO is the Law" poster. View the EEO is the Law Supplement.

View the EEO Policy Statement.

View the Pay Transparency Posting