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

📌 Software Developer – ETLCentral Agencies Cluster (Toronto)
🏢 Softline Technology
📍 Toronto