Data Analyst

Roles and Responsibilities

• Collect, extract, and analyze data from multiple sources.
• Clean, validate, and transform raw datasets.
• Identify trends, patterns, and business insights from data.
• Write SQL queries to retrieve and manipulate data.
• Create interactive dashboards and reports using Power BI or Tableau.
• Perform data analysis using Microsoft Excel and Python.
• Prepare daily, weekly, and monthly reports.
• Monitor key performance indicators (KPIs) and business metrics.
• Identify data inconsistencies and ensure data accuracy.
• Collaborate with different teams to understand business requirements.
• Present analytical findings and recommendations to stakeholders.
• Support management in making data-driven decisions.

Technical Skills Required

• Microsoft Excel: VLOOKUP, XLOOKUP, Pivot Tables, Conditional Formatting, and Charts.
• SQL: SELECT, WHERE, GROUP BY, ORDER BY, JOINs, Subqueries, CTEs, and Aggregate Functions.
• Python: Pandas, NumPy, Matplotlib, and Seaborn.
• Power BI: Dashboard Creation, DAX, Power Query, and Data Modeling.
• Tableau: Data Visualization and Dashboard Development.
• Statistics: Mean, Median, Mode, Standard Deviation, and Probability.
• Data Cleaning: Handling missing values, duplicate records, and inconsistent data.
• Data Visualization: Creating charts, graphs, and reports.

Soft Skills

• Strong analytical and problem-solving skills.
• Good verbal and written communication skills.
• Attention to detail and accuracy.
• Ability to interpret complex data.
• Time management and organizational skills.
• Ability to work independently and in a team.
• Willingness to learn new tools and technologies.

Key Performance Indicators (KPIs)

• Accuracy and quality of data analysis.
• Timely delivery of reports and dashboards.
• Efficiency in data cleaning and processing.
• Accuracy of business insights and recommendations.
• Dashboard performance and reporting efficiency.
• Ability to meet business reporting requirements.

Preferred Skills

• Knowledge of ETL processes.
• Understanding of data warehousing concepts.
• Basic knowledge of cloud platforms such as AWS, Azure, or Google Cloud.
• Familiarity with business intelligence tools.
• Experience working with large datasets.

Expected Deliverables

• Cleaned and structured datasets.
• SQL queries and data extraction reports.
• Interactive Power BI/Tableau dashboards.
• Weekly and monthly analytical reports.
• Business performance analysis.
• Data-driven insights and recommendations.