Jared Johnston Email & Phone Number

Townsville, Queensland, Australia

At AIMS I work mainly with the time series explorer (https://apps.aims.gov.au/ts-explorer/), and Reefcloud (https://reefcloud.ai/). Continuous integration was managed within the pipelines feature of the bitbucket. This projects use AWS API Gateway and Lambda microservices to query source data within Amazon RDS. The lambdas are written in Python and can include FastAPI and Mangum to handle the request, and Pandas, Peewee, SQLAlchemy, and/or pycopg2 to obtain and manipulate the data. Sometimes we use AWS lambda to initiate an AWS Batch job, which uses Python running on Docker in an EC2 instance to build the requested data. Other tools I have used during this time include a range of AWS cloud services (CDK, SAM, S3, and CloudWatch), conda. The front end was build with the AngularJS web framework.

Queensland, Australia

Initially hired to create reports and visualisations, my role morphed into what is better described as a Data Engineer. I spent most of my time liaising with customers to understand their requirements, and then modelling data to suit their needs. The source data was read in from APIs, or directly from source systems (usually in normalised form). The modelling process involved taking a historical data store, making the necessary transformations or analysis, and organising the data into a star schema in the data warehouse.

I returned to the same team at TCC, this time working as a support engineer and GIS analyst to the team of stormwater, waste water, bulk water and traffic and transport engineers. I was mostly utilised to automate GIS and management processes through Python, and VBA scripting. As a result I have been exposed to a wide range of infrastructure planning projects. I also undertook the redevelopment of the growth model for Townsville, and the implementation of the Regional Stormwater Quality Treatment Strategy as my main responsibilities. However, I still helped out with floodplain and coastal planning occasionally. I was also an intelligence officer in the Local Disaster Management Group, and worked during the 1 in 2000 year rain event in January of 2019.

Townsville, Australia

Reducing my hours at Townsville City Council allowed me to undertake an internship with JESI to develop my programming skills. I was put to the task of developing front end test with CodeceptJS. I would also tackle smaller front end pieces which were developed in Backbone.js. This helped me develop my JavaScript and exposed me to a full development stack in a professional environment.

Edinburgh, United Kingdom

As the Booking Manager I was responsible for ensuring that the MacBackpackers Edinburgh hostels had the highest possible occupancy rate. This involved managing the online availability on the booking channels, maintaining a social media presence, and increasing online guest acquisitions. Before leaving the company, I conducted a complete overhaul of customer acquisition logistics setting all three hostels with a Channel Management System and a Property Management System. This increased online bookings, reduced the potential for overbookings, and made the Booking Manager role redundant which reduced ongoing operational costs.

As a Stormwater Drainage Planning Engineer at Townsville City Council I was part of a two man team responsible for updating all flood models across the city of Townsville. We used our flood models to advise on infrastructure planning and design, the new city plan, disaster management, and emergency response. This involved extensive use of ArcGIS, MIKE FLOOD hydraulic modelling software and XP-RAFTS hydrologic modelling software.

Gold Coast, Australia

At DHI is assisted other hydraulic engineers by convert structures from Culvert and Weir models to Bridge systems in MIKE 11, and post processing and presenting results using MIKE Zero Toolbox.