Senior Power BI & Data Warehouse Specialist

Ai Australia; Canberra; On-site; AUD 70,000 - 120,000; Full time

Benefits offered by this job

Visa sponsorship

Job summary

AI Talent is hiring a full-time Business Intelligence Developer to join its BI and analytics practice in Australia. The role requires willingness to travel to the Southern NSW/Canberra region and deep expertise in the Microsoft BI stack (SSAS/SSIS/SSRS/MSSQL) with Power BI.

You will work on data warehousing, ETL, and analytics projects, collaborating with IT and business stakeholders. Visa may be available for suitable candidates.

Qualifications

• Be willing to live in or travel to Southern region NSW / Canberra.
• Expertise in Full Microsoft BI Stack (SSAS, SSIS, SSRS, MSSQL) and T-SQL.
• Experience with Microsoft Power BI.
• Understanding of PowerShell and C#.
• Experience with data cleansing and data migration of very large datasets.
• Experience in data warehouse design and dimensional modelling (Kimball).
• In-depth understanding of OLAP, and ETL processes.
• Hands-on SharePoint Online and JavaScript experience.
• Experience with SCRUM and IT project management.
• 8+ years SQL Server experience; 7+ years consulting.

Responsibilities

• Develop BI solutions using Power BI and Microsoft BI tools.
• Document business requirements for BI and app solutions.
• Create technical documentation and functional specs for BI systems.
• Support analysts to translate interviews into user stories and acceptance criteria.
• Collaborate with stakeholders and team members to deliver BI deliverables.
• Assist with data cleansing, migration, and data warehouse design.
• Follow SCRUM practices in project delivery.

Skills

SSAS

SSIS

SSRS

MSSQL

T-SQL

Power BI

PowerShell

C#

Data warehousing

Dimensional modelling

Kimball

Azure

Office 365

SharePoint Online

JavaScript

SCRUM

CRM software

SQL Server

ETL

Data cleansing

Data migration

Tools

Power BI

Job description

AI Talent is hiring a full-time Business Intelligence Developer to join its BI and analytics practice in Australia. The role requires willingness to travel to the Southern NSW/Canberra region and deep expertise in the Microsoft BI stack (SSAS/SSIS/SSRS/MSSQL) with Power BI.

You will work on data warehousing, ETL, and analytics projects, collaborating with IT and business stakeholders. Visa may be available for suitable candidates.