Business Intelligence Solution Designer
Job description
TROOCOO are currently partnered with one of Queensland's largest employers and have an immediate need for a BI Solution Designer. The Business Intelligence Designer/Developer will work closely with architects, business users, technology teams and business owners.
Role Responsibilities:
Role Responsibilities:
- Creating star schema data models, performing ETL's and validating results with business representatives
- Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
- Create best practices for data loading and extraction.
- Develop data architecture, data modelling, and ETL mapping solutions within structured data warehouse environment.
- Develop reporting applications and data warehouse consistency.
- Familiar with ERP and or Financial Reporting outcomes (P&L, Balance Sheet and General Ledger Reporting)
- Relevant experience and knowledge of BI implementation methodologies, including database design or integration experience with SQL server databases;
- Dimensional Modelling (Kimball Methodology)
- Relational database and SQL language
- Extraction, transformation and loading knowledge and or exposure (ETL) preferably at an Enterprise level Informatica, DataStage or equivalent
- Demonstrated experience in Power BI or Similar Technologies e.g. Cognos Analytics, SAP BOetc
- Demonstrated experience in data analysis, data modelling, data warehousing and database design;
- Demonstrated experience in BI Solution Design and Report Development in large complex environments