The SQL & Reporting Analyst is responsible for developing, maintaining and improving the organisation's SQL queries, business reports and reporting processes.

The role requires strong technical skills in Microsoft SQL Server, SQL Server Reporting Services (SSRS) and Microsoft Report Builder, with the ability to independently develop and maintain reports, troubleshoot issues and ensure the accuracy and reliability of business information.

The successful candidate will work closely with management and internal stakeholders to understand reporting requirements, deliver practical reporting solutions and improve the performance and efficiency of existing reports and data processes.

This is a part-time position working three days per week, suited to an experienced, self-motivated professional who can work independently, manage competing priorities and deliver high-quality reporting outcomes.

Key Responsibilities SQL Development and Database Querying

- Write, maintain and troubleshoot SQL queries, views, stored procedures and scripts.
- Extract, combine and transform data from multiple database tables and sources.
- Develop complex queries to support business, operational and management reporting requirements.
- Review and improve existing SQL code to ensure accuracy, efficiency and maintainability.
- Investigate data discrepancies and resolve issues affecting reporting outputs.
- Work with existing database structures to identify the appropriate data sources for reporting requirements.

Report Development – Microsoft Report Builder and SSRS

- Develop, modify, publish and maintain reports using Microsoft Report Builder and SQL Server Reporting Services (SSRS).
- Design paginated reports that present business information clearly and accurately.
- Configure report datasets, parameters, filters, grouping, sorting and calculated fields.
- Use expressions, conditional formatting and other Report Builder functionality to meet reporting requirements.
- Develop and maintain report layouts, tables, matrices, charts and other report components as appropriate.
- Configure and troubleshoot report parameters, including date ranges, default values and cascading parameters where required.
- Manage report data sources and datasets and ensure reports retrieve the correct information.
- Maintain existing reports and implement enhancements as business requirements change.
- Troubleshoot report errors, formatting issues, incorrect results and performance problems.
- Configure and maintain report subscriptions and scheduled report delivery where required.

Data Accuracy and Quality

- Validate report outputs to ensure information is complete, accurate and consistent with underlying data.
- Investigate unexpected results, data anomalies and discrepancies between reports.
- Review calculations, business rules and reporting logic to ensure they are applied consistently.
- Identify potential data quality issues and work with relevant staff to resolve them.
- Ensure reporting outputs are reliable and suitable for their intended business purpose.

Performance and Process Improvement





- Investigate slow-running SQL queries and reports and identify opportunities to improve performance.
- Review query logic, execution plans and indexing where appropriate.
- Optimise report datasets and SQL queries to improve report execution times.
- Identify opportunities to automate recurring reporting tasks and reduce manual processing.
- Improve the efficiency, reliability and maintainability of existing reporting processes.
- Recommend practical improvements to reporting solutions, data retrieval and report delivery.

Business Requirements and Stakeholder Support

- Work with management and internal stakeholders to understand reporting needs and define requirements.
- Translate business questions into appropriate SQL queries and report designs.
- Clarify reporting specifications, calculations, filters and expected outputs before implementing changes.
- Provide support for reporting issues and explain technical findings in clear, accessible language.
- Manage assigned tasks in consultation with management and communicate progress, risks and potential delays.
- Maintain documentation of report logic, data sources, queries and processes to support ongoing maintenance and knowledge sharing.

Essential Skills and Experience

The successful candidate will have:

- Demonstrated experience writing and maintaining SQL queries in a Microsoft SQL Server environment.
- Strong knowledge of SQL, including joins, aggregations, subqueries, CTEs, filtering and data manipulation.
- Hands-on experience developing, maintaining and troubleshooting reports using SQL Server Reporting Services (SSRS).
- Proficiency in Microsoft Report Builder, including report design, datasets, parameters, filters, grouping, sorting, expressions and calculated fields.
- Experience connecting reports to SQL Server data sources and developing queries to support reporting requirements.
- Experience troubleshooting report errors, parameter issues, incorrect results, formatting problems and performance issues.
- Understanding of paginated reports and their application in business and operational reporting.
- Ability to investigate data discrepancies and validate reporting outputs.
- Solid analytical, problem-solving and diagnostic skills.
- Excellent attention to detail and a commitment to data accuracy.
- Ability to understand business requirements and translate them into practical reporting solutions.
- Strong organisational skills and the ability to work independently with minimal supervision.
- Effective written and verbal communication skills.

Desirable Skills and Experience

The following experience would be advantageous:

- Advanced SSRS functionality, including expressions, conditional formatting, subreports and drill-down reports.
- Configuring report subscriptions,



scheduled delivery and shared data sources.
- SQL Server performance tuning, including execution plan analysis and indexing strategies.
- Experience working with large datasets and multiple interconnected databases.
- Automating recurring reports and data extraction processes.
- Maintaining existing reporting environments and improving legacy reports.
- Documenting technical solutions, report dependencies and reporting procedures.

Personal Attributes

The successful candidate will be:

- Analytical, methodical and solutions-focused.
- Proactive in identifying and resolving technical issues.
- Comfortable working independently and taking ownership of assigned tasks.
- Reliable and committed to delivering accurate, high-quality work.
- Able to prioritise tasks and manage competing deadlines.
- Practical and focused on finding efficient solutions to business problems.
- Able to communicate technical information clearly to non-technical stakeholders.
- Flexible and comfortable working within a three-day-per-week arrangement.

Working Arrangements

This is a casual position working two to three days per week, with the specific days and hours to be agreed.

The role will focus on maintaining and enhancing existing SQL queries and reporting solutions, developing new reports as required, resolving reporting issues and improving the efficiency and reliability of the organisation's reporting environment.

The successful candidate will work with management to establish priorities and agree on deliverables within the available working hours.

The role requires the ability to work independently while maintaining clear communication about progress, outstanding tasks and issues requiring further investigation.

Measures of Success

Performance in the role will be assessed against the following outcomes:

- Accurate, reliable and timely delivery of agreed reports.
- Effective development and maintenance of SQL queries, Report Builder reports and SSRS reporting solutions.
- Timely resolution of reporting errors and data discrepancies.
- Improvements in report performance and SQL query efficiency.
- Successful implementation of agreed reporting enhancements.
- Reduced manual effort through improved reporting processes and automation where appropriate.
- Clear documentation of reporting logic, data sources and technical processes.
- Effective management of priorities and positive working relationships with internal stakeholders.

Application Requirements

Applicants should submit a resume outlining their relevant SQL development and reporting experience.

Applications should clearly demonstrate practical experience with Microsoft SQL Server, SQL Server Reporting Services (SSRS) and Microsoft Report Builder, including examples of reports developed, maintained or enhanced.

Candidates should also outline their experience troubleshooting reporting issues, working with complex SQL queries and improving the accuracy or performance of existing reports.

Pay: $40.00 – $50.00 per hour

Expected hours: 12.0 – 32.0 per week

Work Location: In person

📌 SQL & Reporting Analyst (Batemans Bay)
🏢 Unpuzzle
📍 Batemans Bay