What are the responsibilities and job description for the Business Analyst - Strong SQL, Equities/Fixed Income/Derivative position at The Ashlar Group?
Job Title: Business Analyst - Capital Markets/Securities Pricing/SQL
Location: Tampa, FL - Hybrid - 2 Days Onsite
Duration: 12 Months
Job Description:
- Must have strong SQL
- Must be able to read SQL programs not necessary proficient to wrte them. Will be doing alot of work with the LATAM area so needing to understand spanish is required.
- Ideally secruityins pricing is wanted but with the other skills above- it is somethig they will consider training the right person The heavy SQL and Spanish are non negotiable
Purpose Of The Role:
- The Business Analyst will play a key leadership role in the build out, and supporting the Strategic Pricing data platform, which is aiming to create a unified framework and aligned operational processes to ensure Client’s regulatory obligations are met and sustainable going forward - across and it impacts Client’s Business and regional regulators.
- The ideal candidate must have a deep understanding of database design, SQL, and mastery of data analytic skillsets in both qualitative and quantitative against large and complex data structure.
- Focus on Market Pricing Data (Equities, Fixed Income, Derivative Instruments) supporting Front, Middle and Backoffice applications with a understand on lifecycle of trade and reporting.
- The candidate will also work independently to ensure successful delivery.
Key Responsibilities:
- Design and drive execution of accurate and reliable database / application modeling.
- Ability to perform analysis on datasets to determine their quality, coverage, complexity
- Normalize disparate data sets into a common logical model
- Independently query data from multiple relational databases for analysis
- Work directly with Technology, Operations, Legal and Business partners to successfully deliver complex projects leveraging our enterprise reference data platform
- Create BRD/FRD translating business logic into functional requirements
- Communicate business concepts and expected functional behavior to Developers and other stakeholders
- Create comprehensive use cases for testing
- Provide guidance to the local teams on technical challenges and client communication
- Project management, implementation and testing plans
Candidate Qualifications:
- Strong database design and modeling knowledge, deep understanding of data integrity and normalization
- Mastery level SQL knowledge with minimum of 2 years of hands on experience, ability to run analysis and complex SQLs against large sets of data is a must. Preferably experience with Oracle DBMS.
- 4 year Bachelor’s degree or higher in one of the science majors is ideal
- Experience managing the full project cycle for complex business deliverables – including translating client logic into functional requirements, writing FRDs/BRDs, working with the technology teams to ensure accurate implementation, and partner with business for user acceptance testing and production go-live.
- Experience with Pricing and/or securities reference data background in capital markets is a plus
- Technically proficient in Microsoft Office Suite
- Capable of managing multiple tasks under tight deadlines
Global Research, Economics, Fixed Income and FX Strategy, Analyst/Associate
JPMorgan Chase -
Sydney, FL
Technical Business Lead Analyst (SQL) - TAMPA - Hybrid
Citi -
Tampa, FL
Senior Technology Business Analyst (SQL) - AVP
Citi -
Tampa, FL