Data Analyst, Merchandising
Fullscript
PythonSQL
Job Level
Senior
Tech Stack
PythonSQL
About the role
- Design and execute custom SQL queries to resolve complex data inquiries and integrate AI into daily business operations.
- Develop reports and management information (MI) dashboards that adhere to project briefs and client KPIs, utilising PowerPoint, ZOHO Analytics, and Microsoft Power BI.
- Collaborate with the account team to ensure data integrity and maintain accurate MI data.
- Apply best practices to guarantee complete data capture for effective KPI measurement.
- Analyse and present data to fulfil stakeholder requirements, ensuring insights are clear and actionable.
- Understand and collaborate with clients to deliver tailored solutions that meet their specific needs.
- Attain proficiency in proprietary tools, including OMG and the AI Sandbox.
- Grasp diverse client business models to improve the relevance and quality of provided reports.
- Manage and maintain the client-facing dashboard on a daily basis.
- Conduct data impact analysis to assess changes and their implications.
- Set up and deliver weekly and monthly reports and MI packs.
- Oversee data hygiene management to ensure data cleanliness and track any issues.
- Support teams by preparing PowerPoint presentations for monthly MI reports, Quarterly Business Reviews, and handling ad hoc reporting requests.
- Propose innovative methods for presenting key metrics to stakeholders to ensure clear and impactful communication of data-driven insights.
Requirements
- Strong problem-solving skills and experience in client-facing roles.
- Exceptional attention to detail and accuracy.
- Ability to work efficiently in a fast-paced environment with excellent time management and prioritization skills.
- Competence in understanding requests and delivering insightful reports.
- Experience in handling large and complex datasets.
- Advanced skills in Excel, including pivot tables, complex formulas (such as VLOOKUPs and nested IF statements), and proficiency with Power Query and Python for Excel.
- Proficiency in data visualization tools like ZOHO and Power BI.
- Competency in SQL and Python programming languages.
- Proficiency in utilizing AI technologies and various large language models (LLMs) to enhance role efficiency.
- Experience in agency and marketing environments is an advantage.
- Confidence in engaging effectively with senior internal and external stakeholders.
- Excellent verbal and written English skills.
- Experience or ability to utilize machine learning models to optimize SQL query development and dataset management.
- Ability to interrogate and validate data and ensure data integrity.
- Ability to prepare PowerPoint presentations for monthly MI reports, Quarterly Business Reviews and ad hoc reporting requests.
