Data Analyst
Share
Job Location:
Auckland - New Zealand
Monthly Salary:
Not Disclosed
Posted on:
3 hours ago
Vacancies:
1 Vacancy
Job Summary
We are looking for a driven Data Analyst to join our data team. You will play a crucial role in our ongoing migration from a legacy Azure SQL Data Warehouse to a modern Microsoft Fabric environment.
This role is a unique mix of forensic data analysis and modern data engineering. A significant part of your early work will involve analysing and translating existing data models from our legacy tool (WhereScape RED) and rebuilding robust scalable pipelines models and reporting layers in Microsoft Fabric and Power BI.
Key Responsibilities
- Data Migration & Engineering: Assist in the end-to-end migration of our data warehouse from Azure SQL to Microsoft Fabric.
- Legacy System Analysis: Analyse decipher and extract business logic data models and ETL pipelines currently housed in WhereScape RED.
- Pipeline Development: Build test and optimise data ingestion and transformation pipelines using PySpark and SQL within the Fabric ecosystem.
- Comprehensive Data Modeling: Design and implement diverse data models across the pipeline. This includes structuring foundational common data layers as well as designing the final Gold layer using dimensional modeling and star schemas specifically optimised for downstream analytics.
- Analytics & Reporting: Develop and maintain core reporting datasets and dashboards using Power BI to ensure business stakeholders have accurate actionable insights.
- Data Validation: Ensure data integrity and continuity between legacy and new systems during the migration process.
Qualifications :
- SQL Mastery: Strong demonstrable proficiency in writing complex highly optimised SQL queries.
- PySpark Experience: Practical knowledge of PySpark for data processing and transformation.
- Data Lakehouse Architecture: A firm understanding of modern Data Lakehouse principles (such as Delta tables and the Medallion architecture) and how they apply to building scalable data solutions.
- Data Modeling: A strong grasp of broader data warehousing concepts including experience moving data through various modeling stages (from staging and common layers up to dimensional/star schema design).
- Power BI Proficiency: Crucial hands-on experience building datasets DAX measures and reports within Power BI.
- Microsoft Fabric: Practical experience or a strong foundational understanding of the Microsoft Fabric ecosystem (OneLake Data Engineering Data Factory).
- Workspace Management: Familiarity with organising navigating and managing Microsoft Fabric and Power BI workspaces including understanding deployment pipelines and basic governance.
- WhereScape RED: Experience with WhereScape RED is highly required to help us efficiently deconstruct and reverse-engineer the legacy environment.
- Problem-Solving Mindset: Excellent analytical skills with the patience and ability to untangle complex legacy business logic.
Additional Information :
Why join our Abano Healthcare
- Hybrid working model enjoy flexibility with 3 days in the office and 2 days working from home.
- Purposedriven organisation your work directly supports clinicians delivering essential healthcare across Australia and New Zealand.
- Professional growth opportunities to work with modern Microsoft technologies and influence the evolution of our data and integration platforms.
- Supportive team culture collaborate with passionate skilled professionals across digital data HR finance and operations.
- Career development access to learning opportunities crossfunctional exposure and the chance to shape bestpractice integration standards.
- Employee perks discounts across our dental network wellbeing initiatives and access to employee assistance programmes.
- Stable growing organisation be part of a large established healthcare group with longterm investment in digital transformation.
Remote Work :
No
Employment Type :
Full-time
Key Skills
About Company
Are you ready to join an industry that's always evolving, in a workplace that's constantly buzzing with energy and innovation? Look no further! Sydney Periodontics in Castle Hill is seeking a dynamic and friendly Casual Dental Assistant to join our exceptional team.Days: Wednesday to ... View more
