Software Developer – ETL (RQ11713) Central Agencies Cluster

Softline Technology Inc.; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Softline Technology Inc. is seeking a Senior ETL Developer to design, develop, and expand data pipelines for Data Warehouse and BI solutions. You will write code, perform tests, and ensure proper documentation while collaborating with IT professionals across the SDLC.

The role emphasizes ETL design, data integration, and maintaining scalable data architectures. On-site five days a week at the OPS office location in Toronto.

Qualifications

• Experience building and maintaining ETL pipelines for data warehouses.
• Strong knowledge of SQL queries and performance tuning.
• Experience with cloud data services (Azure/AWS) and data modeling.
• Ability to document technical specifications and participate in SDLC.

Responsibilities

• Design, develop, and maintain database backends and ETL applications.
• Build and expand ETL functionalities for data warehouses and BI solutions.
• Write high-quality code, perform tests, and ensure documentation.
• Collaborate with team and clients to clarify requirements and deliverables.
• Troubleshoot issues and optimize data pipelines for reliability.

Skills

ETL

Data pipelines

SQL

Git

SDLC

Communication

Problem solving

Analytical

Education

Tools

Azure Data Factory

Azure SQL Database

Azure Data Lake

Power BI

Databricks

AWS (Aurora, Glue, OpenSearch)

SQL

Git

Job description

OnsiteWorkRequirement: Thesuccessfulcandidateisexpectedtoworkonsitefivedaysperweek,for7.25hourspercalendarday,betweenthestandardworkinghoursof8:00AMto5:00PM(excludinglunchbreaks),MondaytoFridayinclusive,attheidentifiedOPSofficelocation.

Responsibilities:

Design,implement,andcontinuouslyexpanddatapipelinesbyperformingextraction,transformation,andloadingactivities.

Requiredtotranslatetechnicalsystemsspecificationsintoworkingtestedapplications.

Thisincludesdevelopingdetailedprogrammingspecifications,writingand/orgeneratingcode,compilingdata-drivenprograms,maintaining,andconductingunittests.Resolvesandtroubleshootstechnicalproblemswhichariseduringtheuseandoperationofsoftwarepackages,includingtechnicalassistanceinimplementation,conversionandmigrations.GeneralSkills:Experienceinprogrammingandanalysis;specializedsoftwarepackagesupportatthespecifiedexperiencelevelAbilitytocollaboratewithITProfessionalsthroughouttheSoftwareDevelopmentLifeCycleExperienceinstructuredmethodologiesforthedevelopment,design,implementationandmaintenanceofapplicationsExperienceindesign,code,test,debuganddocumentapplicationsExperienceintheuseofobjectand/orthirdgenerationlanguagedevelopmenttoolsExperienceinoneormoreprogramminglanguagesExperienceinapplicationdesign,latestdesignpatters,deploymentandtroubleshootingExperiencewithrelationalandhierarchicaldatabasetechnologiesExperienceintheuseofinformationretrievalpackagesusingquerylanguagesExperiencewithoneormorecommunicationsprotocolsExperienceinstructuredmethodologiesforthedesign,development,implementationandmaintenanceofapplicationsExperienceelicitinganddocumentinginformationfromdiversebusinessareastakeholdersandsubjectmatterexpertsExcellentanalytical,problem-solvinganddecision-makingskills;verbalandwrittencommunicationskills;interpersonalandnegotiationskillsAteamplayerwithatrackrecordformeetingdeadlinesETLSkillsKnowledgeandexperienceingatheringrequirementsandbusinessprocessknowledgeinordertotransformthedatainawaythat?sgearedtowardstheneedsofendusersKnowledgeandexperiencemaintainingandimprovingalreadyexistingprocesses.KnowledgeandexperienceensuringthatthedataarchitectureisscalableandmaintainableKnowledgeandexperienceworkingwiththebusinessindesigninganddeliveringcorrect,highqualitydataExperienceinvestigatingdatatoidentifypotentialissueswithinETLpipelines,notifyend-usersandproposeadequatesolutionsExperiencepreparingdetaileddocumentationforfurtherreference.

DesirableSkills:KnowledgeandexperiencewithprogrammingInternet-readyapplicationsKnowledgeandexperienceinrapidapplicationdevelopment(RAD)methodologiesKnowledgeandunderstandingofInformationManagementprinciples,concepts,policiesandpracticesExperiencewithmiddlewareandgatewaysExperiencereviewing,analyzing,andmodifyingproductinstallationscriptsincludingencoding,testing,debuggingAbilitytoprovidepost-implementationsupportandresolveanypost-implementationtechnicalissuesExperienceconductingdesignwalkthroughsessionswithprojectteamKnowledgeandunderstandingofAccessibilityfor OntarianswithDisabilityAct(AODA)andrelatedregulationsandstandardsAbilitytoprovideuserandsystemdocumentationasrequired

Experience Requirements

OnsiteWorkRequirement: Thesuccessfulcandidateisexpectedtoworkonsitefivedaysperweek,for7.25hourspercalendarday,betweenthestandardworkinghoursof8:00AMto5:00PM(excludinglunchbreaks),MondaytoFridayinclusive,attheidentifiedOPSofficelocation.

Responsibilities/AssignmentDeliverables–SeniorETLDeveloper

