02 Aug
|
Ampstek
|
New South Wales
02 Aug
Ampstek
New South Wales
Job Title: Power BI With Data Modelling, SSIS
Location: Sydney (Onsite)
Contract
Job Description
We are seeking an experiencedPower BI Developerwith strong expertise inData Modelling,SSIS, andPower BIto support the enhancement and optimization of enterprise reporting solutions.
Key Responsibilities
Fine-tune and optimize existing data models to improve reporting performance and scalability.
Design, develop, and maintain effective data models for Power BI reporting.
Develop and enhanceSSIS packagesto extract, transform, and load (ETL) data from multiple source systems.
Integrate recent data feeds from various source systems into the existing data warehouse and reporting environment.
Build and optimize Power BI datasets, reports, and dashboards to deliver accurate and actionable business insights.
Improve query performance using optimized data modelling techniques and DAX.
Collaborate with business stakeholders and technical teams to understand reporting requirements and implement scalable solutions.
Perform data validation, troubleshooting, and performance tuning across ETL and reporting layers.
Ensure data quality, consistency, and governance throughout the reporting lifecycle.
Required Skills
5+ yearsof experience in Business Intelligence or Data Engineering.
Solid experience inData Modelling(Star Schema, Snowflake Schema, Dimensional Modelling).
Hands-on experience withMicrosoft SSISfor ETL development and data integration.
Strong expertise inPower BI, including Power Query, DAX, data modelling, dashboards, and report development.
Experience working with SQL Server and writing complex SQL queries.
Knowledge of performance tuning and optimization for Power BI datasets and reports.
J-*-Ljbffr
📌 Power Bi With Data Modelling New South Wales
🏢 Ampstek
📍 New South Wales