Job
Description
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. Show more Show less
