Business Systems Analyst - Pittsburgh, United States - Raymond James
Description
TriState Capital Bank is an independent chartered bank subsidiary of Raymond James.Headquartered in Pittsburgh, PA, TriState Capital Bank provides premier private banking, commercial banking, and treasury management products and services to corporate, institutional, and high-net-worth (HNW) clients.
Summary of the Position:
The Business Systems Analyst (Data Integration Services) role will support the operational and analytical needs of the business by defining, developing, configuring, and supporting data integration solutions, while working closely with the Enterprise Application managers / software engineers.
The role will evaluate business and technical requirements for Enterprise systems, Architecture and Business Intelligence while identifying strategic & innovative solutions to meet the data needs of the business.
The BSA will solicit, understand, and document business and technical requirements, processes and pipeline workflows for Enterprise systems, Architecture and Business Intelligence while identifying strategic & innovative solutions to meet the data needs of the business.
The BSA will also participate in supporting / administering essential applications and reports maintained within the Enterprise Applications group.Primary Functions of the Position:
**_
_*
Support the business-critical data-intensive Enterprise Applications and Integrations.
**_
_*
Develop data integrations, pipelines and ETL processes that connect disparate sources and supporting applications and platforms.
**_
_*
Define data lineage for key data points across applications and integrations.
**_
_*
Work with business stakeholders and technical team members to understand requirements and processes to make recommendations for tactical, strategic, and innovative data-centric solutions/improvement.
_*
Apply Agile project management methodologies to ensure proper implementation and completion within requested timelines and work with software engineers to deliver cohesive enterprise application features.
_*
Improve existing Data Integration Services and Enterprise Applications by recommending/implementing BSA best practices and methodologies while designing data-driven solutions by utilizing experience with relational and analytical database structures, theories, principles, and practices.
_*
ETL tool utilization and development through Azure Data Factory Pipelines and Microsoft SSIS to perform system integrations and data analysis with the intent of preparing for data lake utilization.
_*
Technical requirements analysis, business process modeling/mapping, methodology development, data analysis master data management, and data modeling.
**_
_*
Works closely with data architects, business analysts / system analysts, project managers, developers, enterprise application managers, and business stakeholders/users to ensure technical compatibility and user satisfaction.
**_
_*
Create and maintain technical documentation, process documentation and insightful scripts/data analysis.
Qualifications
Education and Experience Requirements:
**_
_*
Bachelors Degree in Computer Science, Information Technology, or STEM/Technology-related degree.
**_
_*
2 years of experience importing/exporting data (ETL/ELT) for use in application systems integration, report software, business process support, data analysis, and business use.
_*
Experience in Azure Data Stack technologies including Azure SQL, SQL Server, Azure Data Factory, SSIS, ADLS2, Logic Apps and Virtual Machines preferred.
_*
2 years of experience delivering and supporting BI/BA/BSA activities and data-driven solutions.
**_
_*
2 years of experience developing integrations between custom-developed and off-the-shelf enterprise systems.
**_
_*
2 years of experience performing business requirements and systems analysis.
**_
_*
Experience supporting\creating enterprise data analysis, data management/governance, data visualization, data integrations and automated solutions.
**_
_*
Prior experience with Salesforce, RPA platforms, Databricks/Snowflake, Azure DevOps and API's a plus.
**_
_*
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
**_
_*
Ability to respond, when needed, 24/7 if system issues arise
**_
_*
Ability to work in a highly dynamic and fast-paced environment, with strong organizational skills and the ability to manage multiple deadlines and quickly adapt to changing priorities
**_
_*
Ability to troubleshoot issues quickly and provide fixes in a timely manner
**_
_*
Ability to quickly adapt to changing priorities
Job:
Banking
Primary Location:
US-PA-Pittsburgh-Pittsburgh
Organization
TriState Capital Bank
Schedule
Full-time
Job Shift
Day Job
Travel
No
Req ID:
2401399
#J-18808-Ljbffr