Power BI Developer
$70,000–$120,000 year
On-siteSydney, New South Wales, Australia
Job Summary
Design and develop business intelligence solutions using the Microsoft Power BI stack, including SSAS, SSIS, SSRS, and T-SQL. Lead data warehouse design and dimensional modeling projects while managing large dataset cleansing and migration tasks. Automate processes with PowerShell and C# scripts, and test, debug, and fix errors across applications. Collaborate with business analysts to translate user interviews into stories and wireframes, then create technical documentation and functional specifications. Manage IT projects using SCRUM methodology and support stakeholders with verbal and written communication.
Required Qualifications
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.