Sr Business Intelligence Specialist

Job details

The Department of Agriculture, Fisheries and Forestry (DAFF) is looking for a Power BI Data Engineer to join the Digital Transformation Program in theAustralian Bureau of Agricultural and Resource Economics and Sciences(ABARES) to work across several data and analytics platforms. The candidate will design, build, and optimise Power BI solutions, with strong expertise in data modelling, SQL, and Azure Databricks. The ideal candidate will have experience in Azure Data Factory, Azure DevOps, CI/CD, and Git version control, ensuring scalable and well-structured data products. This role is highly collaborative, requiring close engagement with business stakeholders and development teams to deliver high-quality, user-driven insights.

Key duties and responsibilities

Key Responsibilities:

• Develop and optimise Power BI solutions, including reports, dashboards, and data models tailored to business needs.
• Design and implement efficient data models, ensuring they are optimised for performance and usability.
• Collaborate closely with business users and cross-functional teams to translate business requirements into actionable Power BI solutions.
• Develop and maintain ETL/ELT workflows in Azure Data Factory to ensure reliable and efficient data ingestion.
• Implement and maintain CI/CD pipelines in Azure DevOps, ensuring smooth deployment and version control with Git.
• Optimise Power BI reports for performance, usability, and scalability.
• Ensure compliance with data governance, security, and privacy best practices.
• Continuously improve and refine data engineering and BI best practices, ensuring consistency and efficiency across projects.

Preferred Skills & Experience:

• Strong expertise in Power BI, including DAX, Power Query (M), and advanced data visualisation techniques.
• Proficiency in SQL for data transformation, query optimisation, and data modelling.
• Experience working with Azure Databricks for data processing and analytics.
• Hands-on experience with Azure Data Factory for orchestrating and automating data workflows.
• Experience collaborating with cross-functional teams, including business users, analysts, and developers, to improve BI solutions and data infrastructure.
• Strong analytical and problem-solving skills with a proactive approach to identifying and resolving issues.
• Excellent communication and teamwork skills, ensuring alignment between business needs and technical implementation.