Data Analyst
- Collect, clean, integrate and analyse data from multiple systems to improve data quality and support decision-making.
- Build and maintain SQL queries, data models, interactive dashboards and reports using business intelligence tools.
- Collaborate with technical and business teams on data warehousing, reporting and analytics projects.
About Microknot Pty Ltd
Microknot Pty Ltd is an Australian software development and technology consulting company specialising in custom software development, data analytics, business intelligence, cloud-based solutions and digital transformation.
The company works with organisations across different industries to develop technology solutions that improve business operations, streamline processes and support informed decision-making.
Microknot provides data analytics and management services, including cloud data warehousing, data modelling, data cleansing, data integration, interactive dashboards and business intelligence reporting. The company utilises modern technologies such as Microsoft Power BI, Tableau, Microsoft SQL Server, Azure Data Lake and cloud platforms to transform business data into meaningful insights.
About the Role
Microknot Pty Ltd is seeking an experienced and analytical Data Analyst to support its data analytics and business intelligence projects.
The successful candidate will be responsible for collecting, processing, analysing and interpreting data from multiple sources to identify trends, patterns and business insights. The role involves developing data models, preparing analytical reports, creating interactive dashboards and supporting the implementation of data-driven solutions for clients.
Working alongside business analysts, software developers, project managers and technical specialists, the Data Analyst will contribute to improving data quality, reporting accuracy and the effective utilisation of business information.
Key Responsibilities
- Collect, consolidate and analyse structured and unstructured data from various business applications, databases and information systems to support organisational reporting and decision-making.
- Identify business reporting requirements and translate analytical requirements into data models, reporting specifications and meaningful analytical outputs.
- Develop, maintain and optimise SQL queries, database structures and data extraction processes to retrieve and process information from relational databases.
- Perform data cleansing, validation, transformation and reconciliation activities to identify inconsistencies, eliminate duplication and maintain data accuracy and integrity.
- Design, develop and maintain interactive dashboards, visualisations and management reports using Microsoft Power BI, Tableau or other relevant business intelligence platforms.
- Analyse historical and operational datasets to identify trends, performance indicators, patterns and relationships that provide actionable business insights.
- Develop data models and analytical frameworks to support business forecasting, performance monitoring and reporting requirements.
- Assist with the development and maintenance of cloud-based data storage and data warehousing solutions, including Microsoft Azure and Azure Data Lake environments.
- Integrate information from multiple business systems and applications to establish centralised reporting environments and improve data accessibility.
- Prepare technical documentation covering data structures, data mapping, reporting methodologies, analytical processes and dashboard functionality.
- Work collaboratively with software developers, business analysts and project managers to support data integration, business intelligence and technology implementation projects.
- Monitor data quality and reporting performance, investigate data discrepancies and recommend improvements to existing data management and analytical processes.
Essential Skills and Experience
- Bachelor's degree in Data Analytics, Information Technology, Computer Science, Statistics, Mathematics or a related discipline.
- Relevant professional experience in data analysis, business intelligence or data reporting.
- Strong knowledge of SQL and relational database management systems.
- Experience with Microsoft Power BI, Tableau or similar data visualisation platforms.
- Understanding of data cleansing, data transformation, data validation and data modelling.
- Experience analysing large datasets and preparing analytical reports.
- Knowledge of Microsoft Excel and advanced data analysis techniques.
- Understanding of data warehousing and cloud-based data management environments.
- Strong analytical thinking, problem-solving and attention to detail.
- Ability to communicate complex data findings through clear reports and visualisations.
- Strong written and verbal communication skills and the ability to work collaboratively within technical teams.
Desirable Skills
Experience or knowledge in one or more of the following areas will be highly regarded:
- Microsoft Power BI and DAX.
- Microsoft SQL Server and PostgreSQL.
- Microsoft Azure and Azure Data Lake.
- AWS cloud data services.
- Tableau and advanced dashboard development.
- Python for data analysis and automation.
- Data warehousing and ETL processes.
- Data integration and master data management.
- Statistical analysis and predictive modelling.
- Business intelligence and executive reporting.
- Data governance, data quality and information security.
What We Offer
- Opportunity to contribute to data analytics and business intelligence projects.
- Exposure to modern cloud data platforms and enterprise reporting technologies.
- A collaborative working environment with experienced technology professionals.
- Opportunities to work across software development, data integration and digital transformation projects.
- Professional development and opportunities to enhance technical capabilities.
How to Apply
Interested candidates are invited to submit their updated resume and a cover letter outlining their qualifications, relevant data analysis experience, technical skills and experience with business intelligence platforms.
We vet all employer accounts and do our best to keep job ads safe, but scams can still occur. Be cautious when sharing personal information — never provide financial details or make payments during the application process. For extra security, use the Apply button on our site when proceeding.