Media Analytics Specialist

Are you looking for a supportive and collaborative workplace with great benefits and clear career development? You’ve come to the right place.

Why choose Manulife?

• Competitive Salary packages and performance bonuses
• Day 1 HMO + FREE coverage for your dependents (inclusive of same-sex partners)
• Retirement savings benefit
• Rewarding culture that values wellness and well-being
• Performance Bonus
• Global network of industry experts
• Extensive training resources

Job Description:

We are seeking a skilled and detail-oriented Media Analyst to join our data and analytics team. The ideal candidate will be responsible for handling ETL tags within DOMO, supporting data visualization, and ensuring data validation processes. You should have a strong understanding of SQL, advanced Excel skills, paid media metrics, and platform APIs, along with expertise in relational databases. This role will help provide actionable insights and improve the efficiency of media campaign tracking and reporting.

Have the skills and knowledge for the job? Learn more about the opening below!

Key Responsibilities:

• ETL Management: Handle Extract, Transform, Load (ETL) processes within DOMO, ensuring accurate data ingestion and transformation from various media platforms.

• Data Visualization: Create, maintain, and enhance dashboards and reports using DOMO and other BI tools, providing actionable insights to stakeholders.
• Data Validation: Conduct thorough data validation to ensure accuracy, consistency, and completeness of datasets, troubleshooting discrepancies when necessary.
• Paid Media Analytics: Track, analyze, and report on key paid media metrics (CPM, CPC, CPA, ROI, etc.) across multiple platforms (Google Ads, Facebook, LinkedIn, etc.).
• Database Management: Manage and optimize relational databases to support media data pipelines, ensuring efficient data storage and retrieval.
• SQL & Excel Expertise: Write complex SQL queries to pull and analyze data; leverage advanced Excel functions (VLOOKUP, Pivot Tables, etc.) to manipulate data and build ad hoc reports.
• Platform APIs: Integrate and utilize various media platform APIs (Google, Facebook, LinkedIn, etc.) for data extraction and reporting automation.
• Collaboration: Work closely with media buying, marketing, and data engineering teams to ensure data accuracy and optimize reporting processes.

Required Qualifications:

• Education: Bachelor's degree in Computer Science, Data Analytics, Communications Research, Marketing, or related field.
• Experience: 2-4 years of experience in data analytics, media reporting, or related roles.
• Technical Skills:
  • Proficiency in DOMO, SQL, and advanced Excel.
  • Experience with media platform APIs and data integration tools.
  • Familiarity with relational databases and ETL processes.
• Analytical Skills: Strong analytical mindset, with the ability to interpret complex data and deliver actionable insights.
• Media Knowledge: Understanding of paid media metrics, trends, and performance indicators.
• Work Set Up and Shift: Hybrid 3x a week onsite and 2x a week work from home - mid shift/nightshift work schedule

Preferred Qualifications:

• Experience in programmatic media buying and campaign optimization.

• Statistical

• Knowledge of Python or other scripting languages.

• Experience in data visualization tools like Tableau or Power BI.

• Azure & MS Copilot

Let's make every day better together. Learn about our opportunities at JOBS.MANULIFE.COM

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit https://www.manulife.com/en/about/our-story.html.

Manulife is an Equal Opportunity Employer

At Manulife/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process, contact recruitment@manulife.com.