SAS TEST SPECIALIST
Role Type: Initial 6 Months Contract
About the role
You will be reporting into the Credit Risk Test Manager and supported by the Value Stream and Programme Test Capability for our SAS Platforms. You’ll be responsible designing, documenting and performing data quality checks and ETL testing across all data assets in SAS platforms, including ETL jobs, reports, and data platforms. As one team, you’ll work together to get things done.
Key Tasks Will Include
Design, develop and maintain the data quality assurance framework for our SAS data solution
Collaborate with BI and Data analysts and Engineers to ensure high quality Data Deliverables
Contribute toward the design and development of testing frameworks to test ETL jobs, Credit Risk reports and other data platforms
Create SAS/SQL scripts to validate data between the data repositories and source systems
Create SQL scripts to validate data warehouse (data transformation) against the data sources
Track, monitor and document testing results
Collaborate with the Data Architect & Engineers to understand SAS platform design, data warehousing functionality, big data solutions (i.e. Hadoop, Teradata) and underline Cloud platforms (i.e. Microsoft Azure, AWS)
Produce high-quality, well-structured code and test scripts that is maintainable and extensible
Perform data management and maintenance tasks required for preparing for test activities
To be successful in this role you will have to possess
Prior experience and in-depth knowledge in testing data solutions and ETL processes on SAS platforms (experience with IFRS9 or RCM/RWA modules is highly desirable)
Experience with Data Migration initiatives with large data volumes, including Legacy Data Migration with diverse Data sources from multiple Databases/Sources.
Hands-on experience in development with various data related packages for BASE SAS, SQL and PL/SQL (Python code and packages knowledge will be an added advantage).
Self-motivated and willing to go the extra mile to get the job done
Strong work ethic and able to thrive in both a team environment and working alone
Please Note:Prefer Auckland candidates but Wellington would also work for the right person
Please apply online or pass your CV and cover letter to firstname.lastname@example.org
Candidates with valid work visa or NZ residency will be considered for this role. ]]>