Responsibilities
- Gather, verify, and prepare data from various systems to maintain high-quality information standards.
- Apply advanced Excel techniques including VLOOKUP, INDEX-MATCH, PivotTables, and logical formulas for in-depth analysis.
- Build and update dashboards, reports, and analytical models to monitor organizational performance.
- Detect trends, irregularities, and patterns within large datasets to assist strategic initiatives.
- Work with teams across departments to identify data requirements and deliver customized reporting tools.
- Record procedures and suggest improvements to enhance data handling and reporting workflows.
- Maintain data accuracy and adherence to internal policies and governance guidelines.
Responsibilities
- Collect, clean, and validate data from multiple sources to ensure accuracy and consistency.
- Perform advanced data analysis using Excel functions such as VLOOKUP, INDEX-MATCH, PivotTables, and conditional formulas.
- Develop and maintain dashboards, reports, and data models to track business performance.
- Identify trends, patterns, and anomalies in datasets to support strategic planning.
- Collaborate with cross-functional teams to understand data needs and deliver tailored solutions.
- Document processes and provide recommendations for improving data management and reporting efficiency.
- Ensure data integrity and compliance with company standards.
