Research Analyst

Roles/Responsibilities:

• Support MHBEs Information Technology division on the migration of the home-grown Marketing Portal to the Salesforce Marketing Cloud (SFMC).
• Reporting to the PMO Director and working in close coordination with the Salesforce Development Director and migration delivery team analyze existing and potential marketing technology capabilities prospective consumer audiences and legacy portal performance data.
• Collate findings into meaningful reports and presentation materials for IT leadership marketing stakeholders and MHBE program staff.
• Conduct current-state discovery of the legacy Marketing Portal inventorying campaigns audience segments email templates automation workflows reporting artifacts and integration touchpoints and maintain organized documentation in a systems library accessible to the PMO SFMC development team and MHBE stakeholders.
• Support data-mapping activities between the legacy portal and Salesforce Marketing Cloud objects (Data Extensions Subscriber lists Journey Builder flows Email Studio templates) working alongside technical resources who perform the actual configuration and development.
• Analyze legacy campaign performance data and assist in defining the reporting baseline that SFMC will need to match or exceed post-migration including open rates click-through rates conversion rates ROAS CPC and audience segmentation metrics.
• Assist the PMO in tracking migration milestones dependencies action items and risk registers; prepare status reports meeting minutes and briefings for IT leadership and MHBE program stakeholders.
• Support and document User Acceptance Testing (UAT) activities including test script preparation issue logging triage coordination with the development team and tracking resolution through closure as needed.
• Support change management and end-user readiness activities including research for training materials documentation drafts and stakeholder communication support for marketing teams transitioning from the legacy portal to SFMC.
• Interface with MHBE marketing and outreach end-users to capture workflow nuances pain points and requirements that are not immediately apparent from the legacy code or database alone.
• Maintain a general working knowledge of governmental documents and procedures including privacy PII handling and HIPAA considerations applicable to consumer outreach data in scope for migration.
• Adhere to all security change control and MHBE Project Management Office (PMO) policies processes and methodologies.

Mandatory Skills:

1. A minimum of two (2) years of work experience in a business environment. Qualified relevant internship experience in a directly applicable field (such as digital marketing marketing analytics marketing technology business analysis or IT project support) will be counted toward the required years of experience provided the internship involves substantive professional work rather than observational or training-only activities.
2. Working familiarity with Salesforce Marketing Cloud (SFMC) or a comparable enterprise marketing technology platform (such as Mailchimp HubSpot Constant Contact Marketo or Eloqua) from a marketing/analytics user perspective sufficient to understand campaign configuration audience segmentation and reporting outputs.
3. Demonstrated SFMC-specific exposure through at least one of the following: (a) active Trailhead learning progress on Marketing Cloud modules (b) in-progress preparation for Marketing Cloud Email Specialist or Marketing Cloud Administrator certification (c) completed SFMC-focused coursework or training or (d) hands-on SFMC platform exposure.
4. Demonstrated hands-on experience with digital marketing platforms including Google Ads Meta Ads Manager (Facebook/Instagram) and email marketing platforms such as Mailchimp or Constant Contact.
5. Demonstrated hands-on experience with web analytics and search tools including Google Analytics (GA4) and Google Search Console including event/conversion tracking audience analysis and dashboard configuration.
6. Demonstrated ability to analyze and interpret campaign performance data including standard digital marketing KPIs such as open rate click-through rate (CTR) conversion rate (CVR) cost-per-click (CPC) return on ad spend (ROAS) and ROI.
7. Demonstrated experience designing executing and interpreting A/B tests for landing pages email campaigns or digital ads.
8. Working knowledge of the systems development lifecycle (SDLC) and Agile software development methodologies sufficient to operate effectively within a structured IT project environment.
9. Demonstrated written and verbal communication skills with the ability to produce clear reports documentation and presentations for both technical and non-technical audiences.
10. Demonstrated ability to work collaboratively with IT staff project managers and marketing/business stakeholders.
11. Strong organizational skills and attention to detail with the ability to manage multiple priorities and documentation artifacts concurrently.

Desirable Skills:

1. A minimum of two (2) years of hands-on experience using Salesforce Marketing Cloud (SFMC) or an equivalent tool in a marketing analytics or campaign-operations capacity including familiarity with Journey Builder Email Studio Automation Studio Contact Builder Data Extensions and Subscriber lists.
2. Prior experience supporting a platform migration replatforming or legacy-system retirement project in a marketing technology CRM or customer-data context.
3. Hands-on experience with SEO analysis using SEMrush including on-page and off-page optimization keyword research backlink building site speed analysis and SERP performance tracking.
4. Experience with social media management platforms such as Hootsuite including managing content across multiple brands and channels (e.g. Instagram Facebook LinkedIn Bluesky).
5. Experience with CRM platforms such as HubSpot CRM and familiarity with Salesforce Sales/Service Cloud including lead management audience segmentation and understanding data flows between CRM marketing automation and analytics platforms.
6. Hands-on experience designing and managing paid media campaigns across Google Ads Meta Ads Manager and LinkedIn including budget allocation audience targeting creative testing and retargeting strategies.
7. Proficiency with data visualization and dashboarding tools including Tableau (including LOD expressions parameters and tooltips) or Power BI for building KPI dashboards.
8. Strong Microsoft Excel skills including pivot tables lookups and basic data modeling.
9. Hands-on experience with SQL/MySQL for data extraction and analysis.
10. Exposure to Python R (R Studio) or SPSS for data analysis and statistical reporting.
11. Experience with conversion rate optimization (CRO) methodologies including landing page optimization conversion funnel analysis and identifying and resolving drop-off points.
12. Experience with e-commerce and CMS platforms such as Shopify including UX optimization landing page configuration and bounce rate reduction.
13. Proficiency with content creation and design tools including Canva Figma and the Adobe Creative Suite (Photoshop Illustrator After Effects) as well as video editing tools such as CapCut for supporting outreach asset inventories and migration-related collateral.
14. Experience creating pitch decks presentations and visual storytelling materials for stakeholder communication.
15. Familiarity with email marketing automation workflows A/B testing audience segmentation and nurture sequence design across Mailchimp HubSpot and Constant Contact.
16. Comfort with collaboration and project management tooling including Microsoft Project Jira Confluence SharePoint and Microsoft Teams.
17. Familiarity with A/B testing landing page optimization and conversion rate optimization (CRO) methodologies.
18. Familiarity with HIPAA PII handling CAN-SPAM / CASL email compliance and accessibility standards (Section 508 WCAG) in a digital outreach context.
19. Google credentials such as the Digital Marketing & E-commerce Certificate and Google Analytics Certification.
20. IBM Data Science Practitioner or equivalent data science / analytics credential.