Designs,develops,andmaintainsdatabasebackendandETLapplicationsforDataWarehouseandBusinessIntelligencesolutions.

UsesknowledgeofETLlanguagesanddevelopmenttechniquestobuildandexpandapplicationfunctionalitybywritinghighqualitycodeusingappropriatepatterns.Ensuresapplicationsremainsscalablewhilecomplyingtostandardsandfollowingbestpractices.

Testsanddebugsapplicationsandensuresthatsoftwareisproperlydocumented.Collaboratesclearlyandprofessionallyaspartofadevelopmentteamandcommunicateswithclients.

MandatorySkills

• ExperiencewiththeMicrosoftsuiteoftechnologyincluding:AzureDataFactory,AzureSQLDatabase,AzureDataLake,andPowerBI
• ExperiencewithDatabricksPlatform
• ExperiencewiththeAmazonWebServices(AWS)suiteoftechnologyincluding:AmazonAurora,AmazonRelationalDatabaseSearch,Glue,OpenSearch,etc.
• Experiencewithdevelopingdataextraction,transformation,andloadprograms(dailyandinitialload)functionalityonawiderangeofdatarepositories(structuredandsemi-structuredfiles,relationalandmulti-dimensionaldatastores)
• Experiencewithdeveloping,implementing,andmaintainingschedule/dependencylogicforExtractTransformLoad(ETL)scripts
• Experiencewithdataintegration,datacleansing,anddataanalytics
• Experiencewithdatamodelinganddesignprinciplesfordatamartsanddatawarehouses
• Experienceindatabasemanagementandadministration
• ExperienceinconstructingcomplexSQLqueriesandperformancetuning
• ExperiencewithGitandknowledgeofsourcecontrolstrategies
• ExperiencecreatingtechnicaldocumentationincludingETLsource-to-targetmappings,datamodeldiagrams,architectureartifacts,detaileddesigndocuments,etc.
• Experienceineliciting,documenting,andvalidatingbusinessrequirements
• ExperienceinsoftwaredevelopmentlifecyclefromDevelopment,toTestingand QualityAssurance,toDelivery
• Solidcommunicationsskills:theabilitytounderstand,comprehend,andfollowinstructionsandrequirementstocommunicateclearlyandeffectivelybothverballyandinwriting.

Nicetohaveskills

• KnowledgeandunderstandingofAccessibilityfor OntarianswithDisabilityAct(AODA)andrelatedregulationsandstandards
• ExperiencedesigningvisualdashboardstohighlighttrendsandKeyPerformanceIndicators(KPIs),anddevelopingcannedreports(scheduledandad-hoc)
• ExperiencewithprogramminglanguagessuchasC#,developingapplicationcodesuchasAPIs,Functions,etc.
• ExperiencewritingscriptswithPowerShellandotherscriptinglanguages

SoftwareDeveloper–Senior–EvaluationCriteria

CoreTechnicalSkills (50%)

• ExperiencewiththeMicrosoftsuiteoftechnologyincluding:AzureDataFactory,AzureSQLDatabase,AzureDataLake,andPowerBI
• ExperiencewiththeAmazonWebServices(AWS)suiteoftechnologyincluding:AmazonAurora,AmazonRelationalDatabaseSearch,Glue,OpenSearch,etc.
• Experiencewithdevelopingdataextraction,transformation,andloadprograms(dailyandinitialload)functionalityonawiderangeofdatarepositories(structuredandsemi-structuredfiles,relationalandmulti-dimensionaldatastores)
• Experiencewithdeveloping,implementing,andmaintainingschedule/dependencylogicforExtractTransformLoad(ETL)scripts
• Experiencewithdataintegration,datacleansing,anddataanalytics
• Experiencewithdatamodelinganddesignprinciplesfordatamartsanddatawarehouses
• Experienceindatabasemanagementandadministration
• ExperienceinconstructingcomplexSQLqueriesandperformancetuning
• ExperiencecreatingtechnicaldocumentationincludingETLsource-to-targetmappings,datamodeldiagrams,architectureartifacts,detaileddesigndocuments,etc.

OtherTechnicalSkills (35%)

• ExperiencedesigningvisualdashboardstohighlighttrendsandKeyPerformanceIndicators(KPIs),anddevelopingcannedreports(scheduledandad-hoc)
• ExperiencewithprogramminglanguagessuchasC#,developingapplicationcodesuchasAPIs,Functions,etc.
• ExperiencewritingscriptswithPowerShellandotherscriptinglanguages
• ExperiencewithGitandknowledgeofsourcecontrolstrategies
• ExperienceinsoftwaredevelopmentlifecyclefromDevelopment,toTestingand QualityAssurance,toDelivery

CommunicationsSkills (10%)

• Experienceineliciting,documenting,andvalidatingbusinessrequirements
• Solidcommunicationsskills:theabilitytounderstand,comprehend,andfollowinstructionsandrequirementstocommunicateclearlyandeffectivelybothverballyandinwriting.

StandardsandBestPractices (5%)

• KnowledgeandunderstandingofAccessibilityfor OntarianswithDisabilityAct(AODA)andrelatedregulationsandstandards

Supplier Comments

Closing Date/Time: 2026-10-14, 12:00 p.m.

Max submission: 1 (one)

5 days onsite

Please refer to Requirements and Skills in description