Power BI Specialist

3 days ago

Greenacre, New South Wales, Australia Real Dairy Australia Pty Ltd Full time $80,000 - $120,000 per year

Real Dairy Australia (RDA) is an Australian owned and operated business with locations and manufacturing facilities throughout Australia.

With our head office located at Greenacre, RDA is a world class supplier of dairy-based products, services and solutions to the retail, foodservice and food ingredients markets.

We have an exciting opportunity to join our business as our Power BI Specialistat our state-of-the-art processing and packaging facility in Greenacre.

We are looking for someonewho will bring expertise in Power BI, data architecture, and reporting optimisation to review, rationalise, and migrate a large suite of information. The role will ensure reporting assets are efficient, secure, and aligned to modern data platform practices

The Role:

Duties and responsibilities will include.

  • Develop and maintain integrations with external systems using APIs.
  • Implement ETL (Extract, Transform, Load) processes to move and transform data.
  • Manage and Maintain MS Synapse and storage.
  • Develop and optimize SQL queries, stored procedures, functions, and triggers.
  • Analyse data from multiple sources to identify trends, insights, and opportunities.
  • Design and maintain dashboards, reports, and models in MS Power BI.
  • Assists analysts with development of PowerBI reports.
  • Present findings and recommendations directly to customers and internal stakeholders.
  • Continuously review and enhance reporting processes to improve accuracy and efficiency.
  • Contribute to process improvements, system updates, and delivery of business initiatives using agile methods.
  • User access control base on report and report contents.
  • Collaborate with business users to gather reporting requirements and translate them into visual solutions.
  • Schedule and publish reports to Power BI Service and manage data refresh schedules.
  • Identify data quality issues and present these to analysts and responsible business team.

Ideally, you will possess:

  • Bachelor's degree in IT.
  • 5+ years of relevant work experience in analytics, business intelligence, or insights.
  • Demonstrated success in delivering high-quality, accurate, and reliable reporting solutions.
  • Strong track record of working effectively in fast-paced environments.
  • Strong communication skills, with the ability to convey complex data findings to both technical and non-technical stakeholders.
  • Advanced skills in MS Synapse, API connection , SQL with proven experience working on complex queries and data models.
  • Proficiency with data visualisation tool Power BI and Fabric.
  • Utilise tools such as SQL (Azure SQL Database), Fabric & Power BI to perform analysis and create reporting solutions.
  • Proficiency in MS Excel to analyse advanced Excel functions as input to the design of BI solutions.

This opportunity is only open to Australian Residents or Citizens