Back to jobs

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:
  • 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.
Essential Skilllset:
  • 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
If you have the relevant experience and required skill-set please apply today to be considered for this opportunity.  Please apply by submitting your application in word format only, or for further information, please email Martin Castle or Frances Standen at ICT@troocoo.com