Role Title: Data Review & Report Visualisation
Organisation: Ear Foundation Australia
Internship Period: Summer (November - December)
Location: Perth
EFA is seeking an intern with strong SQL skills to write queries that answer our evaluation questions accurately, efficiently and repeatably.
The intern will work with our Impacts and Data team, who will set the evaluation questions and write the reports. The intern's focus is the query layer: turning those questions into well-structured, tested SQL that produces trustworthy numbers. Example questions include:
What is the mean age of diagnosis at location X over time
What proportion of children diagnosed with disease received follow-up care at location Y over time
What is the disease prevalence for a period, as a %, for children who had their initial assessment within 6 months after the start of the period?
What is the disease prevalence for a period, as a %, for children who had their initial assessment greater than 6 months before the start of the period?
A way to show these rates side by side, and tracked over time.
The Data will either be stored in the Dataverse and accessed via PowerBI and therefore queried using Dataverse SQL, or stored in REDCAP which uses MySQL or MariaDB as its underlying database management system and will be queried via MySQL or MariaDB SQL. Jane this is the best I'm not sure about till we know our architecture.
The Foundation exists to support Indigenous and at-risk families and children. We share common values. The values are the non-negotiable, unchanging heart of the organisation. Our mission is to reduce the incidence of middle ear disease in Indigenous and at-risk children in Western Australia below the World Health Organization benchmark of 4%