- SALARY:NONE
- Pittsburgh, Pennsylvania
Pittsburgh, Pennsylvania
Business Systems Analyst (Data Integrations)-2401399
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.
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
Raymond James Guiding Behaviors
At Raymond James our associates use five guiding behaviors (Develop, Collaborate, Decide, Deliver, Improve) to deliver on the firms core values of client-first, integrity, independence and a conservative, long-term view.
We expect our associates at all levels to
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
NoThank You