Senior Software Developer - SQL/Python
About The Position
We are seeking an experienced Senior Software Engineer to work within Wealth Management Global IT Data Services Canada. As a Senior Software Engineer, specializing in AI-driven agent development using Python, SQL, and Snowflake technologies, you will leverage modern development tools including Copilot and Windsurf to build intelligent, scalable solutions. You will join a very dynamic team that is highly technical and has a great track record of delivering multiple innovative AI-powered solutions within the organization. This is a hands-on technical role, very independent with an opportunity for growth.
Requirements
- Strong experience with Python development (5-7 years) and modern frameworks
- Advanced SQL expertise across multiple platforms (SQL Server, Snowflake) including complex queries, stored procedures, and performance tuning
- Hands-on expertise with Snowflake data warehouse and SQL query optimization
- Proven experience developing AI-based agents and intelligent automation solutions
- QE mindset with proven ability to design and automate functional testing frameworks
- Proficiency with Copilot and Windsurf development environments
- Experience with REST APIs and modern integration patterns
- Experience with containerization (Docker, Kubernetes) and DevOps practices
- Proficiency with version control (Git) and CI/CD pipelines
- Experience in both Agile and Waterfall environments
Nice To Haves
- Experience with machine learning frameworks and LLM integration
- Prior experience managing or mentoring small teams
- Exposure to enterprise data governance and data quality tools
- Experience with cloud platforms and infrastructure automation
- Hands-on experience with IBM DataStage and ETL tools
- Unified Engineer background with full-stack quality assurance perspective.
Responsibilities
- Design and develop AI-based agents and intelligent automation solutions using Python and copilot-assisted development
- Build and optimize data pipelines and analytics solutions leveraging Snowflake and SQL
- Build and automate functional testing frameworks with QE mindset and Unified Engineer approach
- Contribute to successful solution development and delivery by identifying risks and developing/recommending mitigation strategies
- Participate in code reviews and technical design reviews of all AI agent architectures, specifications, and implementation plans
- Collaborate with data engineering and infrastructure teams to optimize Snowflake queries and database performance
- Assist DevOps/support teams in troubleshooting production issues and performance optimization
- Mentor team members on Python best practices, AI agent development, Snowflake optimization, and testing automation
Benefits
- bonuses
- flexible benefits
- competitive compensation
- commissions
- stock where applicable
- Leaders who support your development through coaching and managing opportunities
- Ability to make a difference and lasting impact
- Work in a dynamic, collaborative, progressive, and high-performing team
- A world-class training program in financial services
- Flexible work/life balance options
- Opportunities to do challenging work
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
