Data Analyst (Business Intelligence - BI) - Southampton - £35,000 - 45,000 + ben

BenchIT

Leading healthcare provider is actively recruiting for an experienced Data Analyst with a background in OLAP, ETL T-SQL and desirably the Microsoft BI

  • OLAP, ETL T-SQL
  • SSRS, SSIS, SSAS
Data Analyst (Business Intelligence - BI) – Southampton - £35,000 – 45,000 + benefits
 
Leading healthcare provider is actively recruiting for an experienced Data Analyst with a background in OLAP, ETL T-SQL and desirably the Microsoft BI stack - SSRS, SSIS, SSAS
 
This is an exciting opportunity to join the company during a period of growth putting to use existing skills whilst obtaining new ones.
 
The successful Data Analyst (Business Intelligence - BI) (OLAP, ETL T-SQL) will
 

  • Responsible for the migration of reports, KPI dashboards and MI reporting packs into Power BI, transitioning from Excel, SSRS and other platforms
  • Translate new business needs into technical specifications and develop new reporting solutions
  • Collaborate with data analysts to produce BI Functional Specifications
  • Create documentation for BI Procedures, Data Dictionaries, and other related knowledgebase material
  • Conduct data transformations and SQL query troubleshooting
  • Identify data gaps, anomalies and errors
  • Perform ad-hoc requests for project stakeholders
 
Experience for the positon of Data Analyst (Business Intelligence - BI) (OLAP, ETL T-SQL)
 
  • Background in data warehousing (e.g. dimensional modelling) and data mining
  • In-depth understanding of online analytical processing (OLAP) and ETL (Extract, transform, load) processes
  • Desirable full stack Microsoft BI experience i.e. SSRS, SSIS, SSAS
  • Desirable expertise in Microsoft PowerBI and DAX query language
  • Ability to effectively prioritise and execute tasks
  • Advanced T-SQL skills for data analysis and manipulation, sub-queries, joins, common table expressions etc.