Senior BI Developer

Foundation House•Brunswick, OH

6h•Onsite

About The Position

The Senior Business Intelligence (BI) Developer is a key role within the Information Management Team (IM Team). The IM Team is primarily responsible for the management of client health records and related information. The team supports compliance with Commonwealth and State legislative requirements as well as Foundation House policies concerning the collection, storage, organisation, use and release of client information. IM provides end user training and support to all users of the Client Information Management System (CIMS). They manage, maintain, and continually improve Foundation House’s client information system and a suite of accompanying reporting tools. IM supports data reporting and analysis within VFST, including providing the means to measure key performance indicators and tools to improve data quality. The IM Team supports all types of reporting requirements, including operational information needs, management reporting, executive reporting, external reporting, research and ad hoc analysis. The Senior BI Developer leads the technical delivery of reporting and analytics within the IM Team with support from the Health Information Manager and other team members. It is necessary to analyse each requirement to determine the appropriate tool for meeting the need within the context of the CIMS Reporting Strategy. The Senior BI Developer is responsible for developing sophisticated solutions using advanced tools and supporting others to deliver reports using basic tools.

Requirements

Relevant tertiary qualifications or demonstrated equivalent experience
Experience in developing end-to-end metadata driven BI solutions from source system to end user reports
Good understanding of the Microsoft Azure data stack
Experience implementing projects in Microsoft Fabric, Synapse and/or Data Factory
Advanced T-SQL skills
Advanced Power BI skills including DAX and visualisations
Experience with data lakehouse architecture and managing multi-layered data models (eg Bronze, Silver, Gold)
Experience utilising multiple data modelling approaches (e.g. relational, multi-dimensional and tabular) and understanding which is appropriate at what time
Experience working with data from Salesforce, preferably Nonprofit Cloud
Program Management
Demonstrated ability in applying design principles to report and dashboard development
Appointment to the position is subject to a satisfactory National Police Check, Working with Children Check and Reference Check process.
If you have lived for a continuous period of 12 months or more in another country within the last 10 years, an International Police Check from that country will also be required.
The successful applicant must be able to demonstrate proof of the Right to Work in Australia.

Nice To Haves

Python data engineering experience advantageous
Experience in a health, counselling or community services organisation advantageous

Responsibilities

Work with stakeholders to gather and refine reporting requirements, then identifying how each requirement will be fulfilled within the context of the CIMS Reporting Strategy
Work with the Health Information Manager to define appropriate architecture to meet reporting and analytical needs
Extract and manipulate data from CIMS
Make efficiency improvements to the data lake to support internal and external reporting needs
Design and implement data modelling for reporting requirements
Implement appropriate extract, load transform (ELT)/ETL functions to transform data from source to destination data model utilising a metadata driven medallion architecture
Administer and manage the data platform, including configuration, monitoring, and performance tuning
Assess and address data integrity and accuracy in collaboration with subject matter experts (SMEs)
Develop user friendly interactive reports and dashboards
Deliver ongoing training, user guides and support to internal stakeholders to utilise reports and dashboards
Contribute to the development of information standards, governance, documentation, and reusable frameworks
Perform data analysis to support decision making and strategic priorities