Address
Form of workTriState 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
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 solution
• Minimum 3 years of experience supporting enterprise reporting and data visualization solution
• Minimum 3 years of experience with databases, data modeling and data warehouses such as Microsoft SQL Server, SSIS, SSRS, SSAS, Power BI, and related tool
• 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 analysi
• 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 team
• Strong analytical skills, with the ability to analyze and solve problem
• Must have the ability to document processes and solutions with accuracy
• Adapt quickly to changing priorities and manage multiple deadline
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 outcome
• 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
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
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 solution
• Minimum 3 years of experience supporting enterprise reporting and data visualization solution
• Minimum 3 years of experience with databases, data modeling and data warehouses such as Microsoft SQL Server, SSIS, SSRS, SSAS, Power BI, and related tool
• 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 analysi
• 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 team
• Strong analytical skills, with the ability to analyze and solve problem
• Must have the ability to document processes and solutions with accuracy
• Adapt quickly to changing priorities and manage multiple deadline
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 outcome
• 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
