We are seeking a skilled Data Analyst to join our team on a fixed-term contract for 1 year, covering a maternity leave. The ideal candidate will have a strong background in data analysis and responsibilities include processing, and analyzing large datasets to provide actionable insights. Proficiency in SQL, along with experience in using data visualization tools such as Power BI, is essential. If you are a detail-oriented professional with excellent analytical skills and a passion for data, we encourage you to apply.
Key Responsibilities
- Work within Financial Data team.
- Writing SQL Scripts, Views and Stored procedures.
- Communicating logic of Scripts and dashboard designs to internal colleagues.
- Adapt and change dashboards and reports at stakeholder’s request.
- Support developing Data warehouse, process automation, BI solutions and reports.
- Provide relevant datasets and reports to enable exception reporting.
- Data quality, cleaning, preparation and profiling knowledge.
- ETL techniques and Data visualisation methods.
- SQL Server
- Power BI
- SQL Server Integration Services (SSIS)
Skills Knowledge and Expertise
- Enthusiastic, Curious and Quick learner.
- A self-starter and detail oriented, with common sense and problem-solving approach.
- Able to deal with multiple issues, tasks and priorities concurrently.
- A great communicator with an ability to quickly establish rapport.
- Proven experience of SQL/ T-SQL development (from 2-4 years writing complex queries, developed MSSQL database tables, stored procedures, user defined functions, views, SQL agent jobs and SSIS packages to design specifications.).
- Dashboard development experience (PowerBI / DAX / Power Query).
- ETL tool: SSIS (2-3 years).
- Excel: Competent using various in-built functions.
- Knowledge of Data warehouse.
- Knowledge of tech or Subscription based industry (Awareness of MRR, ARR or similar).
- Worked with Data as part of a Finance Team.
Benefits
- Remote / Hybrid working
- Healthcare
- Life insurance
- 6 weeks - work anywhere option per year
- Employee Assistance program
- Contributory retirement savings plan
- Opportunities for training & development
- Great team and culture
- Discounts portal
- Income protection Insurance
- Online GP services