Role: Technical Lead

Location: Canada- Remote

Job description:

Position Overview

The Technical Lead will be responsible for the technical architecture, development, and maintenance of the Sales Crediting System. This role will oversee SQL development, system integration, and technical implementation of business requirements while leading a team of developers and analysts.

Technical Skills

Must Have:

• Advanced SQL Server development (complex stored procedures, functions, optimization)
• Experience with database performance tuning and query optimization
• Strong knowledge of SQL Server memory-optimized tables
• Experience with ETL processes and data integration, including:
  • Design and implementation of data extraction from source systems (Salesforce, transaction processing systems)
  • Creation of efficient transformation processes for sales attribution rules
  • Implementation of reliable loading procedures with proper error handling and logging
  • Experience with ETL scheduling and monitoring
  • Troubleshooting ETL pipeline failures
• Proficiency in designing and implementing data models
• Experience with source control systems for database code

Good to Have:

• Experience with Salesforce integration (API, middleware)
• Knowledge of cloud database technologies
• Experience with CI/CD pipelines for database projects
• Experience with data masking and security implementation
• Understanding of microservices architecture

Soft Skills

Must Have:

• Strong leadership abilities
• Excellent problem-solving skills
• Advanced communication skills (technical and non-technical audiences)
• Ability to translate business requirements into technical solutions
• Project management experience
• Stakeholder management

• Ability to prioritize competing demands

Business Knowledge

Must Have:

• Comprehensive understanding of sales attribution processes
• Knowledge of financial services data structures
• Understanding of regulatory requirements for financial reporting
• Familiarity with sales compensation structures

• Knowledge of mutual fund, retirement, and annuity products

• Familiarity with industry standards for data management

Key Responsibilities

• Lead the technical design and implementation of the Sales Crediting System
• Oversee code quality, performance optimization, and system reliability
• Develop complex stored procedures for sales attribution logic
• Create technical specifications based on business requirements
• Lead root cause analysis for system issues and data discrepancies
• Mentor junior team members on technical best practices
• Design and implement integration solutions for cross-system data flow
• Architect solutions for expansion to other product lines