Search

BI & Data Warehouse Analyst - PL / SQL

Posted: 13/11/24
Recruiter:Computer Futures
Reference:2849071440
Type:Permanent
Disciplines: Analyst
Salary:£60,000 - £70,000 Annual Benefits
Location:London
Description:

BI & Data Warehuse Analyst

60,000 - 70,000

Hybrid - 3 days on site (London Zone 2) and 2 days remote

I'm currently recruiting for a BI & Data Warehouse Analyst responsible for owning the reporting workstream.

The BI & Data Warehouse Analyst will be responsible for extracting, managing and delivering the reporting requirements across different departments

This role requires a solid understanding of SQL, Designing/modifying data warehouses and creating reports using the NetSuite Analytics and Data Warehouse application.

What the role will entail:

  • Technical Support:
    • Understanding and owning the NetSuite Analytics and Data Warehouse application including:
      • The Data Pipelines (NetSuite NSAW)
      • The Data Warehouse
      • The Data Augmentation and Reporting feature
    • Using Oracle SQL Developer, to interrogate, modify and develop the existing data warehouse model to meet business requirements
    • Create physical data models to support business requirements
    • Manage and maintain the data warehouse via 3rd parties when required
    • Troubleshooting and running route cause analysis
  • IT Operations:
    • Single point of contact for Reporting within the organisation
    • Laise with stakeholders to identify areas that could benefit from reporting
    • Understand the existing saved searched reporting in NetSuite
    • Ensuring reliability of data across the architecture
  • Project Support
    • Own the overall data strategy across the enterprise
    • Design reporting solutions to support the business
    • Work with the Business Analyst to understand the requirements
    • Assist in the estimation of project work
  • Documentation and Knowledge Management:
    • Create and maintain reporting documentation (e.g. Data Dictionary)
    • Provide support and training for users

Experience/Key Skills Required

  • Essential:
    • At least 5 years experience within BI & Data Warehousing
    • Oracle SQL Developer
    • Hands on SQL and Data Warehousing experience
    • Data Modelling
  • Desirable:
    • Patchworks iPaaS experience
    • NetSuite Analytics Warehouse (NSAW) and Oracle

To find out more about Computer Futures please visit (url removed)

Computer Futures, a trading division of SThree Partnership LLP is acting as an Employment Business in relation to this vacancy Registered office 8 Bishopsgate, London, EC2N 4BQ, United Kingdom Partnership Number OC(phone number removed) England and Wales

Recruiting now