Join our dynamic team at Green Light as a Data Analyst, we're seeking a seasoned professional with robust technical business analysis and data migration experience. As a Data Analyst, you'll play a key role in analysing legacy systems, defining source-to-target mappings, validating migration outcomes, and ensuring data is successfully migrated into modern cloud platforms while empowering stakeholders with accurate and trusted data.
This role does require an active AGSVA NV1 clearance at a minimum. Consultants that do not hold this minimum requirement will not be considered.
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 integration solutions across enterprise environments
Provide advice on improving and establishing best practice 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 ****), SSIS, and relational database architectures
Experienced in managing data migration activities across multiple data sources (flat files, XML, Excel, relational databases)
Performance tuning and optimisation 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 utilise your knowledge of SSIS and SQL Server capabilities to optimise data extraction, transformation, and loading processes within the data platform
Requirements:
Broad and extensive experience with SQL Server development and SSIS-based data integration solutions
Strong experience with data migrations, ETL design, and data transformation across complex environments
Expertise in writing complex SQL queries, stored procedures, and functions
Experience working with multiple data sources including flat files, XML, Excel, and relational databases
Strong knowledge of SQL Server architecture and performance tuning techniques
Experience with SSIS package design, deployment, troubleshooting, and optimisation
Strong problem-solving skills and attention to detail
Robust communication skills and experience working with client stakeholders and business teams
We are an Australian onshore services company that provides technology capability across ANZ and Asia. Our services range from day-to day operational activities, through project delivery, to more strategic and transformational programs. At Green Light, we are committed to creating a diverse and inclusive workplace where everyone feels valued and respected. We are proud to be an equal prospect employer and do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
We encourage applications from all backgrounds and communities, and we are dedicated to providing a fair and accessible recruitment process for all candidates. During the recruitment process, if you require any accommodations or modifications please reach out to or call *************.
#J-*****-Ljbffr

📌 Technical Ba/Data Analyst (Nv1) (Sydney)
🏢 Green Light Worldwide
📍 Sydney