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.
Prior DBA experience would be a plus.
__Create and maintain technical documentation, process documentation and insightful scripts/data analysis.


QualificationsEducation 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 supportingcreating enterprise data analysis, data management/governance, data visualization, data integrations and automated solutions.
__Prior experience with Salesforce, RPA platforms, Databricks/Snowflake, Azure DevOps and APIs 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 prioritiesJob:Banking

Primary Location:
US-PA-Pittsburgh-PittsburghOrganizationTriState Capital BankScheduleFull-timeJob ShiftDay JobTravelNoReq ID:2401399#J-18808-Ljbffr