F8845 - Position Description Template (A2402665)
Printed copies are uncontrolled. Page 1
Template Document No: F8845 Revision No: 15 Template Last Review: 12/02/2025 Template Next Review: 12/02/2027
Position overview
Position title Data Analytics Technical Specialist
Business unit Enterprise Solutions
Remuneration type Indoor EA Level 6
Reports to Data and Analytics Systems Lead
Direct reports (role) Nil
Locations(s)
(Unitywater operates on Kabi Kabi, Jinibara and Turrbal country)
Flexibility exists to be based at any of four locations on the Sunshine Coast or Moreton Bay
Success profile 4.1 Business Planning Role Success Profile
Delegation level N/A
Position purpose
The Data and Analytics Technical Specialist is responsible for ensuring the availability and accuracy of
Data & Analytics systems across Unitywater including the EDW (Enterprise Data Warehouse), Power
Platform, the business intelligence portal and associated solutions.
This role will:
• Have a strong understanding of the Data & Analytics solution architecture design; including relational
databases, data marts, and in-depth knowledge of ETL, Power Platform and BI tools and
technologies.
• Lead the technical liaison between the relevant development teams (internal or external), business
sponsors, Technology Teams, Information Management team and end users of repository data.
• Ensure the Data & Analytics systems, tools and data are reliable and available by efficiently
resolving incidents.
Position accountabilities
Key functions of the role include:
• Develop and maintain relationships to ensure service level management with outsourced Data and
Analytics service providers, ensuring that escalated issues are resolved within agreed timeframes.
• Ensure business requirements and functional specifications align to the technical direction,
architecture and roadmap for the D&A environment.
• Become proficient understanding the entire data lifecycle from end user input into source system, to
enterprise data warehouse (EDW) target tables, and subsequent tools.
• Provide guidance to project teams responsible for the development, unit/integration testing and
implementation, of simple to complex business solutions.
Position description
Printed copies are uncontrolled. Page 2
Template Document No: F8845 Revision No: 15 Template Last Review: 12/02/2025 Template Next Review: 12/02/2027
• Enforce standards and best practices regarding code review, code profiling and performance testing.
• Enforce data architecture standards and best practices including existing data and storage
standards adopted by the enterprise data and analytics solution.
• Articulate technical design options to various audiences.
• Evaluate vendor solutions and work with the vendor as applicable.
• Power Platform (D&A Solutions) health monitoring including monitoring of:
o system performance and identifying potential issues,
o working with users and workspace admins to optimise performance,
o gateway logs and troubleshoot any connectivity/performance issues,
o other aspects of platform health such as license and capacity.
• Implement and maintain key Power Platform (D&A Solutions) policies and procedures and develop
documentation including:
o Power Platform security, governance, and compliance policies
o Power Platform monitoring policies.
o Power Platform audit processes
• Change control processes for Power Platform solutions.
• Keep up to date with Microsoft releases, new functionality and identify opportunities to leverage new
functionality within the business.
• Participate in the design and delivery of business continuity and disaster recovery planning and
implementation for Data & Analytics solutions including testing requirements and resolution of
potential issues.
• Implement and maintain information security requirements to protect the confidentiality, integrity and
availability of critical systems and associated data.
• Meet all HACCP (Hazard Analysis Critical Control Point)
• Meet relevant ISO standard
• Support and role model the WH&S policies, procedures, and practices of Unitywater as amended
from time to time.
• Participate in Unitywater safety audits and inspections to demonstrate visible safety leadership and
participation.
• Such other relevant duties as required from time to time which would generally fall within the skill
and knowledge requirements for this position.
Key relationships
Key working relationships internal and external to Unitywater are:
• Technology Operations Team
• Data & Analytics Team
• Development Teams (internal and external)
• Key stakeholders across the business
Printed copies are uncontrolled. Page 3
Template Document No: F8845 Revision No: 15 Template Last Review: 12/02/2025 Template Next Review: 12/02/2027
Capability requirements
The requirements for the position are:
• Tertiary qualification in Information Technology or equivalent 5 + years relevant experience.
• You would have proven expertise in technology service availability, performance, and capacity,
along with information security.
• Experience across the Microsoft Power Platform - including PowerBI, Power Apps, Power Automate,
including performing administrative functions within the Power Platform.
• Knowledge of Azure Platform is desirable.
• Experience with the Azure Analytics Stack (namely ADF, Azure Data Lake Storage and Databricks)
is highly desirable
• Extensive experience writing DAX, SQL and Power Query is desirable.
• Experience in designing and developing end-to-end Data & Analytics’ solutions using the Microsoft
Technology Stack.
• Extensive database administration experience using SQL Server (2008 or later).
• Highly developed communication and interpersonal skills including the proven ability to effectively
communicate and influence decisions with all levels of internal and external customers.
Within the context of the duties and accountabilities described above, the ideal applicant will be
someone who has:
• Detailed understanding of dimensional modelling and ETL principles.
• Detailed understanding of end-to-end data warehouse / security, performance tuning, and
optimization.
• Experience with DW/BI technologies, such as PowerBI, SSIS, SSAS, and Excel Services.
• Demonstrated experience in Testing of ETL, Cube and Reporting solutions, both unit and functional.
Demonstrated experience with Microsoft’s Database scripting languages:
• T-SQL (stored procedure, functions, etc).
• MDX for reports and for calculated measures.
One Unitywater Behaviours
The One Unitywater Behaviours define how we work together at Unitywater. They guide our everyday
interactions, influence how we make decisions, drive us to achieve our strategy and help us to create our
One Unitywater culture together.
Create the Future is about seeking to learn through new ideas and innovations, planning strategically,
adapting to challenges and steering Unitywater towards a sustainable future.
Care Together is about fostering a culture of safety, collaboration, and customer-focused service. It’s
about creating a workplace where people feel valued, work inclusively and deliver outstanding outcomes
for our customers.
Printed copies are uncontrolled. Page 4
Template Document No: F8845 Revision No: 15 Template Last Review: 12/02/2025 Template Next Review: 12/02/2027
Own It is about taking responsibility for our actions, being transparent and accountable, and striving for
excellence in everything we do. It’s about demonstrating integrity, welcoming feedback and ensuring we
follow through on commitments.