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.
- 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.
Education and Experience Requirements:
- Bachelors Degree in Computer Science, Information Technology, or STEM/Technology-related degree.
- 1+ years of experience in Azure Data Stack technologies including Azure SQL, SQL Server, Azure Data Factory, SSIS, ADLS2, Logic Apps and Virtual Machines
- 1+ years of experience importing/exporting data (ETL/ELT) for use in application systems integration, report software, business process support, data analysis, and business use.
- 1+ years of experience delivering and supporting BI/BA/BSA activities and data-driven solutions.
- 1+ years of experience developing integrations between custom-developed and off-the-shelf enterprise systems.
- 1+ 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
- Candidates may be expected to work on Saturdays, as needed, for critical issues, maintenance, and/or other business needs.”
- 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
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.
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.
