Senior Data Model Developer

Seeking a highly skilled Senior Developer to join our team in designing, developing, building, implementing, and supporting Business Intelligence (BI) and Data Warehouse solutions. The successful candidate will play a pivotal role in data modelling and designing the Reporting Database and BI solutions, enabling effective reporting and analysis of data for both internal and external stakeholders.

The Senior Developer will be responsible for:

• Designing optimal physical data models of datasets and maintaining data maps and systems interrelationship diagrams for data domains and systems;
• Serving as a point of contact for staff requiring BI and report writing assistance;
• Providing technical expertise within the Business Systems Unit and the wider organization;
• Developing and maintaining metadata information, including data dictionaries, data lineage maps, and entity relationship diagrams to facilitate analysts and business users in finding relevant information for analysis and development of data tools such as dashboards and machine learning models;
• Establishing and nurturing productive relationships with stakeholders, essential for delivering outcomes;
• Offering expert advice on data concepts and usage and contributing as a subject matter expert to various projects;
• Contributing to the development and implementation of the reporting database, known as School Asset Information Lake (SAIL);
• Identifying data gaps and leading the development of new data sources;
• Extracting, transforming, and loading data from multiple sources into a central data warehouse;
• Providing advice and recommendations regarding data and systems;

The ideal candidate will possess:

• Strong experience in designing and developing data models (conceptual, logical, and physical) to support business intelligence, reporting, and analytics;
• Proficiency in designing databases and optimizing their performance for large-scale data storage, retrieval, and reporting processes;
• Ability to analyze business requirements and translate them into effective data models that support organizational goals;
• Knowledge of database normalization and denormalization techniques to balance data integrity and performance;
• Familiarity with data governance and management practices, ensuring that data models align with data standards, security, and regulatory requirements;
• Strong SQL skills for querying databases and validating data models, along with knowledge of relational and non-relational database systems;
• Ability to create comprehensive data dictionaries, entity-relationship diagrams (ERDs), and other documentation for development and reference;
• Skilled in identifying data issues, gaps, and inconsistencies, and working to resolve them through effective modelling and data integration strategies;
• Ability to clearly communicate complex data structures to both technical and non-technical stakeholders;

We are seeking a candidate with:

• A relevant tertiary qualification in Information Technology;
• Advanced knowledge and understanding of information technology;
• Proficiency in MS SQL Server, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), Power BI, MS Access, or similar reporting tools;
• Experience in developing and maintaining metadata information, including data dictionaries, data lineage maps, and entity relationship diagrams;
• Experience in scenario modelling of datasets to support policy initiatives and funding requests;
• Proven ability to identify, troubleshoot, and implement solutions to enhance data quality and streamline service processes;
• Proven ability to document business requirements and develop plans for database and reporting solutions and enhancements;

We value diversity and inclusion in all forms - gender, religion, ethnicity, LGBTIQ+, disability and neurodiversity. Aboriginal and Torres Strait Islander candidates are strongly encouraged to apply. We strive to make every interaction with us a positive one for our customers, colleagues and key partners regardless of our individual role or team.