At a Glance
- Tasks: Develop and maintain SQL reports, dashboards, and visualisations for investment banking projects.
- Company: Leading investment bank in London with a focus on innovation.
- Benefits: Competitive salary, professional development, and collaborative work environment.
- Other info: On-site role in London with opportunities for career advancement.
- Why this job: Join a dynamic team and enhance your data analysis skills in a fast-paced industry.
- Qualifications: Bachelor's degree in IT or related field and 10 years of SQL experience.
The predicted salary is between 43200 - 72000 € per year.
Overview
Job Title: SQL Data Analyst and Reporting Developer
Location: London
Industry: Investment Banking
Job Summary:
We are seeking a skilled SQL Data Analyst and Reporting Developer to assist with the development and support of reports, dashboards and visualisations for program. There are a number of internal data sources to capture and present move schedules, inventory, user details and hardware asset tracking.
Responsibilities and Duties
- Develop and maintain OLAP Cubes, Excel reports from SQL using Excel Power Query and Power Pivot (inc DAX)
- Develop and maintain Dashboards and Visualisations in PowerBI/Tableau from SQL source
- Collaborate with cross-functional teams to meet project deadlines.
Technology Knowledge
- SQL DB architectures and creating complex SQL queries especially in the Microsoft eco-system (T-SQL)
- Data Warehousing
- OLAP Reporting Services, creating and maintaining OLAP Cubes
- Power BI
- Tableau
Product knowledge
- Microsoft SQL Server and Admin Studio
- Microsoft PowerBI
- Microsoft Excel Power Query and Power Pivot (inc DAX)
- Salesforce Tableau
Qualifications
- Bachelor\\\'s degree in Computer Science, Information Technology, or related field.
- 10 years of developing SQL, Dashboards, Power BI/Tableau
- Proven experience as a SQL Developer or similar role.
- Strong analytical and problem-solving skills.
- Excellent communication and teamwork abilities.
On-Site: London
Please send CVs to me if you meet every requirement
SQL Data Analyst and Reporting Developer in City of London employer: Jefferson Frank
As a leading player in the investment banking sector, we pride ourselves on fostering a dynamic and inclusive work culture that encourages innovation and collaboration. Our London office offers exceptional employee growth opportunities through continuous training and development, alongside competitive benefits that support work-life balance. Join us to be part of a team where your contributions are valued and you can make a meaningful impact in the world of finance.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Data Analyst and Reporting Developer in City of London
✨Tip Number 1
Network like a pro! Reach out to folks in the investment banking sector, especially those who work with SQL and data analytics. A friendly chat can open doors that a CV just can't.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL queries, dashboards, and any cool visualisations you've built. This is your chance to shine and demonstrate what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common SQL questions and scenarios. We recommend practising with real-world problems, so you can confidently tackle anything they throw at you.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take that extra step!
We think you need these skills to ace SQL Data Analyst and Reporting Developer in City of London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL skills and experience with Power BI/Tableau. We want to see how your background aligns with the role, so don’t be shy about showcasing relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about data analysis and how your skills can contribute to our team. Keep it concise but impactful!
Showcase Your Technical Skills:Since this role is all about SQL and reporting tools, make sure to list your technical proficiencies clearly. We love seeing specific examples of how you've used T-SQL or created dashboards in Power BI/Tableau.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Jefferson Frank
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries and OLAP cube development, as these are crucial for the role. Practising with real-world scenarios can help you articulate your thought process during the interview.
✨Showcase Your Reporting Skills
Since the job involves creating dashboards and visualisations, be ready to talk about your experience with Power BI and Tableau. Bring examples of your previous work or even a portfolio if possible. This will demonstrate your hands-on experience and give you an edge.
✨Collaboration is Key
Highlight your teamwork abilities during the interview. Discuss how you've collaborated with cross-functional teams in the past to meet project deadlines. This shows that you understand the importance of communication and working together to achieve goals.
✨Prepare Questions About the Role
Have a few insightful questions ready to ask the interviewer. This could be about the data sources you'll be working with or the specific challenges the team faces. It shows your genuine interest in the position and helps you assess if it's the right fit for you.
