Data Analyst - Stifel

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 within Stifel’s Information Technology group as a member of an Agile development team. Members in this position are expected to work with internal and external business users as well as product management and internal development teams to analyze pertinent underlying data and systems and further define requirements needed to develop data products for the firm’s largest data migration initiative. The Data Analyst is responsible for developing an understanding of the firm’s data pertinent to crucial business processes in order to affect working IT solutions based on firm initiatives. Duties of the role require ability to analyze raw as well derived or refined data sources to understand technical structure as well as business nature of the data within. Duties also require a focus on analysis of data quality to ensure accuracy within data products built via transformations of various data sources. Familiarity with relational databases is crucial with background in querying large datasets and ETL processes preferred.  

What We're Looking For:

• Develop an understanding of the Stifel business & data models to assist migration and curation of firm data from on prem data centers to cloud based infrastructure.
• Work with relational databases and query large datasets as part of the ETL process.
• Analyze source data as part of large data migration initiative applying business concepts in order to prepare core data for business consumption
• Create mapping and documentation identifying proper transformation logic and definition of domain driven data products in AWS datastores
• Perform quality assurance testing on data products built
• Assist in enhancements and support of data products based on stakeholder or consumption needs
• 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.

• Gain and utilize a strong understanding of company applications and business practices in the context of how they affect the firm's data.

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

Licenses & Credentials:

• Minimum Required: None.
• Preferred: AWS or other cloud platform experience or certifications

Systems & Technology:

• Microsoft Excel, Word, PowerPoint, Outlook, Teams, Zoom
• Incident and Change Request ticketing systems.
• Productivity, reporting, and technical documentation software – JIRA, Sharepoint
• Cloud – AWS; Azure DevOps
• Microsoft SQL server; Python; AWS data services
• Client/server computing architecture, user interfaces and application programing interfaces.
• Understand concepts related to relational databases.
• Ability to create intermediate SQL queries.
• Experience with AWS and Python is preferred.

 

#LI-LL1

About Stifel:

Stifel is more than 130 years old and still thinking like a start-up.  We are a global wealth management and investment banking firm serious about innovation and fresh ideas.  Built on a simple premise of safeguarding our clients’ money as if it were our own, coined by our namesake, Herman Stifel, our success is intimately tied to our commitment to helping families, companies, and municipalities find their own success.

 

While our headquarters is in St. Louis, we have offices in New York, San Francisco, Baltimore, London, Frankfurt, Toronto, and more than 400 other locations.  Stifel is home to approximately 9,000 individuals who are currently building their careers as financial advisors, research analysts, project managers, marketing specialists, developers, bankers, operations associates, among hundreds more.  Let’s talk about how you can find your place here at Stifel, where success meets success.

 

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.

 

Stifel is an Equal Opportunity Employer.