Capital Markets BA with SQL (VP) Job at Open Systems Technologies, Irving, TX

dCtpMnZjRmx0azFkMW5mMGlqaXBCdVhyNkE9PQ==
  • Open Systems Technologies
  • Irving, TX

Job Description

General Feedback: We need a Senior BA with good capital markets understanding and strong SQL/Data Analysis experience.

Need good understanding of capital markets, strong SQL knowledge/skills

50% of work is around SQL, so it's an absolute must that they are at least a 7/10 in SQL (don't want to have to teach this to someone)

Not looking for Ops or PM work, looking for core tech BA that has worked 8-10 years in project execution

Leadership experience would be a plus

Need someone with strong financial knowledge and BA background, and more stable with less frequent job changes

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

Job Description:

· Financial Data Modeling Capabilities

· 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

· Mentor and coaching lower level analysts

Qualifications:

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

· Strong background in financial reference data and capital markets

· Strong SQL knowledge required (able to query data, analyze and troubleshooting)

· Strong Data analysis and Mapping skill

· 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

· Strong analytical skills and writing skills, to include solid 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

· Experience working with major vendor data providers (i.e., Bloomberg, Reuters, IDC,

Markit)

· Project lead experience

· Experience working closely with IT Project managers and development teams

· Knowledge of MS Excel, Visio

· Experience with vendor product implementation

Job Tags

Work experience placement,

Similar Jobs

University of Maryland School of Medicine

Neonatal Nurse Practitioner Job at University of Maryland School of Medicine

 ...The University of Maryland School of Medicine (UMSOM) is seeking a Board-Certified Neonatal Nurse Practitioner (NNP) to join its neonatal practice at UM Capital Region Health in Largo, Maryland. This is an excellent opportunity to work within a Level III NICU alongside... 

Teva Pharmaceutical Industries Ltd.

Pharmazeut im Praktikum (m/w/d) Pharmacovigilance Job at Teva Pharmaceutical Industries Ltd.

Beginn Mai/Juni 2026 oder auf Anfrage, Dauer 6 Monate ber Teva Teva ist ein global agierender Arzneimittelkonzern und Weltmarktfhrer unter den Generikaunternehmen. Das Herzstck unseres Erfolges sind unsere Mitarbeiter in ber 80 Lndern weltweit. Sie sorgen daf...

Westminster

Maintenance Manager Job at Westminster

 ...lovely grounds featuring mature shade trees, playground, and picnic center complete with gazebo. Join Our Team as a Property Maintenance Manager Lead the Way in Property Maintenance! Are you ready to make a real impact and showcase your leadership skills in property... 

Onward Search Education

School Social Worker [80358] Job at Onward Search Education

 ...exceptional school district in Van Buren County, MI, to hire a full-time School Social Worker for the 20252026 school year. In this in-person role, the School Social Worker will work to improve the success of students with disabilities in school through service and... 

V Group Inc.

Lead Java Developer Job at V Group Inc.

 ...~60 months experience developing, implementing and integrating systems related to criminal justice processing at the state or federal level (including but not limited to: disposition processing, fingerprint identification processing, criminal history updating)....