The IT Wealth Management Product team at Raymond James needs a Senior Business/Data Analyst to facilitate and implement technology solutions by writing data requirements that ensure solutions meet business needs, integrating domain knowledge with financial services standards, and coordinating with other departments.
Requirements
- Experience in gathering business requirements with focus on data is required.
- Solid analytical and problem-solving skills with attention to detail. Detailed understanding of Software Development Lifecycle (SDLC) methodologies (e.g., Agile/Scrum, Waterfall).
- Data Mapping & Transformation: Experience in analyzing source and target systems to define data mapping, transformations, and validation rules.
- SQL & Database Querying: Strong proficiency in SQL to extract, validate, and reconcile data across systems.
- Data Quality & Cleansing: Experience in identifying data quality issues and working with stakeholders to resolve them before migration.
- ETL Tools Knowledge: Familiarity with ETL (Extract, Transform, Load) tools like Informatica, Talend, SSIS, or Azure Data Factory is preferred.
- Understanding of AWS Data Lake architecture, with hands-on experience in leveraging services such as Amazon S3, Redshift, and Spark to support scalable data ingestion, storage, and analytics workflows is preferred.
Responsibilities
- Creates detailed business requirements for functional requirements with focus on financial and organizational data.
- Gathers and interprets information from multiple sources (including databases, interviews, etc.) and makes recommendations.
- Review of existing legacy data sources and mapping to target data structures.
- Translate technical concepts to business audience and business information to a technical audience.
- Works with User Experience / Design resources to help visualize requirements into prototype.
- Understands and applies principles in risk management, issue tracking and change management.
- Validates test cases to ensure that scripts will evaluate the business function being performed.
Other
- Note: This position will follow our hybrid work model, we expect the selected candidate to be in the office 2-3 days a week at the St. Petersburg, FL Corporate Office location.
- Three (3) to five (5) years of experience as a Technical Business/Data Analyst would be preferred or a combination of education, training and experience.
- Experience working on legacy data analysis & migration projects is strongly preferred
- Broad Financial Services experience is preferred.
- Fluent in Microsoft Office Suite – Access, Excel, PowerPoint, Visio, Word.
