Data & Systems Analyst III

Why StifelStifel 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 DoingThe 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 ForDesign, 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 BringAdvanced 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 & ExperienceMinimum 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 & CredentialsMinimum Required: None.Systems & TechnologyMinimum 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 StifelStifel 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.Job SummaryCategory: CompliancePosition Type: Regular | Full TimeWork Type: Onsite