Lead Business Analyst, Technology

Raymond James, Inc.; Florida; On-site; USD 125,000 - 169,000; Full time

Job summary

Raymond James is seeking a Lead Business Analyst, Technology in Saint Petersburg, FL. You will liaise with business SMEs to define BRDs and design functional/technical specifications for regulatory reporting and credit risk management, while guiding data flows and analytics across OFSAA and related platforms.

The role requires 5+ years in IT with finance experience, strong Oracle SQL, ETL and data governance skills, and a hybrid work model with some travel.

Qualifications

• Bachelor’s degree in a related field with strong IT/finance alignment.
• 5+ years in IT with development, regulatory reporting or credit risk focus.
• Experience with OFSAA, FSDF, OAS and data integration tools.
• Proficient Oracle SQL, AWS Redshift, ETL concepts and ODI.

Responsibilities

• Liaise with Business SMEs to elaborate requirements and define BRDs.
• Define Functional Specifications and Technical Design Documents.
• Design Use Cases, Data Flows, dashboards to meet business needs.
• Profile data using Oracle SQL, MS SQL, or Redshift for sourcing needs.
• Support SIT/UAT and assist in release processes in SDLC.

Skills

BRD development

Business requirements gathering

Regulatory reporting

Credit risk analysis

Education

Bachelor’s degree in Business Administration, MIS, CS or related

Tools

OFSAA

Oracle SQL

AWS Redshift

ODI

Ab Initio MDM

PeopleSoft

Financial Application Hub

One Stream

AXIOM

OAS

FSDF

OFSAA GL

OFSAA LLFP

OFSAA Data Quality Framework

Control-M

ServiceNow

Excel

Job description

## Lead Business Analyst, TechnologyApply: Saint Petersburg, Florida - United States: Full time: Posted Today: R-0013216**Job Description Summary****Job Description****Lead Business Analyst, Technology** **DUTIES:** * Liaise with the Business SMEs to elaborate on business requirements for regulatory reporting and credit risk management and Define Business Requirement Documents (BRDs) for functional and nonfunctional requirements.* Define Functional Specification and Technical Design Documents to break down requirements in Technology requirements.* Design Use Cases, Flow Charts, Data Flow Diagrams and Dash Boards to meet business requirements.* Analyze and profile data using Oracle SQL Developer, MS SQL Server or AWS Redshift based on the source of data to develop strategies to suffice the data sourcing needs.* Define logical database design, fact/dimension table structure, reporting process metadata, and ETL (Extract, Transform and Load) processes.* Define system strategy, develop system requirements, design prototypes and support technology solution implementations to achieve seamless data integration between various financial applications (Peoplesoft, Financial Application Hub, One Stream, AXIOM) to use Oracle Financial Services Analytical Applications (OFSAA) as Financial Datawarehouse.* Analyze Oracle Financial Services Analytical Applications (OFSAA) standard business rules and functionalities and perform fit-gap analysis to align to the functional and non-functional business requirements.* Define data quality rules, data governance standards and Master Data Management (using Ab Initio) through data sourcing to processing to reporting.* Analyze data elements needed for reporting and define data mapping and data lineage documents to map source system data (key data attributes and dimensions) to the Financial Services Data Foundation (FSDF) standard data model.* Responsible for working with Oracle to raise Service Request for any custom data attribute change in data model.* Assess current state lineage and business rules to identify necessary changes and customizations on standard OAS (Oracle Analytics Server) configurations to align better to the reporting requirements.* Support with analysis of OFSAA General Ledger (GL) Reconciliation Framework and configure reconciliation business rules to perform reconciliation between enterprise operational and GL systems data.* Support the analysis of standard OFSAA LLFP (Loan Loss Forecasting and Provisioning) application and configure business metadata, data transformation and business rules for data processing.* Support the System Integration Test (SIT) and User acceptance test (UAT) to help access the requirement coverage of test cases to identify and log defects and propose corrective measures.* Partner with team members to develop project schedules, project plans, effort estimation for projects under agile and waterfall methodologies.* Collaborate with technology partners to help them understand business requirement and to help in automation processes on OFSAA and OAS platforms.* Define user manuals for end user applications and train business users to effectively operate applications and functionalities. **REQUIREMENTS:*** Bachelor’s degree in Business Administration, Management Information Systems (MIS), Computer Information Systems or Computer Science* Five (5) years of experience in any occupation with development, information technology experience, or related.* Five (5) years of experience in any occupation with development, information technology experience, or related must include:* Financial Services experience* OFSAA (Oracle Financial Services Analytical Applications) with knowledge of OFSAA GL (General Ledger) Reconciliation Framework* OFSAA LLFP (Loan Loss Forecasting and Provisioning) application* FSDF (Financial Services Data Foundation)* OAS (Oracle Analytics Server) Reporting* Oracle SQL (Structured Query Language),* AWS Redshift* ETL (Extract, Transform and Load)* Understanding of ODI (Oracle Data Integrator) capabilities* OFSAA Data Quality Framework* Master Data Management (MDM) – Ab Initio* Change Management Process (Service Now)* Control M schedule* Basic understanding of applications like Peoplesoft, Financial Application Hub, One Stream, AXIOM for Data Integration purposes* Excel formula-based analysis* Working in SDLC (Software Development Lifecycle) process from Gathering Business Requirements, design, support Development & SIT, support User Testing and Release process **SAL**ARY:$147,000 per year**Education****Work Experience****Certifications****Travel**Less than 25%**Workstyle**HybridThe total compensation for this position includes base salary or wages, and may include components such as additional compensation (cash or equity), discretionary bonuses, or commissions. This position is eligible for a benefits package that may include medical, dental, and vision; life insurance; critical illness insurance and accident insurance; disability benefits; retirement savings; paid time off (including vacation, holidays, and sick leave); and parental leave. Eligibility for benefits and specific offerings may vary based on position and employment status. To view more details of the benefits offered, visit Myrjbenefits.com.At Raymond James our associates use five guiding behaviors (Develop, Collaborate, Decide, Deliver, Improve) to deliver on the firm's core values of client-first, integrity, independence and a conservative, long-term view. We expect our associates at all levels to: • Grow professionally and inspire others to do the same • Work with and through others to achieve desired outcomes • Make prompt, pragmatic choices and act with the client in mind • Take ownership and hold themselves and others accountable for delivering results that matter • Contribute to the continuous evolution of the firmAt Raymond James – as part of our people-first culture, we honor, value, and respect the uniqueness, experiences, and backgrounds of all of our Associates. When associates bring their best authentic selves, our organization, clients, and communities thrive. The Company is an equal opportunity employer and makes all employment decisions on the basis of merit and business needs.