Research Data Coordinator
CurrentWestern Power conducted a major cost-cutting initiative towards the end of 2013 resulting in many redundancies and the closing down of entire branches such as Smart Grid Branch. I continued to apply for work in a deflated job market but also took the opportunity to become primary carer for my young daughter. In 2015, I managed to secure employment at the Surveys, Statistics & Mathematical Modelling branch at the Western Australian Department of Fisheries (now part of the Department of Primary… Show more Western Power conducted a major cost-cutting initiative towards the end of 2013 resulting in many redundancies and the closing down of entire branches such as Smart Grid Branch. I continued to apply for work in a deflated job market but also took the opportunity to become primary carer for my young daughter. In 2015, I managed to secure employment at the Surveys, Statistics & Mathematical Modelling branch at the Western Australian Department of Fisheries (now part of the Department of Primary Industries and Regional Development). Our branch is responsible for assessing the status of most of Western Australia's fish stocks which is used to monitor the success of management arrangements.My role as Research Data Coordinator involves the development and maintenance of MS Access databases, the design and development of Data Marts, databases, tables, queries and views in MS SQL, the development of data extracts for internal and external clients (often using SAS and R), the management of data validation and cleansing tasks for the research databases, and managing Research Officers and Data Entry Officers. Major deliverables included: - The development of data validation routines (in SAS) for the research databases- The development of Data Extracts used in the State of Fisheries Reports since 2014- The development of routines to Extract, Transform and Load research data into the data cube FishCubeWA- Updated the Data Licence Agreement and Data Request Form templates used by the Department- Designed and Managed the Online Aquaculture Returns System project developed using K2- Successfully delivered catch data for over 245 licences over 5 years as part of $35 million Parks Australia Fishing Business Assistance (FBA) Grants SchemeTechnologies used in this job include SAS Enterprise Guide 4.3, R, T-SQL, SQL Server Management Studio 2012, Microsoft Visual Studio 2012, VBA, Angular, K2, Microsoft Access 2010 and Microsoft Access 2003. Show less