Data & Systems Analyst III

Stifel Financial Corp.; Northern (KY); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health, dental, vision

401k

Wellness initiatives

Life insurance

Paid time off

Job summary

Stifel Financial Corp. is seeking a Data & Systems Analyst III to support Compliance reporting across AML. You will design and optimize SQL solutions, build dashboards, and partner with stakeholders to translate requirements into scalable data products.

This role provides technical guidance to junior analysts, promotes coding standards, and participates in system upgrades and vendor implementations. Strong communication and problem-solving are essential.

Qualifications

• Bachelor’s degree or equivalent in IT/CS/IS/Data Analytics/Finance/Business Admin.
• 5+ years in IT, systems support, data, or reporting.
• Experience in financial services or regulated environments preferred.
• Experience leading technical initiatives and mentoring juniors.

Responsibilities

• Design, develop, and maintain advanced SQL solutions for reporting and data analysis.
• Develop complex queries, stored procedures, views, and data transformations.
• Integrate data from multiple enterprise systems to support Compliance reporting.
• Design dashboards and reports using Power BI and SSRS.
• Provide guidance to junior analysts and maintain QA standards.
• Lead system upgrades, vendor implementations, testing, and deployments.

Skills

Advanced analytics

Troubleshooting

Problem solving

Lead initiatives

Mentorship

Strong communication

Data validation

Education

Bachelor's degree in IT / CS / IS / Data Analytics / Finance / Business Administration or related field

Tools

SQL Server

SSMS

SSRS

Power BI

Power Automate

Python

Copilot

JIRA

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 & Systems Analyst III is a senior technical contributor on the Technology & Analytics team responsible for supporting the systems, data, reporting, and technology needs of teams across the Compliance organization, including the Firm's Global Anti-Money Laundering (AML) department. This role serves as a technical resource for advanced SQL development, recurring and ad hoc reporting, data analytics, automation, and key technology platforms supporting Compliance. The Analyst III partners with AML Compliance stakeholders to translate complex business and reporting requirements into accurate, efficient, and maintainable technical solutions. This position also provides technical guidance to junior team members and promotes consistent standards for SQL development, documentation, testing, and quality assurance.

What We're Looking For

• Design, develop, and maintain advanced SQL solutions supporting recurring and ad hoc reporting, data analysis, and operational needs.
• Develop and maintain complex queries, stored procedures, views, data transformations, and reporting datasets.
• Integrate and analyze data from multiple enterprise systems to support Compliance reporting, analytics, and decision-making.
• Optimize SQL queries and reporting processes for performance, accuracy, reliability, and maintainability.
• Design and develop reports, dashboards, and analytical solutions using tools such as Power BI and SSRS.
• Perform data validation, reconciliation, and testing to ensure the accuracy and completeness of reporting outputs.
• Provide advanced administration, troubleshooting, and enhancement support for technology platforms used across the Compliance organization.
• Investigate complex system, data, and reporting issues and coordinate resolution with internal technology teams and vendors.
• Participate in and provide technical support for system upgrades, vendor implementations, testing, and production deployments.
• Identify and implement opportunities to improve business processes and reduce manual effort through technology and automation.
• Develop automation and data-processing solutions using tools such as Power Automate and Python where appropriate.
• Evaluate and apply AI-enabled technologies, including Microsoft Copilot, to improve processes and operational efficiency.
• Lead complex technical and reporting initiatives from requirements gathering through implementation.
• Provide technical guidance and review SQL, reporting, automation, and other technical solutions developed by junior analysts.
• Mentor Analyst I and Analyst II team members on SQL, systems support, data analysis, testing, and technical best practices. Promote consistent standards for SQL development, documentation, testing, quality assurance, and version control.

What You'll Bring

• Advanced analytical, troubleshooting, and problem-solving skills.
• Ability to translate complex business and reporting requirements into effective technical solutions.
• Strong understanding of structured data, relational databases, reporting, and data validation.
• Ability to independently troubleshoot complex system, data, and reporting issues.
• Ability to lead technical initiatives and manage multiple high-priority deliverables.
• Strong attention to detail with an emphasis on data accuracy, testing, documentation, and maintainability.
• Strong communication skills with the ability to collaborate with business stakeholders, technical teams, vendors, and junior team members.
• Ability to provide technical guidance and mentorship to other analysts.

Education & Experience

• Minimum Required: Bachelor's degree in Information Technology, Computer Science, Information Systems, Data Analytics, Finance, Business Administration, or related field, or equivalent experience.
• Minimum Required: 5+ years of IT, systems support, data, reporting, or related technical experience.
• Preferred: Experience supporting financial services, regulatory, Compliance, surveillance, or other highly controlled business environments.
• Preferred: Experience leading technical initiatives and providing guidance to junior team members.

Licenses & Credentials

• Minimum Required: None.

Systems & Technology

• Minimum Required: Proficient in Microsoft Office including Outlook, Word, Excel, and PowerPoint.
• Experience with Microsoft SQL Server, SQL Server Management Studio (SSMS), and SQL Server Reporting Services (SSRS) is preferred.
• Experience with Power BI or similar reporting and visualization tools is preferred.
• Experience with Microsoft Power Automate or similar workflow automation technologies is preferred.
• Experience with Python for automation, data processing, or analytics is a plus.
• Familiarity with Microsoft Copilot, Copilot Studio, or other AI-enabled technologies is a plus.
• Experience with JIRA for project management, requirements tracking, change management, and issue tracking is preferred.
• Minimum Required: Advanced SQL development experience, including query optimization, stored procedures, views, and complex data transformations.
• Minimum Required: Experience administering or supporting enterprise business applications and developing reporting or data solutions.

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.