Search by job, company or skills

Sun Life of Canada (Philippines), Inc. Josephine Collado

Data Analyst, Agency Reporting

Early Applicant
  • Posted 14 days ago
  • Be among the first 10 applicants
2-4 Years

Banking/Accounting/Financial Services

Job Description

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

1.Report Automation

  • Write efficient and complex SQL queries to extract, transform, and aggregate data from various databases and data warehouses to power automated reporting.
  • Collaborate with engineering and data teams to ensure data pipelines are reliable and accessible for dashboarding needs.

2. Dashboard Development & Data Visualization:

  • Design, develop, and maintain automated, dashboards to provide self-service insights and streamline reporting processes.
  • Transform complex data sets into clear, compelling, and visually appealing narratives tailored to different stakeholder needs.
  • Apply best practices in data visualization to ensure dashboards are intuitive, user-friendly, and drive action.

3. Manual Reporting & Delivery:

  • Execute and deliver high-quality, accurate manual reports for clients on a weekly, monthly, and quarterly basis before automation is complete.
  • Meticulously QA all data points in reports and dashboards to ensure 100% accuracy before client delivery.

4. Ad Hoc Analysis & Support:

  • Respond promptly to ad-hoc data requests from account management teams and clients, providing clear and concise answers to specific business questions, often through quick-turnaround visualizations.
  • Communicate with IT and Platform Owners for any client (internal and external) inquires received and act as a point of contact for any follow up questions.

5. Insight Generation & Data Storytelling:

  • Go beyond just reporting numbers perform analysis on key client campaigns and business areas to identify trends, opportunities, and actionable insights.
  • Synthesize complex data findings into clear, compelling narratives and visualizations for both technical and non-technical audiences.

6. User Acceptance Testing (UAT) & Quality Assurance:

  • Play a key role in the UAT process for new dashboards and data pipeline developments.
  • Develop test cases, document bugs, and work closely with developers to ensure all solutions are visually accurate, performant, and meet business requirements before launch.

Required Qualifications & Skills

  • 2-4 years of professional experience in a data analytics or business intelligence role, preferably within a marketing agency, ad tech, or a related digital field.

Technical Proficiency

  • Data Visualization & Dashboards: Expert-level proficiency in building interactive and automated dashboards. Required experience with Google Looker Studio (highly preferred), Tableau, QlikSense, Power BI, or similar.
  • Cloud Platforms: Proficiency with M365 (SharePoint), AWS (S3, RDS, Glue, SageMaker, Athena, etc.), GCP and Tableau services
  • Programming: Advanced proficiency in writing python or complex SQL queries for data extraction and manipulation. Hands-on experience with Python/R is a plus.
  • Digital Marketing Data: Strong understanding of data from platforms like Google Analytics (GA4), Google Ads, Meta Ads Manager, CM360, etc.
  • Spreadsheets: High proficiency in Google Sheets or Microsoft Excel (pivot tables, VLOOKUPs, array formulas).
  • Analytical Mindset: Proven ability to analyze large datasets, identify trends, and translate quantitative findings into strategic recommendations.
  • Attention to Detail: An unwavering commitment to data accuracy and visual consistency.
  • Communication Skills: Excellent verbal and written communication skills, with the ability to explain technical concepts and visual choices to non-technical stakeholders. Strong collaborative and team player.

Job Category:

Channel Management

Posting End Date:

29/12/2025

Date Posted: 19/09/2025

Job ID: 126339439

Report Job

About Company

Sun Life Financial Inc. is a Canadian financial services company. It is primarily known as a life insurance company. Sun Life has a presence in investment management with over CAD$1.3 trillion in assets under management operating in a number of countries.

View More
Last Updated: 03-10-2025 00:39:32 AM
Home Jobs in Hong Kong Data Analyst, Agency Reporting