Job Information
Raymond James Financial, Inc. Business Systems Analyst (Data Services) in Pittsburgh, Pennsylvania
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