Junior Data Analyst
• Assisted in the development and maintenance of databases using MS Access and SQL, ensuring accurate data storage and retrieval.• Utilized advanced Excel formulas and functions to perform detailed data analysis, including PivotTables, XLOOKUP, INDEX-MATCH, and nested IF statements.• Supported the creation of Tableau dashboards by preparing data sets and ensuring data quality and consistency.• Designed and executed SQL queries to extract, manipulate, and analyze data, supporting ad-hoc reporting requests from various departments.• Performed root cause analysis on data discrepancies, implementing corrective actions to enhance data reliability.• Developed and maintained documentation for data processes, ensuring clear and consistent guidelines for team members.
