Data Engineer - Sun life Job at Red Pico, Toronto, ON

OVd4cEhlbGtseERTR0hVQnZrL1o4MzM1MGc9PQ==
  • Red Pico
  • Toronto, ON

Job Description

Overview:

We are seeking a highly skilled and motivated Data Engineer with a strong background in SQL, SSIS, and ETL pipeline development. The ideal candidate will be experienced in designing and implementing robust data solutions, translating business logic into technical workflows, and collaborating effectively with both technical and non-technical stakeholders.

 

Location:   Hybrid 1-day onsite
Clearance Requirement:   Active Security Clearance required or is eligible for Reliability Security Clearance

 

Responsibilities:

  • Design, develop, and maintain ETL pipelines using SSIS and SQL Server
  • Perform data ingestion, extraction, and mapping across multiple systems
  • Translate complex business logic into stored procedures and SSIS workflows
  • Develop and implement data models to support business requirements
  • Create and manage complex business rules and data manipulation logic
  • Identify and flag data anomalies and inconsistencies
  • Collaborate with business stakeholders to understand requirements and deliver actionable data solutions
  • Work independently and take ownership of assigned tasks and deliverables

Requirements

  • Proven experience with SQL Server, SSIS, and ETL development
  • Strong understanding of data modeling, data mapping, and data transformation
  • Ability to write and optimize stored procedures and data manipulation scripts
  • Excellent problem-solving skills and attention to detail
  • Strong communication skills, with experience engaging directly with business users
  • Experience with AWS is a plus

Job Tags

Contract work,

Similar Jobs

jobalign

Hilo Office Clerk Job at jobalign

 ...Training starts at $15.00 employment type: part-time You may qualify for a signing bonus, up to $500 with bookkeeper/data entry experience! Position available immediately! Fast-paced team environment in Hilo looking for hard working, customer service oriented, detail... 

Premier Infusion and Healthcare Services, Inc.

Insurance Coordinator (Specialty) Job at Premier Infusion and Healthcare Services, Inc.

 ...- Up to 4% Quarterly Bonus Opportunities Medical, Dental & Vision Insurance Employer Paid Life Insurance Short Term / Long Term...  ...Description of Responsibilities The Specialty Insurance Coordinator is responsible for all new referral insurance verification... 

Loblaw Companies Limited

Préparateur(rice) de Commandes (Temps plein/partiel) Job at Loblaw Companies Limited

 ...Equipment, uniform and parking are provided ~ Company share purchase program and group RRSP ~ Premium ~ Evening: + $1.00/h ~ Night: + $1.10/h ~ Frozen: + $2.00/h Permanent full-time positions available Available schedules: ~ Day shifts: 6:00am to 2:00pm... 

Express Employment Professionals

Process Assistant - Transportation Company (DOT Experience Required). - Urgent Hire Job at Express Employment Professionals

 ...Job Description Job Description A Company in North East Austin Texas is looking for a Full-TimeProcess Assistant Clerk with at...  ...- This is an IN-OFFICE ROLE.* This position is a contract-to-hire role.* Position: Responsible for performing clerical and administrative... 

Amazon Japan G.K.

Risk Management Coordinator, JP Books Operations BRM Operations Job at Amazon Japan G.K.

 ...ATIONS - 1+ years of customer service experience - Work a flexible schedule/shift/work area, including weekends, nights, and/or holidays - Native level in Japanese - Write and read fluently in English - Bachelor's Degree is requir...