Business Systems Analyst-Data Reporting

Summary of the Position:

The Business Systems Analyst (BSA) role involves the monitoring, troubleshooting, reporting, and communication of the daily operation functions of TriState in-house applications and automated processes. As the link between the system processes and the business teams, you must be a self-motivated individual with the ability to effectively communicate via both verbal and email forms and manage frequently-changing priorities. The role will also 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 leads the building of 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 requirements and process flows.

Primary Functions of the Position:

• Managing the support tickets/cases for the Solutions/Reporting team and the Salesforce/DLP platforms
• Performing operational functions on an as-needed basis (user setups, data entry/management, information gathering, defect analysis, email communications)
• Works with business users to understand requirements and processes and make recommendations for solutions/improvement
• Improves existing BI systems by recommending/implementing BA 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 tools and ETL development to perform system integrations and report data preparation
• Reports writing and technical requirements analysis, business process modeling/mapping, methodology development, and data modeling
• Creates and maintains technical documentation and process documentation

Education and Experience Requirements:

• Bachelor’s Degree in Computer Science, Information Technology, or technology-related degree
• Minimum 3 years of experience delivering and supporting BI/BA activities and data-driven solutions
• Minimum 3 years of experience supporting enterprise reporting and data visualization solutions
• Minimum 3 years of experience with databases, data modeling and data warehouses, such as Microsoft SQL Server, SSIS, SSRS, SSAS, Power BI, and related tools
• Minimum 3 years of experience importing/exporting data (ETL) for use in integrations
• Minimum 3 years of experience performing business requirements analysis
• Experience in banking and/or financial services would be highly beneficial

Essential Skills and Abilities:

• Candidates may be expected to work on Saturdays, as needed, for critical issues, maintenance, and/or other business needs."
• Must have excellent communication and people skills; must work well with technology and business teams
• Must have strong analytical skills, with the ability to analyze and solve problems
• Must have the ability to document processes and solutions with accuracy
• Adapt quickly to changing priorities and manage multiple deadlines

TriState Capital Bank provides equal employment opportunity and advance in employment to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

TriState Capital Bank is an Equal Opportunity Employer.