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.
