Roles and Responsibilities
- Collect, clean, validate, and analyze data from multiple sources.
- Identify data patterns, trends, and insights to support business decisions.
- Write and execute SQL queries to retrieve, manipulate, and analyze data.
- Create dashboards, reports, and visualizations using Power BI or Tableau.
- Perform data cleaning, transformation, and preprocessing.
- Analyze large datasets and identify business opportunities and potential issues.
- Prepare daily, weekly, and monthly performance reports.
- Work with business teams to understand data requirements and reporting needs.
- Develop and maintain KPIs, metrics, and performance dashboards.
- Perform data validation and ensure data accuracy and consistency.
- Identify discrepancies and investigate data-related issues.
- Automate repetitive reporting tasks wherever possible.
- Present analytical findings and recommendations to stakeholders.
- Maintain proper documentation of data processes, reports, and analysis.
Required Technical Skills
- Strong knowledge of SQL, including joins, subqueries, aggregate functions, and stored procedures.
- Good knowledge of Microsoft Excel, including Pivot Tables, VLOOKUP/XLOOKUP, and formulas.
- Experience with data visualization tools such as Power BI or Tableau.
- Understanding of data cleaning, data transformation, and data validation.
- Basic knowledge of Python using Pandas, NumPy, and Matplotlib is preferred.
- Understanding of databases such as MySQL, SQL Server, or PostgreSQL.
- Knowledge of statistical concepts and data analysis techniques.
- Ability to create reports, dashboards, and data visualizations.
- Understanding of ETL processes and data warehousing concepts.
- Knowledge of business metrics and KPI analysis.
Required Soft Skills
- Strong analytical and problem-solving abilities.
- Excellent attention to detail.
- Good verbal and written communication skills.
- Ability to interpret complex data and present insights clearly.
- Strong logical and critical-thinking skills.
- Ability to work independently and collaboratively.
- Good time-management and organizational skills.
- Ability to handle multiple projects and meet deadlines.
Key Performance Indicators (KPIs)
- Accuracy and reliability of data analysis.
- Timely delivery of reports and dashboards.
- Data quality and validation accuracy.
- Efficiency in report generation and automation.
- Accuracy of KPI tracking and reporting.
- Quality of insights and business recommendations.
- Stakeholder satisfaction.
Preferred Skills
- Experience in Power BI dashboard development.
- Knowledge of Python programming for data analysis.
- Familiarity with cloud platforms such as AWS, Azure, or Google Cloud.
- Understanding of Big Data technologies.
- Knowledge of advanced Excel and statistical analysis.
- Experience working with large datasets.
- Understanding of machine learning concepts is an added advantage.