Quick Overview
Seniority
Mid Senior
Employment type
Full Time
Work mode
Hybrid
Location
Australia
SQLETLPower BI
Job Description
Total Synergy is a private-equity-backed global software business providing project management software for architecture and engineering consultancies. Operating in Australia, the UK and now the US, our people enable us to make a difference every day to our customers and help them find the clearest path to project profitability.
Responsibilities- Design, build and maintain advanced Power BIreports and dashboards that give Total Synergy customers real clarity over their data.
- Get hands-on with DAX, writing advanced measures and calculations - from time intelligence to calculated tables.
- Shape robust, well-structured data models(think star schema) that keep reports accurate and fast.
- Write and optimise complex SQL queries and build and maintain the views that power our reporting.
- Own database and ETL platform administration tasks like configuring new workflows, optimising database performance through indexing, and deploying new customer databases.
- Partner directly with clients - understanding their requirements, troubleshooting issues, and presenting solutions that land.
- Bring your problem-solvinginstincts to bear on complex data challenges, thinking outside the box to find the best answer.
- Collaborate with the team and wider business, sharing knowledge and helping us all get better at what we do.
- Spot opportunities to use AI toolsto work smarter - in Power BI, in SQL, and in your day-to-day.
What you need to succeed
- 5+ years' experience developing advanced Power BI reporting solutions.
- Advanced DAXskills - you write complex measures and know how to optimise for performance.
- Strong data modellingexperience, with a solid grasp of star schema design and best practice.
- Advanced SQLskills - from writing and optimising complex queries to developing views and handling database administration.
- Experience working directly with clients or stakeholders to gather requirements and present solutions with confidence.
- Sharp problem-solving instincts and the creativity to find answers to complex data challenges.
- Strong communication skills and the ability to thrive as part of a small, distributed team.
Nice to have
- Experience with third-party Power BI tools such as Tabular Editorand DAX Studio.
- Agenuine interest in using AI tools to sharpen your Power BI/SQL work and everyday productivity.
- Microsoft Certified: Power BI Data Analyst (PL-300)or similar certification.
- Annual work'versary day off
- Fully hybrid work
- Competitive salary + super, reflecting the seniority of this role
- New tech to work your very best + company swag
Successful candidates must hold full working rights in Australia.
Similar jobs
- CY
Senior Analyst - Operational Intelligence - Cyber Intelligence
NewCyberCX
Australia🇦🇺HybridYesterdayTechnology - FC
Senior BI Developer: Power BI & Data Strategy, Hybrid
NewFirst Canadian
Queensland🇦🇺Hybrid2 days agoTechnology - FC
Business Intelligence Developer III
NewFirst Canadian
Queensland🇦🇺Hybrid2 days agoSQLT-SQLETL+3Technology - QE
Part-Time BI Analyst: Drive Health Outcomes with Data
Qec
Melbourne, Victoria🇦🇺Hybrid5 days agoSQLPower BITechnology - HG
Insights & Visualization Architect
HCF group
Sydney, New South Wales🇦🇺Hybrid1 week agoSQLTableau - RC
Senior BI Analyst: Hybrid, Power BI & Azure Data Expert
Regal Cream Products Pty Ltd
Colac, Victoria🇦🇺Hybrid1 week agoTechnology