What are the responsibilities and job description for the Business Analyst position at Panzer Solutions LLC?
Job Title: Business Analyst
Location: Tampa, FL 33610 (ONSITE REQUIREMENT – 2/3 days per week )
JOB DESCRIPTION:
Must have strong SQL and Bilingual (speaking) Spanish.
Must be able to read SQL programs not necessarily proficient to write them. Will be doing a lot of work with the LATAM area so needing to understand Spanish is required.
Ideally secruity ins pricing is wanted but with the other skills above- it is something 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 modelling.
• 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 behaviour 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 modelling 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
• Strong analytical, problem solving and communication skills
• 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
