Data Analyst

Spait Infotech; United Kingdom; On-site; GBP 35,000 - 52,000; Full time

Job summary

Spait Infotech in the United Kingdom is seeking a data analyst to collect, clean, and analyze data from multiple sources and build insights that drive business decisions.

You will extract data with SQL, develop dashboards in Power BI, and collaborate with business teams to understand reporting requirements, ensuring accuracy and timely delivery of regular reports.

Qualifications

• Strong knowledge of SQL, Joins, Subqueries, CTEs and Window Functions.
• Excel expertise with Pivot Tables, VLOOKUP and XLOOKUP.
• Hands-on experience with Power BI, DAX and Power Query.
• Knowledge of Python, Pandas and NumPy.
• Understanding of data visualization, statistics and reporting concepts.

Responsibilities

• Collect, clean, process, and analyze data from multiple sources.
• Extract and manipulate data using SQL queries.
• Develop and maintain interactive dashboards and reports.
• Perform data validation to ensure data accuracy and consistency.
• Identify trends, patterns, and insights to support business decisions.
• Prepare daily, weekly, and monthly reports.
• Monitor and track business KPIs and performance metrics.
• Automate repetitive reporting processes.
• Collaborate with business teams to understand reporting requirements.
• Present analytical findings and insights to stakeholders.

Skills

SQL proficiency

Excel proficiency

Analytical thinking

Data visualization concepts

Communication skills

Attention to detail

Presentation skills

Statistical understanding

Tools

Power BI

Python (Pandas NumPy)

SQL Server

MySQL

PostgreSQL

Power Query

DAX

Job description

• Collect, clean, process, and analyze data from multiple sources.
• Extract and manipulate data using SQL queries.
• Develop and maintain interactive dashboards and reports.
• Perform data validation to ensure data accuracy and consistency.
• Identify trends, patterns, and insights to support business decisions.
• Prepare daily, weekly, and monthly reports.
• Monitor and track business KPIs and performance metrics.
• Automate repetitive reporting processes.
• Collaborate with business teams to understand reporting requirements.
• Present analytical findings and insights to stakeholders.

Required Skills

• Strong knowledge of SQL, Joins, Subqueries, CTEs, and Window Functions.
• Proficiency in Microsoft Excel, Pivot Tables, VLOOKUP, and XLOOKUP.
• Hands-on knowledge of Power BI, DAX, Power Query, and dashboard development.
• Basic knowledge of Python, Pandas, and NumPy.
• Understanding of data visualization and reporting techniques.
• Knowledge of MySQL, SQL Server, or PostgreSQL.
• Understanding of basic statistics and data analysis concepts.
• Strong analytical, logical thinking, and problem-solving skills.
• Good communication and presentation skills.
• Attention to detail and ability to meet deadlines.