Business Intelligence Analyst

  • Roland
  • Reading, UK
  • Sep 03, 2019
Full time Data Science

Job Description

Roland Europe Group Ltd.
Roland is a world leader in the design, manufacture and distribution of electronic musical instruments including; keyboards & synthesisers, guitar products, electronic percussion kits, digital recording equipment, amplifiers and audio processing devices.

The Position:
The business intelligence team ensures that the right information from system data is delivered through reports, dashboard, self-service platform (VI) and event-triggered feeds to the various business units and board members. The team supports management, to make accurate tactical and strategic decisions, in a timely manner. Within the team, these reports and information feeds, are developed by the BI Analysts.

Key Duties:
Reporting and Business Intelligence

  • Collaborate with the business to capture reporting requirements, act as functional analyst and bridge business and IT. Recommend and implement best practice for reporting.
  • Jointly responsible for the design, implementation and maintenance of the full reporting environment with the manager and other BI analysts.
  • Develop reports and dashboards in MicroStrategy, both in scheduled and interactive form (Web, iPad, iPhone, etc.).
  • Leverage SQL, MicroStrategy, excel and other reporting tools to create and maintain scheduled and Ad-hoc reports.
  • Maintain a deep understanding of business drivers and a grasp of business metric definitions.

 

Information Analysis/Modelling

  • Information / Data modelling and documentation.
  • ETL design for capturing data from external sources.
  • Report technical analysis, form factor and document design.

 

Data Warehouse

  • Development, maintenance and tuning of data warehouse.
  • Model data warehouse structures with re-usable dimensions.
  • Set-up and maintain futureproof, solid structure.
  • Database schematics design and documentation.

 

Training and Support

  • User training for self-service environment.
  • Provide support for BI questions / issues.

 

Key Attributes:

  • Extensive experience of working with MicroStrategy
  • SQL skills that allow you to comfortably and independently extract data from databases
  • Experience in building new and improving MicroStrategy dashboards and reports
  • Experienced data warehouse modeller
  • Ability to scope a problem, access relevant data and provide insights from the data
  • Expert in Excel with a proven track record
  • Understanding of key financial and operational performance metrics
  • Experience of working with multiple functions (e.g. finance, sales, marketing, operations)
  • Experience in providing training and support to MicroStrategy users
  • Demonstrable business partnering skills
  • Strong interpersonal skills, written and verbal
  • Strong organisational skills, including the ability to deal with multiple issues and prioritise
  • Independent worker that can operate effectively in a team environment
  • Strong analytical thinker
  • Results and task driven 

The Package
- Competitive Salary
- Private Healthcare
- Contributory pension