Key Responsibilities:
- Work on larger datasets utilising relevant tools MS Excel, SQL, Python, and Power BI to manage, analyse, and visualize data.
- Oversee data flow, integrating external datasets into JATO environment while ensuring consistency and accuracy.
- Execute ETL (Extract, Transform, Load) processes to optimize data management.
- Perform data cleaning, validation, and matching using JATO definitions and terminology.
- Identify trends using multiple research sources to enhance data accuracy and completeness.
- Conduct data validation, formatting and transformation to maintain high data quality.
- Monitor and report any failures, issues, or anomalies using JATO’s reporting tools.
- Maintain and update documentation related to data processes and workflows.
- Collaborate with the Data development team at HQ to refine data processing strategies.
- Work with teams to improve the efficiency through automation- always strive to find new ways to automate tasks.
- Perform database backups and housekeeping tasks to safeguard data integrity.
- Ensure quality assurance through thorough testing of databases and data feeds. In case of any anomalies report and amend the historical datasets.
- Develop insightful reports and dashboards to support decision-making.
Key Requirements:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proficiency in MS Excel, SQL, Python, and Power BI/Tableau for data analysis and visualization.
- Experience working in a database environment with structured and unstructured data.
- Strong understanding of data management, ETL processes, and reporting techniques.
- Ability to prioritize workloads and meet tight deadlines while maintaining accuracy.
- Exceptional communication skills (both verbal and written) to convey insights effectively.
- Self-motivated, detail-oriented, and results-driven approach to data handling.
- Ability to work both independently and collaboratively in a team environment.
- A flexible, professional attitude with the ability to support change management processes when and if necessary.
- Knowledge of the local car market and a working knowledge of the terms used to describe vehicles would be an asset but not essential.
Application Link: https://careers.jato.com/jobs/6000326-data-analyst