Power Bi Developer

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 looking for a full-time Business Intelligence Developer to join the fast-growing BI and analytics practice.

Requirements

• 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 toolsMicrosoft 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.

Benefits

Your actual pay will be based on your skills and experience.

Base pay range

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