Raymond James is looking for a Technology Business Analyst to act as a strategic partner to the business, facilitating and implementing technology solutions that support financial and regulatory reporting. The role involves ensuring technology solutions align with business needs through detailed system requirements, source data analysis, and data mapping to OFSAA and FSDF data models.
Requirements
- Proficiency in SQL and data profiling tools for querying and validating data.
- Hands-on experience in data analysis, profiling, and mapping across complex data environments.
- Solid understanding of relational databases, data models, and ETL processes.
- Experience in documenting metadata and managing data lineage.
- Familiarity with Oracle Financial Services Analytical Applications (OFSAA) and Financial Services Data Foundation (FSDF) data models is highly preferred.
- Proven experience in gathering and documenting business and system requirements using BRDs, use cases, flowcharts, and wireframes.
Responsibilities
- Develop detailed business requirements for both functional (e.g., business processes, rules) and non-functional (e.g., data, security) capabilities.
- Gather and interpret information from multiple sources—including databases, stakeholder interviews, and documentation—and provide actionable recommendations.
- Leverage experience with OFSAA and FSDF out-of-the-box solutions to trace data movement lineage from Staging to Result and Reporting layers.
- Perform data analysis and profiling on source system data to assess quality, completeness, and consistency.
- Write SQL queries to extract, analyze, and validate data from various databases.
- Map key data attributes and dimensions from source systems to the OFSAA FSDF standard data model.
- Validate test cases to ensure they accurately evaluate the intended business functions.
Other
- Acts as a strategic partner to the business to facilitate and implement technology solutions that support financial and regulatory reporting.
- Partner with business team to gather and document functional and non-functional business requirements.
- Actively collaborated with business partners, technology teams and cross functional teams.
- Bachelor’s degree in information systems, Computer Science, Business Analytics, or a related field.
- Minimum of seven (7) years of relevant experience as Technology Business Analyst, Systems Analyst or Data Analyst.
