Responsible for collecting, validating, preparing, and analyzing data from multiple sources to support dashboard reporting and basic insight generation that informs clients' marketing planning and business decisions. Works closely with Project Management, Data Engineer, Media, and Account Management teams to translate business objectives into data requirements, ensure data quality, and communicate findings clearly and accurately.
Responsibilities
Understand client objectives and data requirements by joining internal briefs and gathering relevant data requirements (sources, metrics, timeframe, target audience, dimensions).
Collect and prepare data from relevant platforms such as Google Analytics 4, Google Ads, Meta Ads, CRM systems, and tracking tools, ensuring data accuracy and completeness.
Organize, consolidate, and transform raw data into standardized formats using tools such as Excel, SQL, Power BI, Looker Studio, Google Cloud Platform (GCP), or Python.
Build reports and dashboards using tools such as Power BI, Looker Studio, and Dfinery, designing clear and accurate data presentations.
Perform basic data analysis to identify trends and insights that support marketing campaigns and business decision-making.
Ensure data, report, and dashboard quality at every stage; collaborate with related teams; and learn new Data Analytics, BI, and AI tools to support the work.
Perform other duties as assigned.
Qualifications
0–2 years of experience in Data Analytics, Digital Analytics, Business Intelligence, Marketing Analytics, or Dashboard Reporting.
Proficient in Power BI, Google Analytics 4, Excel, SQL, or related tools.
Basic understanding of Data Analytics, Web Analytics, Tracking, Dashboards, and Data Visualization.
Strong analytical thinking, attention to detail, prioritization skills, and ability to work within set timelines.
Basic understanding of data security, access rights, and relevant PDPA requirements.
Proficient in Google Workspace and MS Office; basic English proficiency for reading data, tools, and reports.