Job Title : Power BI Analyst

Location : Perth

Mode: Contract

Key Responsibilities

- Data Analysis and Reporting

- Collect, analyze, and interpret data from multiple sources.
- Develop interactive dashboards and reports using Power BI.
- Translate business requirements into meaningful reports and visualizations.
- Identify trends, patterns, and business performance indicators.

2. Power BI Development
- Design, develop, and maintain Power BI dashboards and reports.
- Create calculated columns, measures, and KPIs using DAX.
- Perform data transformation and cleaning using Power Query.
- Develop data models and establish relationships between tables.
- Implement Row-Level Security (RLS) where required.
- Publish and manage reports in Power BI Service.

3. Database Management
- Write SQL queries to extract and analyze data.
- Connect Power BI with SQL Server, Excel, SharePoint, and other data sources.
- Perform data validation and ensure data accuracy.
- Optimize queries and data models for better performance.

4. Business Collaboration
- Work with business stakeholders to understand reporting requirements.




- Gather requirements and convert them into technical solutions.
- Present analytical findings and insights to management.
- Provide support and training to end users.

5. Dashboard Maintenance
- Monitor and maintain existing Power BI reports.
- Troubleshoot data refresh and report performance issues.
- Schedule and manage automated data refreshes.
- Ensure data consistency, accuracy, and security.

Required Technical Skills

Skill

Required Knowledge

Power BI

Desktop, Service, dashboards, reports

DAX

Measures, calculated columns, CALCULATE, FILTER, time intelligence

Power Query

Data cleaning, transformation, M language

SQL

Joins, subqueries, CTEs, aggregations

Data Modeling

Star schema, relationships, fact and dimension tables

Excel

Pivot Tables, VLOOKUP/XLOOKUP, formulas

Data Visualization

Charts, KPIs, slicers, drill-through

Power BI Service

Workspaces, gateways, scheduled refresh, RLS

Interested candidates can send their updated resume to [email protected] or reach me @ M: 61283195529

📌 Power BI Analyst (Perth)
🏢 CareCone Group
📍 Perth