Data Analyst (Data Warehouse)

Lanark  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

Job description:

  • Co-ordinate with Business Analysts and Data Modellers to provide technical analysis of databases, including:
  • Identifying table(s)/attribute(s) required
  • Identifying table joins and limitations to consider
  • Identifying data quality issues
  • Basic Volumes
  • Defining how to create reports for Microstrategy
  • Providing Business Process understanding
  • Testing Data Warehouse's data against source
  • Providing analysis and solutions to Data Warehouse's data issues
  • Identifying Data Model limitations

Required Skills:

  • Experience of 4-5 years with RDBMS like Oracle, SQL Server
  • Experience of ETL, Data Warehousing and Dimensional models
  • Experience on any Datawarehouse Appliances like Netezza, Teradata, Redshift, etc.
  • Good understanding of relational data models
  • SQL query writing skills
  • Problem-solving skills
  • Written and verbal communication skills
  • BI Reporting general skills (Tableau, MicroStrategy, PowerBI, etc)
Start date
n.a
From
Global Rekrut
Published at
26.07.2021
Project ID:
2170451
Contract type
Freelance
To apply to this project you must log in.
Register