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.
• Significant experience leveraging Power BI to benefit a range of industries and scenarios.
• 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:

• Apply to this job and upload your resume
• 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.
• Complete the Psychometric Test for this role
• If you successfully clear the Skills Test, you will be redirected to a Psychometric Test to assess how you think and make decisions.
  
  

To complete these tests, you must go to https://es.peoplogicaskills.com/es/quiz?testId=717c8fb1106c28c8 and complete the assessments.

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