Business Intelligence Analyst

Job Title: Business Intelligence Analyst

Talent Formula is a consulting firm that offers outsourced financial and accounting talent to Chartered Accounting firms worldwide. We are currently sourcing for a Global Accounting Firm's Gold Coast (Australia) Office, who are looking to expand their Business Intelligence team.

As a BI Analyst you will be working across multiple business stakeholders, tech / IT teams and internal professional staff to develop assets with Power BI and other technologies.

Must Have Requirements:

•      4-5 years + relevant work experience in analytics, business intelligence or data science.

Power BI

•      Data Modelling

•      DAX, M Code and Power Query (Master Level of at Least One)

•      High-Level Knowledge of Best Practices

•      Advanced ETL (Extract Transform Load) Skills

•      Setting up Power BI Data Gateways

•      SQL

•      Some level of business acumen/experience. (Accounting desirable but not necessary)

Practical understanding of the below concepts is highly advantageous:

•      Complex Star Schema Models, ability to resolve and manage circular dependencies in complex datasets, understanding of bidirectional filtering/many to many relationships.

•      DAX: Rolling Averages, YTD/QTR totals, dynamic time intelligence, summarising and joining tables at the DAX level (Not Power Query), Cumulative Calculations both in table and in measure.

•      DAX Functions: SUMMARIZE, TOPN, ADDCOLUMNS, SELECTCOLUMNS, RANKX, VAR, SWITCH, ISERROR, IFERROR, COALESCE.

•      Power Query: Parameters/Variables, Dynamic Queries, Query Foldings, Joins, Extract JSON etc.

•      Row Level Security Multiple Groups, or Multi Requirement Interaction.

•      Power BI Service Delivery Methods, Knowledge of Licence Requirements, Power BI Apps.

•      Bookmarks to create interactive pop up menus and page variations. Ability to work around lacking real estate in reports.

•      Import vs Direct Query

Highly Valued Skills (Should have few of the below):

•      Microsoft Azure/Data Factories

•      ETL from API Endpoints

•      Power Apps Development

•      Power Automate Development

•      Advanced SQL

•      Financial Reporting / Accounting Skills Custom Chart of Accounts In PBI

•      Tableau – Would need to be high level experience of end-to-end delivery to be worthwhile.

•      Paginated Reports Power BI Experience

•      UI/UX and Design Skills

Note: Candidates will be asked to provide a sample of their work in Power BI by providing the PBIX file of a project they have worked on (can be a passion project).

How to apply?

To be considered for this role, you must complete 3 steps:

1. Apply to this job and upload your resume
2. Complete the Skills Tests for this role you must follow the link below and complete the testing assessments. The first assessment is a Skills Test, to assess your technical ability and numerical reasoning.
3. Complete the Psychometric Test for this role
4. If you successfully clear the Skills Test, you will be redirected to a Psychometric Test to assess how you think and make decisions.

.

If you do not complete the assessments then you will not be considered for the role.