Technical BA/Data Analyst (NV1)

Green Light; Sydney; On-site; AUD 120,000 - 170,000; Full time

Job summary

Green Light in Sydney is seeking a seasoned Data Analyst focused on data migration and legacy system analyses to enable cloud migrations with trusted data.

The role requires strong SQL/SSIS expertise, experience designing source-to-target mappings, and collaboration with stakeholders to validate migration outcomes and ensure data integrity across environments.

Anticipated initial 4-month assignment based on project scope, with on-site work at Sydney offices and NV1 clearance mandatory.

Qualifications

• Broad and extensive experience with SQL Server development and SSIS-based data integration solutions.
• Experience with data migrations, ETL design, and data transformation across complex environments.
• Expertise in writing complex SQL queries, stored procedures, and functions.

Responsibilities

• Technically advanced SSIS Developer/Data Analyst with deep experience and knowledge in SQL Server and ETL development.
• Passion and track record of designing and delivering data migration and integrations across enterprise environments.
• Provide advice on improving and establishing best practices data integration, ETL frameworks, and SQL development standards.
• Establishing frameworks, templates, business processes, runbooks, and ETL design patterns.
• Expertise/SME of SQL Server (latest versions including 2025), SSIS, and relational database architectures.
• Experienced in managing data migration activities across multiple data sources (flat files, XML, Excel, relational databases).
• Performancetuning and optimization of SSIS packages, SQL queries, stored procedures and database performance.
• Implement and manage error handling, logging, and debugging mechanisms within SSIS solutions.
• Maintain, update, and create data integration processes, standards and operational procedures.
• Adhere to IT Security architectural principles and data governance frameworks.
• Fully utilize your knowledge of SSIS and SQL Server capabilities to optimise data extraction, transformation, and loading processes within the data platform.

Skills

SSIS

SQL Server

Data migration

Data integration

ETL development

Stakeholder communication

SQL queries

Education

Bachelor's degree in a relevant field

Tools

SQL Server

SSIS

Azure Data Factory

Job description

• Initial 4 monthassignment
• Sydneyoffices
• NV1clearanceisessential

JoinourdynamicteamatGreenLightasaDataAnalyst,we'reseekingaseasonedprofessionalwithstrongtechnicalbusinessanalysisanddatamigrationexperience.AsaDataAnalyst,you'llplayakeyroleinanalysinglegacysystems,definingsource-to-targetmappings,validatingmigrationoutcomes,andensuringdataissuccessfullymigratedintomoderncloudplatformswhileempoweringstakeholderswithaccurateandtrusteddata.

ThisroledoesrequireanactiveAGSVA NV1clearanceataminimum.Consultantsthatdonotholdthisminimumrequirementwillnotbeconsidered.

Responsibilities:

• TechnicallyadvancedSSISDeveloper/DataAnalystwithdeepexperienceandknowledgeinSQLServerandETLdevelopment
• Passionandtrackrecordofdesigninganddeliveringdatamigrationandintegrationsolutionsacrossenterpriseenvironments
• Provideadviceonimprovingandestablishingbestpracticedataintegration,ETLframeworks,andSQLdevelopmentstandards
• Establishingframeworks,templates,businessprocesses,runbooks,andETLdesignpatterns
• Expertise/SMEofSQLServer(latestversionsincluding2025),SSIS,andrelationaldatabasearchitectures
• Experiencedinmanagingdatamigrationactivitiesacrossmultipledatasources(flatfiles,XML,Excel,relationaldatabases)
• PerformancetuningandoptimisationofSSISpackages,SQLqueries,storedproceduresanddatabaseperformance
• Implementandmanageerrorhandling,logging,anddebuggingmechanismswithinSSISsolutions
• Maintain,update,andcreatedataintegrationprocesses,standardsandoperationalprocedures
• AdheretoITSecurityarchitecturalprinciplesanddatagovernanceframeworks
• FullyutiliseyourknowledgeofSSISandSQLServercapabilitiestooptimisedataextraction,transformation,andloadingprocesseswithinthedataplatform

Requirements:

• BroadandextensiveexperiencewithSQLServerdevelopmentandSSIS-baseddataintegrationsolutions
• Strongexperiencewithdatamigrations,ETLdesign,anddatatransformationacrosscomplexenvironments
• ExpertiseinwritingcomplexSQLqueries,storedproceduresandfunctions
• Experienceworkingwithmultipledatasourcesincludingflatfiles,XML,Excel,andrelationaldatabases
• StrongknowledgeofSQLServerarchitectureandperformancetuningtechniques
• ExperiencewithSSISpackagedesign,deployment,troubleshooting,andoptimisation
• Strongproblem-solvingskillsandattentiontodetail
• Strongcommunicationskillsandexperienceworkingwithclientstakeholdersandbusinessteams

WeareanAustralianonshoreservicescompanythatprovidestechnologycapabilityacrossANZandAsia.Ourservicesrangefromday-to dayoperationalactivities,throughprojectdelivery,tomorestrategicandtransformationalprograms.AtGreenLight,wearecommittedtocreatingadiverseandinclusiveworkplacewhereeveryonefeelsvaluedandrespected.Weareproudtobeanequalopportunityemployeranddonotdiscriminateonthebasisofrace,religion,colour,nationalorigin,gender,sexualorientation,age,maritalstatus,veteranstatus,ordisabilitystatus.

Weencourageapplicationsfromallbackgroundsandcommunities,andwearededicatedtoprovidingafairandaccessiblerecruitmentprocessforallcandidates.Duringtherecruitmentprocess,ifyourequireanyaccommodationsormodificationspleasereachoutto***************@greenlightworldwide.comorcall+6192473799.