Quick Reminder - Technical Lead - Remote - Canada - Contract Role Job at Lorven technologies, Ontario, CA

YjJxb1AxaXRrRDkwSGVZbnVLVFdRUEVydEE9PQ==
  • Lorven technologies
  • Ontario, CA

Job Description

Role: Technical Lead

Location: Canada- Remote

Contract Role

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

Job Tags

Hourly pay, Permanent employment, Full time, Contract work, Part time, Seasonal work, Remote work,

Similar Jobs

FHR

MO416-QA Tester 508711 Job at FHR

 ...willingness to work in-office up to five days per week asbusiness needs necessitate Our direct client has an opening for a QA Tester5087 Thisposition is up to 12 months, with the option of extension, and is located inPhoenix, AZ. W2 only. If... 

Banner Health

Courier Job at Banner Health

 ...interested in socializing in an environment that meets their needs.POSITION SUMMARYThis position drives a company vehicle to transport mail and packages, pick up materials/donations, and/or make deliveries to and from company facilities, donor locations and/or other... 

McGavock Auto Group

Automotive Sales & Leasing Consultant Job at McGavock Auto Group

 ...Nissan's Circle of Excellence Award 17 times. We are the best of the best -- and we take great pride our employees.No automotive experience is required. Candidates that have worked in retail, hospitality or the service industry are encouraged to apply.We offer a... 

Vitaly Health

Locum Tenens - Pediatrician Physician Job at Vitaly Health

 ...Job Title: Locum Tenens - Pediatrician Physician Location: Wisconsin State Position Overview: Our team at Vitaly Health is looking for a Pediatrician Physician to join our Medical Center on an ongoing Locum Tenens basis, with a start date of July 2025. The role... 

Hustle Notice Biz

Entry-Level Marketing Specialist Job at Hustle Notice Biz

 ...00 - $31.00 hourly (based on experience) Position Overview Swipe Say Easy We are seeking an enthusiastic and motivated Entry-Level Marketing Specialist to join our dynamic marketing team. As an integral part of our organization, you will have the opportunity to learn...