Business Systems Analyst (Data Integrations)

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.

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

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.

Job

Banking

Primary Location

US-PA-Pittsburgh-Pittsburgh

Organization

TriState Capital Bank

Schedule

Full-time

Shift

Day Job

Travel

No

Thank You