Power BI Developer
$70,000–$120,000 year
On-siteMelbourne, Victoria, Australia
Job Summary
Design and develop business intelligence solutions using the full Microsoft BI stack, including Power BI, SSAS, SSIS, SSRS, and T-SQL. Lead data warehouse design and dimensional modeling projects, managing large dataset cleansing and migration while automating processes with PowerShell and C#. Collaborate with business analysts to translate user stories into technical specifications and functional requirements, supporting the delivery of BI and application solutions. Test, debug, and fix errors across applications while documenting business and technical requirements. Work within a Scrum methodology to deliver data insights and predictive models, managing IT projects with a focus on Azure infrastructure and cloud technologies.
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
Desired Qualifications
- A strong passion for learning and adapting to new technologies.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.