Data and Reporting Analyst

 

The Role

To execute IT reporting strategy as defined by IT Manager to achieve company objectives and to ensure data is clear, accurate and easily utilised by stakeholders

 

Responsibilities  

  • Scope, document, and develop KPIs, Metrics and reporting dashboards using MS Power BI & SSRS
  • Scope, document, and develop reports from scratch using SQL/SSRS, Excel, Power BI
  • Develop and enhance our Analysis Cubes for stakeholder’s use
  • Build strong relationships with stakeholders to enable detailed requirements of reporting needs
  • Provide additional insights and findings to stakeholders
  • Configure existing and new SQL environments for optimal performance
  • Maintain the Data Warehouse, ensuring its fit for current and future analytics
  • Develop and maintain data feeds into the data warehouse, using ETL processes in SSIS
  • Plan and implement structural database requirements
  • Maintain database performance
  • Train and develop team members and users in the use of BI Software
  • Continued SQL and Reporting Services security monitoring
  • Any duties defined by IT Manager
  • Provide general IT Support as and when required

 

Requirements

  • Proven experience with Power BI / DAX / SQL / SSRS /SSIS
  • Good experience with data warehouse design, including dimensional modelling and data mining.
  • Good database management systems (OLAP) and ETL (Extract, Transform, Load)
  • Advantageous demonstration of machine learning
  • Excellent investigation and planning skills
  • Good communicator
  • Excellent presentation skills
  • Team player

 

Role competencies

  • Core competencies
  • Customer service
  • Health and safety
  • Teamwork and collaborating
  • Resilience and adaptability
  • Accountability and integrity
  • Diversity and inclusion

 

Technical/Job specific competencies

  • Planning and organising
  • Influencing and negotiation
  • Change management

 

 

Apply for this job
Showing 1–0 of 0 jobs
Share this job

Shaw Daniels Solutions (SDS) is backed by well-known industry experts, dedicated to making a real difference to the recruitment and staffing industry.

Address

The Hub
Fowler Avenue,
Farnborough,
Hampshire,
GU14 7JF.

Contact Us

office@shawdaniels.co.uk

01276 300700