Junior Marketing Data Analyst

Role: Junior Marketing Data Analyst

Client: FNB (First National Bank)

Employment: W2

Location: Pittsburgh, PA (Onsite)

Duration: 24 Months (Conversion Possible)

Start Date: June 15, 2026

End Date: June 30, 2028

Work Authorization: Open to US Citizens (USC), Green Card (GC), GC-EAD, CPT-40, and OPT/STEM OPT candidates

Pay Range: $40.00/hr - $47.50/hr on W2

Position Overview

FNB is seeking a Junior Marketing Data Analyst to support data-driven marketing initiatives focused on customer acquisition, growth, and retention. This role will work closely with marketing teams, business stakeholders, and CRM systems to ensure effective utilization of customer and prospect data. The selected candidate will assist in campaign execution, data preparation, lead generation support, and reporting, contributing to scalable and efficient marketing operations within a regulated banking environment.

Key Responsibilities

• Support the management and maintenance of customer and prospect data used in marketing and sales campaigns
• Prepare and validate datasets for targeted marketing campaigns, outreach programs, and CRM-based lead distribution
• Assist in generating qualified lead lists for frontline business teams using internal data sources
• Perform data cleaning, validation, and standardization to ensure accuracy and consistency across marketing databases
• Import and reconcile data from multiple internal and external sources to support campaign execution
• Assist in identifying data quality issues and contribute to improvement initiatives
• Support analysis of campaign performance metrics and customer engagement trends
• Generate basic reports and dashboards to track campaign effectiveness and business KPIs
• Assist in delivering insights to marketing stakeholders for optimizing campaign strategies
• Work with internal teams and vendors to support data integration and campaign execution processes
• Maintain documentation for data processes, datasets, and reporting outputs
• Follow FNB's data governance, risk management, and regulatory compliance standards

Required Skills

• 1+ year of experience in data analysis, marketing analytics, or similar role
• Strong working knowledge of Excel, SQL, and data handling techniques
• Basic understanding of CRM systems and marketing databases
• Familiarity with data cleaning, transformation, and reporting processes
• Strong analytical, organizational, and communication skills
• Ability to work in a structured, compliance-driven environment

Preferred Skills

• Exposure to financial services/banking domain
• Experience with reporting tools (Power BI, Tableau, or similar)
• Basic understanding of campaign analytics and customer segmentation
• Familiarity with data governance or regulatory data handling practices

Educational Background

• Bachelor's degree in Data Analytics, Business Analytics, Statistics, Computer Science, Information Systems, or a related field
• Candidates with relevant internships or project experience in marketing/data analytics will also be considered
• Coursework in:
• Data Analysis / Statistics
• Database Management (SQL)
• Marketing Analytics / Business Intelligence

Interview Process

1. Client Screening
2. Technical Screening (Data handling, SQL, basic analytics)
3. Client Interview (Marketing + Data use case discussion)
4. HR Round