At a Glance
- Tasks: Design and develop reports, dashboards, and visualisations using SQL and Power BI.
- Company: Join a leading investment banking firm with a focus on innovation.
- Benefits: Competitive salary, professional development, and a dynamic work environment.
- Other info: Work onsite in Canary Wharf, collaborating with cross-functional teams.
- Why this job: Make a real impact by delivering insights that drive strategic decisions.
- Qualifications: 10+ years in SQL development and experience with reporting tools like Power BI.
The predicted salary is between 60000 - 80000 £ per year.
We are seeking an experienced SQL Data Analyst and Reporting Developer to design, develop, and maintain reports, dashboards, and visualisations that support this strategic program. You will work with multiple internal data sources to present move schedules, inventory, user details, and hardware asset tracking.
Key Responsibilities
- Develop and maintain OLAP Cubes, Excel reports using Power Query and Power Pivot (including DAX).
- Build and maintain dashboards and visualisations in Power BI and Tableau from SQL sources.
- Collaborate with cross-functional teams to deliver reports and analytics to meet program deadlines.
- Ensure accurate, timely, and high-quality data reporting across multiple systems.
Technology & Tools
- SQL database architectures and writing complex T-SQL queries
- Data warehousing concepts and OLAP reporting services
- Power BI and Tableau development
- Microsoft SQL Server & Management Studio
- Microsoft Excel
- Power Query and Power Pivot (DAX)
- Salesforce
- Tableau
Qualifications & Experience
- Bachelor’s degree in computer science, Information Technology, or related field
- 10+ years’ experience in SQL development, dashboards, and reporting tools (Power BI/Tableau)
- Proven experience as a SQL Developer or similar role
- Strong analytical and problem-solving skills
- Excellent communication and collaboration skills
Why Join Us
This is a unique opportunity to play a key role in a high-profile investment banking program, delivering actionable insights and visualisations that support strategic decision-making.
SQL Data Analyst employer: Trades Workforce Solutions
Join a leading investment banking firm located in the vibrant Canary Wharf, where you will have the opportunity to contribute to high-profile projects that drive strategic decision-making. Our collaborative work culture fosters innovation and professional growth, offering extensive training and development opportunities to enhance your skills in SQL and data analytics. With a focus on delivering quality insights, we provide a dynamic environment that values your contributions and supports your career advancement.
Contact Details:
Trades Workforce Solutions Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land SQL Data Analyst
✨Tip Number 1
Network like a pro! Reach out to your connections in the investment banking sector and let them know you're on the lookout for SQL Data Analyst roles. A personal recommendation can go a long way in landing that interview.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best SQL reports, dashboards, and visualisations. This will give potential employers a taste of what you can do and set you apart from the competition.
✨Tip Number 3
Prepare for interviews by brushing up on your technical skills. Be ready to discuss your experience with OLAP cubes, Power BI, and Tableau. We want you to feel confident when answering those tricky questions!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace SQL Data Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the SQL Data Analyst role. Highlight your experience with SQL, Power BI, and Tableau, and don’t forget to mention any relevant projects that showcase your skills in data reporting and analytics.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this role. Mention specific experiences that align with the job description and show us your passion for data analysis and reporting.
Showcase Your Technical Skills:We want to see your technical prowess! Be sure to include examples of complex T-SQL queries you've written, OLAP cubes you've developed, and any dashboards or reports you've created using Power BI or Tableau.
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity in investment banking. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Trades Workforce Solutions
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills, especially complex T-SQL queries. Be prepared to discuss your experience with OLAP cubes and how you've used them in past projects. Practising some sample queries can really help you feel confident during the technical parts of the interview.
✨Showcase Your Reporting Skills
Since the role involves developing reports and dashboards, be ready to talk about your experience with Power BI and Tableau. Bring examples of dashboards you've created and be prepared to explain the thought process behind your design choices. Visuals can speak volumes!
✨Collaboration is Key
This position requires working with cross-functional teams, so highlight your collaboration skills. Think of specific instances where you worked with others to deliver a project or solve a problem. Being able to communicate effectively with different stakeholders is crucial.
✨Prepare for Scenario Questions
Expect scenario-based questions that assess your analytical and problem-solving abilities. Prepare by thinking through how you would approach common challenges in data reporting and visualisation. This will show your potential employer that you can think critically and adapt to various situations.
