At a Glance
- Tasks: Write SQL queries, analyse data, and create reports using Power BI.
- Company: Join a leading firm in financial services focused on data-driven decision making.
- Benefits: Enjoy a hybrid work model and competitive salary up to £55k per annum.
- Why this job: Be part of impactful projects that enhance data management and governance.
- Qualifications: 5+ years in data analysis with strong SQL and Power BI skills required.
- Other info: Opportunity to work on large-scale HR system projects and gain certifications.
The predicted salary is between 39600 - 66000 £ per year.
Salary: Up to £55k per annum
Job Type: Permanent
Hybrid Model: TBC
Location: London or Portsmouth
Key Responsibilities
- Write SQL queries to extract, manipulate, and analyse data from various sources (databases, APIs, spreadsheets, etc.).
- Map, clean, and process data to ensure consistency and accuracy.
- Perform exploratory data analysis to identify trends and recommend master data management improvements.
- Develop reports and data visualizations using Power BI.
- Create and maintain solution and data-flow diagrams to support governance and documentation.
- Ensure data security and compliance with industry standards such as GDPR.
- Collaborate with IT teams and stakeholders to understand business requirements and ensure data accessibility.
Requirements
- 5+ years of experience in BI, Data Analysis, or Reporting, preferably in financial services.
- Proven experience in data analysis across at least two large-scale HR system replacement projects involving data migration (ideally SAP SuccessFactors and Sage People).
- Strong expertise in SQL and data visualization tools (Power BI preferred).
- Hands-on experience working with data across the Hire to Retire value stream.
- Ability to work with large datasets, ensuring data accuracy and integrity.
- Excellent problem-solving skills and the ability to present insights to both technical and non-technical stakeholders.
- Understanding of data security, GDPR compliance, and best practices in data governance.
Desirable
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- Microsoft Certified: Azure Data Fundamentals (DP-900)
To be considered, please ensure you complete your application on the Computappoint website.
Data Analyst (SQL) employer: Computappoint
Contact Detail:
Computappoint Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst (SQL)
✨Tip Number 1
Familiarise yourself with the specific SQL queries and data visualisation techniques mentioned in the job description. Practising these skills will not only boost your confidence but also prepare you for potential technical assessments during the interview process.
✨Tip Number 2
Network with professionals in the financial services sector, especially those who have experience with HR system replacements. Engaging in conversations can provide insights into the role and may even lead to referrals that could enhance your application.
✨Tip Number 3
Prepare to discuss your previous projects involving data migration and analysis, particularly those related to large datasets. Be ready to share specific examples of how you ensured data accuracy and integrity, as this will demonstrate your hands-on experience.
✨Tip Number 4
Stay updated on GDPR compliance and data governance best practices. Being knowledgeable about these topics will not only help you in interviews but also show that you are proactive and serious about data security, which is crucial for this role.
We think you need these skills to ace Data Analyst (SQL)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience in data analysis, particularly with SQL and Power BI. Include specific examples of projects you've worked on, especially those related to HR system replacements.
Craft a Strong Cover Letter: Write a cover letter that addresses the key responsibilities and requirements listed in the job description. Emphasise your 5+ years of experience and any relevant certifications, such as Microsoft Certified: Power BI Data Analyst Associate.
Showcase Your Technical Skills: In your application, clearly outline your technical skills, particularly your expertise in SQL and data visualisation tools. Mention any hands-on experience with large datasets and your understanding of data security and GDPR compliance.
Highlight Collaboration Experience: Since the role involves collaboration with IT teams and stakeholders, include examples of how you've successfully worked with others to meet business requirements and ensure data accessibility in your previous roles.
How to prepare for a job interview at Computappoint
✨Showcase Your SQL Skills
Be prepared to discuss your experience with SQL in detail. You might be asked to solve a problem on the spot, so brush up on writing queries and manipulating data. Highlight specific projects where you successfully used SQL to extract and analyse data.
✨Demonstrate Data Visualisation Expertise
Since Power BI is preferred, make sure you can talk about your experience with it. Bring examples of reports or dashboards you've created, and be ready to explain how they helped stakeholders make informed decisions.
✨Understand Data Governance and Compliance
Familiarise yourself with GDPR and data security best practices. Be ready to discuss how you've ensured compliance in past roles, as this is crucial for the position. Showing that you take data governance seriously will impress your interviewers.
✨Prepare for Problem-Solving Questions
Expect questions that assess your analytical thinking and problem-solving skills. Think of scenarios where you've identified trends or solved complex data issues, and be ready to walk through your thought process during the interview.