Roles and Responsibilities
- Collect, extract, organize, and analyze data from various sources to support business requirements.
- Clean, validate, and transform raw data to maintain accuracy, consistency, and reliability.
- Perform data analysis to identify trends, patterns, relationships, and business opportunities.
- Write and execute SQL queries to retrieve, filter, join, and manipulate data from databases.
- Use Microsoft Excel to perform data analysis, create pivot tables, apply formulas, and generate reports.
- Develop interactive dashboards, reports, and visualizations using Power BI or Tableau.
- Create and maintain key performance indicator (KPI) reports to monitor business performance.
- Perform exploratory data analysis (EDA) to understand datasets and identify important insights.
- Use Python libraries such as Pandas, NumPy, and Matplotlib for data processing and analysis.
- Work closely with cross-functional teams to understand business requirements and provide data-driven solutions.
- Prepare daily, weekly, and monthly reports for management and other stakeholders.
- Identify data discrepancies, investigate errors, and implement appropriate data quality checks.
- Maintain proper documentation of data sources, analytical processes, and reporting methodologies.
- Present analytical findings and recommendations in a clear and understandable manner.
- Support continuous improvement of reporting processes and data analysis workflows.
Technical Skills Required
- Microsoft Excel: Advanced Excel, VLOOKUP, XLOOKUP, Pivot Tables, IF, SUMIF, COUNTIF, and data validation.
- SQL: SELECT, WHERE, GROUP BY, ORDER BY, JOINS, Subqueries, CTEs, and aggregate functions.
- Power BI: Data modeling, Power Query, DAX, dashboard development, and report generation.
- Python: Basic to intermediate knowledge of Pandas, NumPy, and Matplotlib.
- Statistics: Descriptive statistics, mean, median, mode, correlation, and basic probability.
- Data Visualization: Ability to present complex datasets through meaningful charts, graphs, and dashboards.
- Database Knowledge: Understanding of relational databases, tables, and data structures.
Required Skills and Competencies
- Strong analytical and problem-solving abilities.
- Good logical and numerical reasoning skills.
- Excellent attention to detail and accuracy.
- Ability to interpret and analyze large datasets.
- Good communication and presentation skills.
- Ability to work independently and collaboratively within a team.
- Strong organizational and time-management skills.
- Willingness to learn new technologies and analytical tools.
Key Performance Expectations
- Deliver accurate and timely analytical reports.
- Maintain high standards of data quality and consistency.
- Develop meaningful dashboards and business reports.
- Identify actionable insights from available datasets.
- Complete assigned analytical tasks within project deadlines.
- Support business teams with reliable data and reporting solutions.
Preferred Qualifications
- Certification in Power BI, SQL, Python, or Data Analytics.
- Knowledge of Tableau or other business intelligence tools.
- Understanding of ETL processes and data warehousing concepts.
- Experience working on real-time or academic data analytics projects.
