Data Analyst

Data Analyst - 2400743 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.

Read on to find out what you will need to succeed in this position, including skills, qualifications, and experience.

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 visualization 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.

Qualifications

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 : Knowledge 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.

Raymond James Guiding Behaviors 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 Technology Primary Location US-PA-Pittsburgh-Pittsburgh Organization TriState Capital Bank Schedule Full-time Shift Day Job Travel Yes, 10 % of the Time Thank You

J-18808-Ljbffr