SQL Data Analyst and Reporting Developer

Jefferson Frank; City Of London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading recruitment firm is seeking an experienced SQL Data Analyst and Reporting Developer in London. You will be responsible for developing reports, dashboards, and visualizations, utilizing extensive SQL and Power BI/Tableau expertise. Candidates must possess a Bachelor's degree in a relevant field and have 10 years of experience. Strong analytical and communication skills are essential for this on-site role.

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.

Responsibilities

• Develop and maintain OLAP Cubes, Excel reports from SQL using Excel Power Query and Power Pivot.
• Develop and maintain Dashboards and Visualisations in PowerBI/Tableau from SQL source.
• Collaborate with cross-functional teams to meet project deadlines.

Skills

OLAP Cubes development

Complex SQL queries

Data Warehousing

Power BI

Tableau

Excel Power Query

Excel Power Pivot

Analytical skills

Communication

Teamwork

Education

Bachelor's degree in Computer Science

Tools

Microsoft SQL Server

Salesforce Tableau

Job description

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