Marketing Database Analyst

This role supports marketing analytics by maintaining data marts, ensuring data quality, and delivering insightful Power BI reporting and dashboards. The successful candidate will partner with stakeholders across the organization to improve data governance, campaign performance measurement, automation, and the adoption of advanced analytical solutions.

Client Details

The company operates in the insurance industry.

Description

• Maintain the Marketing Analytics Datamart including data daily refresh and monthly rollups. Ensure data accuracy and data integrity.
• Identify data/process issues, notify the impacts to both internal team members and external clients in a timely manner and assist problem solving.
• Develop and maintain robust and user-friendly Power BI reports/dashboards for marketing data performance tracking.
• Participate in User Acceptance Test and data QA. On behalf of Marketing, act as the Subject Matter Expert in data, system and platform new launch and/or upgrade.
• Ensure all campaign data transfers follow the standards. Identify opportunities of streamlining and automating data transfers to improve efficiency.
• Assist the Supervisor of Marketing Data & Analytics in data exploration, preparation, interpretation and integration of both internal and external data to meet ever-growing business needs.
• Facilitate marketing LOBs in the adoption and implementation of customer segmentation, marketing predictive models and analytical tools built by the team. Being an advocator and facilitator of the member-centric strategy.
• Assist the Supervisor to partner with various analytics teams across the organization and stay abreast of latest data trends.

MPI does not discriminate on the basis of race, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, or based on an individual's status in any group or class otherwise protected under applicable human rights legislation. MPI encourages applications from minorities, women, the disabled and all other qualified applicants

Profile

• Bachelor's degree in Mathematics, Statistics, Analytics, Engineering or Commerce.
• Highly detail-oriented, with strong data literacy and an eye for identifying data issues.
• Highly collaborative with excellent communication and story-telling skills - a true bridge between data and business.
• 3+ years of analytics experience in marketing data governance, database marketing, campaign management, hypothesis testing and experimental design.
• 3+ years of SQL/SAS programming with enterprise-level database.
• 3+ years of BI reporting and visualization tools such as Microsoft Power BI or Tableau.
• Hands-on experience of SSMS (SQL Server Management Studio) and T-SQL.

Job Offer

• Permanent Marketing Database Analyst position.
• Opportunity to own and enhance critical marketing analytics data assets that support business decision-making.
• Exposure to enterprise-wide analytics initiatives, data governance, and marketing performance measurement.
  

MPI does not discriminate on the basis of race, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, or based on an individual's status in any group or class otherwise protected under applicable human rights legislation. MPI encourages applications from minorities, women, the disabled and all other qualified applicants