Data Analyst

Stifel Financial; Little Rock (AR); On-site; USD 60,000 - 85,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401k

Wellness initiatives

Life insurance

Paid time off

Job summary

Stifel Financial is seeking a Data Analyst to join the Digital Solutions group. You will translate business requirements into SQL queries, analyze complex data sets, and ensure data quality.

The role interfaces with product management and development teams to support firm initiatives and deliver actionable data insights. The position emphasizes collaboration with business users, an understanding of wealth management data, and the ability to build normalized data sets for enterprise-wide BI

Qualifications

• Bachelor's degree in IT, CS or Business Administration or equivalent work experience.
• 1–3 years’ investment, financial or technical experience.
• Strong SQL/T-SQL and data modeling skills.
• Proficiency in Excel; familiarity with AWS and Python preferred.

Responsibilities

• 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.
• 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 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 a subject matter expert for assigned raw data sets.

Skills

T-SQL

SQL

Data analysis

Excel

Python

AWS

Data modeling

Stakeholder comm

Education

Bachelor's degree

1-3 years’ investment/financial/technical experience

Tools

Ticketing systems

Office productivity software

Relational databases

AWS

Python

Job description

Summary

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

Essential Duties & Responsibilities

• 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.
• 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 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 a subject matter expert for assigned raw data sets.

Qualifications

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

Systems & Technology

• Proficient in Microsoft Excel, Word, PowerPoint, Outlook.
• Experience with ticketing systems.
• Experience with office productivity, reporting, and technical documentation software.
• Exposure to systems monitoring tools and logging tools.
• Understands client/server computing architecture, user interfaces and application programming interfaces.
• Understand concepts related to relational databases.
• Ability to create intermediate SQL queries.
• Experience with AWS and Python is preferred.

Benefits

At Stifel we offer an entrepreneurial environment, comprehensive benefits package to include health, dental and vision care, 401k, wellness initiatives, life insurance, and paid time off.