Data Analyst with SQL and Python

Requirements:

• Bachelors degree in Information Technology, Computer Science, Business Administration, or equivalent experience
• 1-3 years of experience in financial, investment, technical, or analytical roles
• Familiarity with financial services concepts and terminology, particularly in wealth management
• Proficient in T-SQL, relational databases, and foundational data modeling principles
• Ability to write SQL queries that aggregate, analyze, and structure large, intricate data sets
• Strong analytical and critical thinking abilities to identify trends and connections within data
• Willingness to enhance skills in creating normalized datasets for enterprise reporting and business intelligence
• Excellent communication skills to convey data insights to non-technical stakeholders
• Proficient in Microsoft Excel, Word, PowerPoint, and Outlook
• Experience with ticketing systems
• Knowledge of reporting, documentation, and productivity tools
• Familiarity with system monitoring and logging tools
• Understanding of client/server architecture, APIs, and relational databases
• Ability to write intermediate SQL queries
• Experience with AWS and Python preferred

Responsibilities:

• Address ad-hoc data and reporting inquiries from business and product partners
• Work closely with stakeholders to clarify requirements and ensure appropriate data delivery
• Write and optimize T-SQL queries to assist with analysis, reporting, and broader data initiatives
• Validate and review data outputs for accuracy, completeness, and quality
• Provide peer support and review for fellow analysts, particularly on complex requests
• Identify ways to enhance team processes, documentation, and data practices
• Manage and prioritize incoming requests based on urgency, impact, and team capacity
• Develop a strong understanding of internal applications and business processes and their impact on data
• Act as a subject matter expert for specific raw data sources and maintain associated documentation

Technologies:

• AWS
• Business Intelligence
• Excel
• Support
• Python
• SQL
• Cloud
• AI
• LESS

More

We are looking for a Data Analyst to join our IT-focused analytics team in downtown Saint Louis, MO, where we support data-driven initiatives across our organization. The role involves collaborating with business stakeholders, product teams, and developers to provide accurate and timely data insights through ad-hoc reporting and analysis. We offer competitive compensation and comprehensive benefits, including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance for eligible employees. Our salaried team members enjoy paid time off, while hourly employees receive paid sick leave as applicable.

last updated 43 week of 2026