Business Systems Analyst (Data Services)

Location: Pittsburgh, Pennsylvania - United States

Time Type: Full time

Job Description

Job Description Summary

Summary of the Position:

The Business Systems Analyst (Data Services) role will support the reporting and data needs of the business by defining, developing, configuring and supporting reporting, analytics applications, data management and flow. The BSA evaluates requirements for enterprise system solutions and reports and identifies and builds the best solutions to meet the data needs of the business. The BSA will solicit, understand, and document the business requirements, processes and workflows, developing both written and visual depictions of requirements and process flows. The BSA will also participate in supporting and administering essential applications and reports maintained within the Enterprise Applications/Business Intelligence Group.'''

Primary Functions of the Position:

• Works with business users to understand requirements and processes and make recommendations for solutions/improvement
• Oversees technical implementation of projects from inception to completion
• Responsible as a resource for the monitoring, execution, support, triage, and communication of daily data processes.
• Improves existing Data Services and Enterprise Applications by recommending/implementing BSA best practices and methodology and designing data-driven solutions by utilizing their experience with relational and analytical database structures, theories, principles, and practices
• Utilizes ETL/ELT tools and ETL/ELT development to perform system integrations and data analysis to prepare for data lake utilization
• Performs technical requirements analysis, business process modeling/mapping, methodology development, and data modeling
• Works closely with Data Architects, other Business Systems Analysts, Project managers, Developers and Business stakeholders/users to ensure technical compatibility and user satisfaction
• Creates and maintains technical documentation and process documentation
• Assists users with daily and periodic technology requirements and issues

Education and Experience Requirements:

• Bachelor’s Degree in Computer Science, Information Technology, or technology-related degree
• Minimum 4 years of experience delivering and supporting BSA/BI activities and data-driven solutions
• Minimum 4 years of experience importing/exporting data (ETL/ELT) for use in application systems integration, report software, spreadsheets, and business use
• Minimum 4 years of experience with databases, data modeling and data warehouses, such as Microsoft SQL Server, SSIS, SSAS, and related tools such as Azure Data Factory, Azure VMs, Azure Storage Containers
• Modern data integration/engineering technologies is a plus: Azure Function Apps, Azure Synapse, Azure Event grid, Service Bus using topics
• Minimum 4 years of experience supporting enterprise reporting and data visualization solutions
• Minimum 4 years of experience performing business requirements analysis
• Experience in banking and/or financial services would be highly beneficial

Essential Skills and Abilities:

• Demonstrates excellent critical thinking and problem-solving abilities; superb written, verbal, and presentation skills
• Able to respond, when needed, 24/7 if system issues arise
• Effectively work in a highly dynamic and fast-paced environment
• Strong organizational skills
• Troubleshoot issues quickly and provide fixes in a timely manner
• Adapt quickly to changing priorities and managing multiple deadlines

Travel

Workstyle

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