ETL and SAS Developer

One of our federal clients is seeking an experienced ETL and SAS Developer to join the team.

About the role

As a Senior SAS ETL Developer, you will be responsible for designing, building, and maintaining data flows/pipelines and architectures on the ACDW Platform leveraging Agile Ways of Working to deliver iterative and high-quality solutions. With a proactive and can-do attitude, the developer will design, create, and maintain SAS DI applications in diverse environments, ensuring alignment with business goals and high-quality standards. Developer should also provide mentoring and coaching to Junior Developers. You will work closely with cross-functional teams to ensure the availability, accuracy, and timeliness of the organisation's data. Understand complex information systems and design effective data solutions and models to store and retrieve departmental data in adherence to enterprise standards. Drive Stakeholder workshops to identify client requirements and conceptualise and communicate these requirements via visual aids.

Key duties and responsibilities

• Provide the technical design, implementation, testing, and compliance for identified solutions.
• Design and implement ETL scripts and data warehouse solutions.
• Collaborate on warehouse and reporting design.
• Collaborate with business teams in an Agile environment to understand and refine business processes, ensuring alignment with iterative development cycles.
• In conjunction with the development team, ensure quality standards are adhered to during development and implementation.
• Document the architectural design and production support processes in relevant artefacts.
• Maintain a clear understanding of the overall application architecture and ensure that this understanding is conveyed to and maintained current with all team members.
• Interpret the technical specifications of solutions.
• Ensure that security, auditability and data integrity issues are covered in the design of the application.
• Proactively recommend changes to development and system standards, fostering a culture of continuous improvement and adaptability.
• Provide guidance and direction to other developers on application standards and use of development tools.
• Ensure processes are in place to control development quality. This includes responsibility for thorough and comprehensive unit and system testing.
• Work with the Data Warehouse Production Team for job migration, optimisation and scheduling.
• Co-ordinate handover and production scheduling and validation.
• Any other tasks, as directed by the buyer.

Essential criteria

• Extent to which the Candidate's response and CV meets the Department's requirement as outlined within the Role Description and Key Duties and Responsibilities.

Technical skills, knowledge and qualifications

• Extensive knowledge in Database technologies, preferable Oracle and related RDBMS. Advantage to have PL/SQL knowledge.
• Desirable experience in IBM LSF, Control-M or related scheduling Tools.
• Experience of working in Data Warehouse area
• + years’ experience working and exhibiting knowledge in in ETL tools SAS Data integration studio, Base SAS, IBM LSF Flow, databases such as Oracle;
• Demonstrated ability to deliver business solutions through the System Development Life Cycle (SDLC) and Agile development practices (SAFe) and processes for data acquisition;
• Demonstrated interpersonal skills and capacity to communicate and work effectively within a multi-disciplined and blended team environment;
• Experience implementing and supporting ETL and Batch Schedules;
• Proven ability to work in a team environment, with the ability to work with limited supervision and achieve results. A high level of organisation and good time management skills, including a demonstrated ability to meet priorities and work to deadlines;
• A demonstrated ability to engage with requesting business areas and project stakeholders;
• Ability to discuss technical issues/solutions with both technical and non-technical staff; and
• Bachelor's degree in IT; or equivalent experience.
• Desirable skills: Experience in proactively delivering results and driving business change;
• Further experience and knowledge of Enterprise Data Warehouses (EDW) and associated technologies (such as Microsoft SQL Server, Hadoop, SAS, Cognos, Qlik, etc.);
• Comfortable with data profiling, data analysis, and data mapping; and
• Strong hand on skills in design, development and implementation of various data remediation, Data migration, data integration techniques.

Working arrangements

Hybrid

Remote/flexible work arrangements can be discussed with the Specified Personnel’s manager upon commencement, and a Working from Home Agreement must be formalised by the buyer and seller.

Maximum hours: 40 hours per week

Estimated start date: 1 January 2027

Initial contract duration: 12 months, ending 31 December 2027 with 12 months extension

Application requirements

• Latest copy of your CV
• A suitability statement addressing the skills/experiences.

If you believe you are the right fit, apply today.

If you know someone who can be a great fit, refer them via our referral page on the website.

New Vision Software acknowledges the Traditional Owners of the lands on which we live and work. We pay our respects to Aboriginal and Torres Strait Islander Peoples, and to Elders past and present.

We welcome people of all cultures, religions, backgrounds, beliefs, ages, abilities, genders, sexual orientations and identities.