Data Analyst

Stifel; St. Louis (MO); On-site; USD 65,000 - 95,000; Full time

Job summary

Stifel is seeking a Data Analyst to join the Digital Solutions group. The role focuses on ad-hoc data extraction, reporting requests, and translating business requirements into actionable data sets using queries.

You will collaborate with business users, product management, and development teams to ensure data accuracy, maintain documentation, and serve as a subject matter expert for assigned data sets while seeking process improvements and clear stakeholder communication.

Qualifications

• Bachelor's degree or equivalent work experience.
• 1-3 years' investment, financial or technical experience.
• Solid understanding of financial industry terminology.
• Basic knowledge of Microsoft T-SQL and database design.

Responsibilities

• Develop an understanding of Stifel business data models and use that knowledge to optimize data relationships.
• Refine requirements from business users until full understanding is reached on the data requested.
• Build and leverage T-SQL queries to fulfill ad-hoc data requests and support data analysis initiatives.
• Perform data quality checks and due diligence on produced data.
• Provide peer review and assist team members on larger projects.

Skills

Data analysis

Analytical thinking

Stakeholder communication

Financial terminology

Education

Bachelor's degree in IT/CS/Business

Tools

T-SQL

Database design

Job description

Why Stifel

Stifel strives for a culture that puts its clients and associates first: a culture where everyone belongs, everyone is welcome, and everyone contributes to the success of our clients, their careers, and the firm as a whole.

Let’s talk about how you can find your place here at Stifel,where success meets success.

What You'll Be Doing

The Data Analyst will work as a member of Stifel's Analyst team within the Digital Solutions group. The Data Analyst is responsible for servicing ad-hoc data extraction and reporting requests originating from various areas of the business as well as support discovery or solutions for firm data driven initiatives and developments. This position is expected to work with business users as well as product management and development teams to further define requirements, analyze pertinent underlying data to ensure proper use and then translate those requirements into queries that will provide the objective data sets. The Data Analyst will also act as a subject matter expert for assigned raw data sets as well as maintain documentation surrounding them.

What We're Looking For

• Develop an understanding of the Stifel business & data models, and use that knowledge to optimize the relationship between the company and the customer.
• Field inbound requests from business users and product management and refine requirements until a full understanding is reached on the data being requested.
• Build and leverage T-SQL queries to fulfill ad-hoc data requests or support data analysis needs related to firm initiatives and developments.
• Perform due diligence on data produced to ensure quality and accuracy.
• Provide peer review of ad-hoc data requests fulfilled by associate members of the Data Analysts team and provide assistance to fellow members as needed in larger project efforts.
• Proactively identify and recommend process and practice improvement within the team.
• Maintain strong communication with stakeholders, following up as needed to ensure all requests are being actively addressed and/or status is being communicated.
• Triage requests to focus first on more time-sensitive items while maintaining awareness of overall team bandwidth and workload.
• Gain and utilize a strong understanding of company applications and business practices in the context of how they affect the firm's data.
• Perform in-depth analysis and act as subject matter expert for assigned raw data sets.

What You'll Bring

• Solid understanding of financial industry terminology and concepts.
• Knowledge of financial services, specifically wealth management.
• Solid understanding of basic concepts of Microsoft T-SQL and database design.
• Ability to leverage SQL to create queries which model and/or aggregate large complex datasets.
• Leverage these skills to grow abilities in developing normalized data sets for enterprise wide business intelligence purposes.
• Strong analytical skills focused on using logic and reasoning to identify complex relationships within a data structure as well as to research and discuss recommended uses.

Education & Experience

• Minimum Required: Bachelor's degree in Information Technology, Computer Science or Business Administration or equivalent work experience
• Minimum Required: 1-3 years' of investment, financial or technical experience