Data Analyst

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.

Job Summary:

The Data Analyst role involves the identification, collection, interpretation, extraction and cleansing of data sets necessary for use in reporting, analytics or advanced modeling applications. Serving in a key role between technology application owners and key consumers of enterprise data resources, the Data Analyst must possess critical thinking and problem-solving skills. A Data Analyst needs to have a good understanding of the questions being asked and the problems that need to be solved. They also should be able to find patterns or trends in the data that reveal new insights, allowing focus on the right types of data while recognizing the most revealing methods of analysis. The Data Analyst must be self-motivated with the ability to effectively communicate via both verbal and written forms and manage frequently changing priorities. Ability to communicate ideas across a variety of data consumers is crucial to your work as a Data Analyst. Financial industry experience and familiarity with financial services, products, and regulations is advantageous.

Essential Duties and Responsibilities:

         Gather data: Data Analysts identify and collect data from sources such as an organization's systems of record or select external sources or even licensed data

         Clean data: Raw data often contains duplicates, errors, or non-essential data. The Data Analyst will scrub the data to improve quality utilizing a spreadsheet or programming language, to engineer the data set for accuracy and intent.  

         Model data: Create and design the structures of a data set to satisfy the business objective. Determine the types of data to collect and store while establishing how data categories are related and presented for consumption.

         Interpret data: Use knowledge of data analysis techniques and the business/markets/products (etc) to identify patterns or trends in data leading to new insights or opportunities to combine with other data sets/sources.

         Present analysis: Communicate results analysis or data interpretation utilizing data visualizations tools (entity relationship diagrams, object graphs, writing reports, and presenting information to interested parties.

         Collaborate: Work with business users to understand requirements and processes and make recommendations for data set solutions/improvement

         Data Integration: Utilize data integration tools and methods such as ETL tools and development or integration services/API development to perform data extraction and data set creation

         Document Work: 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 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 using Azure Data Factory

         Minimum 3 years of experience performing business requirements analysis

         Experience in banking and/or financial services would be highly beneficial

Essential Skills and Abilities:

         Data modeling and extraction tools: Use of Microsoft Excel and SQL, ETL tools and API service integration.

         Data Programming languages: Familiarity with statistical programming languages (Python or R) to handle large sets of data and perform complex data joins.

         Data visualization: Power BI, Tableau, Thoughtspot, Excel for creation of data set visuals.

         Statistics and math: p of statistics and math will help you determine which tools are best to use to solve a particular problem, help you catch errors in your data, and have a better understanding of the results.

         Strong communication and people skills; must work well with technology and business teams

         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