Senior Technical Systems Analyst | SQL & Reporting

Job Description Summary

Job Description

As part of our Raymond James Trust System Engineering and Support Team the Senior Technical Systems Analyst will act as a partner with the Trust business group and IT Partners to facilitate and implement technology solutions. This role will support multiple in-house and vendor-based RJ Trust applications along with IT project support.

This individual will be responsible for writing business process and system requirements that will ensure the technology solution will meet the needs of the business. Requires a high-level understanding of systems industry and end-user requirements. This is a primary role that helps to collaborate between business and application developers on a complex system handle data research and analysis requests from business on issues and work with IT Partners to help drive and get them to successful conclusions. Requires very good understanding of systems and their interactions financial services industry and end-user requirements. Is able to make judgements and recommendations based on the analysis and interpretation of data.

Responsibilities:

• Proactively plan and coordinate business workshops define objectives and partner with project management to meet delivery timelines.

• Lead business meetings to gather and refine requirements and present design concepts and solution recommendations.

• Creates detailed business requirements for functional (e.g. business processes rules) and non-functional (e.g. data security) capabilities.

• Validates test cases to ensure that scripts will evaluate the business function being performed.

• Gathers and interprets information from multiple sources (including databases interviews etc.) and makes recommendations.

• Supports the business by handling configuration and workflow management for financial and document management systems.

• Provides support for application development teams including documenting business processes.

• Translate technical concepts to business audience and business information to a technical audience.

• May take a lead role in developing estimates and implementation plans for technical solutions.

• Partners with team members to develop project schedules reports and documentation. May be required to act as project lead on small to medium projects and/or provide direction to others on the team.

• Collaborate with the vendor handing over business use cases designing technical solutions and assessing implementation options.

• Understands and applies principles in risk management issue tracking and change management.

• Performs other duties and responsibilities as assigned.

Skills/Previous Experience:

• More than five (5) years of experience as a Technical Business Analyst is required.

• Financial Services experience is highly preferred. Experience with supporting enterprise level complex applications is preferred.

• Experience and background in working with financial accounting systems would be preferred.

• Experience with Financial Accounting platforms (FIS RenInc) preferred.

• Experience with Hyland OnBase software (Workflow WorkView) preferred.

• Experience with gathering business requirements from ground up is required.

• Experience with SQL scripting RDBMS queries pulling data out of various systems writing BRDs etc... is required. Experience writing scripts for data manipulation.

• Experience in working with various stakeholders of IT and Business Operations at senior level is required.

• Experience with analyzing data in a complicated multi-layered application in heterogeneous environment.

• Experience in working with vendor-based application software implementation and support is a plus.

• Experience developing reports in SSRS/Tableau/ Power BI is a plus.

Knowledge of:

• Advanced knowledge issue tracking change management and requirements gathering.

• Solid understanding of SDLC and working through various phases of it with Peers and IT Partners.

• Knowledge of Waterfall Agile and Hybrid software development methodologies.

• Reporting knowledge from user perspective such as creating and running reports in SSRS and Tableau.

Ability to:

• Ability to query a database using SQL is required.

• Demonstrated ability to independently lead workstreams prioritize tasks and drive progress with minimal oversight.

• Ability to assume ownership and responsibility act as a key liaison between application development and business operations is required.

• Ability to understand in-depth details of business processes rules. Document and communicate them effectively to various technical and non-technical partners.

• Clearly convey information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.

• Demonstrate a strong knowledge in position-related areas; remains current with developments and trends in areas of expertise.

• Work in a team environment or project room to facilitate collaboration.

• Ability to provide system support including after-hour incident handling when necessary (rotation within the support team).

Licenses/Certifications:

• None required.

Education

Work Experience

Certifications

Travel

Workstyle

The 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 .

At Raymond James our associates use five guiding behaviors (Develop Collaborate Decide Deliver Improve) to deliver on the firms 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 firm

At 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.