Senior Data & Analytics Advisor - Regulatory Insights

Victorian Gambling And Casino Control Commission; City of Melbourne; On-site; AUD 70,000 - 120,000; Full time

Benefits offered by this job

Visa sponsorship

Job summary

AI Talent is seeking a full-time Business Intelligence Developer to join a fast-growing BI and analytics practice. The role focuses on delivering robust BI solutions using the Microsoft BI stack (SSAS/SSIS/SSRS/MSSQL) and Power BI, with emphasis on data warehousing, ETL, and data migration for large datasets.

The candidate will collaborate with analysts and stakeholders, document requirements, and translate insights into technical specifications while working in a SCRUM environment.

Qualifications

• Experience with full Microsoft BI stack (SSAS, SSIS, SSRS, MSSQL).
• Experience in business analytics solutions tools Microsoft Power BI.
• Strong knowledge of data warehouse design and dimensional modelling (Kimball).
• Experience with ETL, OLAP, and data migration of large datasets.
• Hands-on scripting in PowerShell and familiarity with C#.
• Background in documenting requirements and crafting technical specifications for BI applications.

Responsibilities

• Design, develop and maintain BI solutions using Microsoft BI stack.
• Generate data insights and actionable reports with Power BI.
• Create technical documentation and functional specifications for BI systems.
• Support Business Analysts by translating user interviews into user stories and acceptance criteria.
• Collaborate with SCRUM teams and manage BI-related IT projects.

Skills

Microsoft BI Stack

Power BI

PowerShell

C#

ETL

Data warehouse design

Kimball modelling

SQL Server

T-SQL

SSAS

SSIS

SSRS

DAX

Azure

SharePoint Online

JavaScript

SCRUM

CRM software

SQL

Tools

Power BI

SQL Server

Azure

Office 365

SharePoint Online

JavaScript

Job description

AI Talent is looking for a full-time Business Intelligence Developer to join the fast-growing BI and analytics practice.

• Be willing to live in or travel to Southern region NSW / Canberra.
• Expertise in Full Microsoft BI Stack,(SSAS, SSIS, SSRS, MSSQL) T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and Analysis Services Tabular (SSAS) and DAX.
• Experience in business analytics solutions tools Microsoft Power BI.
• Understanding of PowerShell and C#.
• Experience with data cleansing and data migration of very large datasets.
• Experience in designing process maps, data flows, and technical solutions.
• Experience in data warehouse design and dimensional modelling (Kimball Methodology).
• Generate data insights using BI tools (Power BI)
• Strong technical knowledge of modern cloud technologies and Infrastructure including Azure, Office 365 (Teams, SharePoint, OneDrive, Exchange, Power Automate, etc.)
• Experience in scripting languages, such as PowerShell, to build automation and process data.
• Background in data warehouse design (e.g. dimensional modelling) and data mining.
• In-depth understanding of database management systems, online analytical processing (OLAP), and Extract, Transform, Load framework (ETL).
• Hands-on SharePoint Online experience and JavaScript
• Prior experience in managing IT Projects.
• Knowledge in self-learning predictive models with machine-learning algorithms
• Test, Debug, and Fix errors in different applications.
• Document business requirements for BI and App solutions.
• Create technical documentation.
• Develop functional specifications for use by BI and System developers.
• Support our Business Analysts to translate user interview results into user stories, acceptance criteria, and simple wireframes.
• Good verbal and written communication skills to effectively collaborate with team members and stakeholders.
• Proven business acumen and problem-solving aptitude
• Proven abilities to take initiative and be innovative
• Work with SCRUM methodology.
• Knowledge of CRM software
• 8+ years working with relational databases SQL Server and proficient with structured and unstructured data
• 7+ years of consulting experience
• A strong passion for learning and adapting to new technologies.

Visa can be provided for a suitable candidate.

Base pay range

A$70,000/yr - A$120,000/yr