Data Analyst, Marketing Analytics

Deerfield Group; Conshohocken (Montgomery County); On-site; USD 65,000 - 90,000; Full time

Job summary

Deerfield Group is a full‑service marketing agency seeking a Data Analyst to own reporting and analysis powering client marketing and media measurement.

You will manage recurring and ad-hoc analyses, build SQL- and Python-driven queries, and turn data from multiple sources into actionable insights to optimize campaigns.

Qualifications

• 2–3 years of experience with SQL and Python in analytics or reporting roles.
• 2–3 years of experience using marketing or media data in analysis work.
• Strong attention to detail with large datasets.
• Excellent communication and collaboration skills; ability to translate findings for non-technical stakeholders.
• Strong project management and prioritization skills in a fast-paced agency environment.
• Experience or interest in pharma or healthcare marketing is a plus.

Responsibilities

• Lead recurring and ad-hoc analysis using KPIs to surface insights from website, campaign, and media data.
• Design measurement plans, testing frameworks, and learning agendas for client campaigns.
• Write and maintain SQL queries and Python scripts to pull, clean, and integrate data from multiple sources.
• Build a working understanding of digital media platforms and how data flows into dashboards and client deliverables.
• Collaborate with Media, Creative, Account Services and Strategy teams to align data collection with client KPIs.
• Become go-to data resource on each client’s data sources and reporting nuances.
• Check data and reports for accuracy; flag discrepancies before delivering to clients.
• Follow data privacy and security best practices.

Skills

Analytical thinking

Communication

Collaboration

Project management

Education

Bachelor's degree in data science, analytics, or related field

Tools

Python

SQL

Tableau / Looker Studio

PowerBI

Job description

Are you ready to embark on an exciting journey where your talents are valued, and your potential is limitless? At Deerfield, we believe in fostering a culture of excellence, where every team member is empowered to make a difference and contribute to our collective success.

Deerfield Group is a full-service, integrated marketing, advertising, and communications agency focused on crafting stories that matter and bridging meaningful connections to improve human health. With services spanning omnichannel marketing, insights, creative, digital, media, print, public relations, and analytics, Deerfield is a true Agency of Brand, purpose-built to scale with healthcare companies and brands, whether providing expert consultation, strategic execution, or serving as agency of record. Deerfield Group services are rooted in the science of storytelling and powered by technology to ensure a focused strategy, optimized execution, and tangible outcomes.

The company's team of industry leaders and specialists have deep experience working at every stage of a brand's life cycle to partner with executives and marketers to effectively market and deliver products to the patients who need them.

We are built to serve and designed to deliver.

Position Summary

As a Data Analyst, you’ll take ownership of the reporting and analysis that power our marketing and media measurement across client accounts. You’ll manage recurring and ad-hoc analyses end-to-end, build and maintain the SQL- and Python-driven queries and scripts behind our dashboards, and turn data from multiple sources into the insights and recommendations that shape how we optimize campaigns. You’ll partner closely with our Data Analytics, Media, and Account Services teams, become the go-to expert on each client’s data sources, and grow into more strategic, client-facing measurement work as you build your expertise in brand and media performance analytics.

Key Responsibilities

• Analysis & Reporting: Lead recurring and ad-hoc analysis and optimization requests, using a defined set of KPIs to surface insights from website, campaign, and media performance data, including user behavior, traffic, and conversion trends, across brands.
• Measurement & Testing: Support the design of measurement plans, testing frameworks, and learning agendas for client campaigns, and develop trend reports that align with business objectives and media strategies.
• Data Management & Automation: Write and maintain SQL queries and Python scripts to pull, clean, and integrate data from multiple internal and external sources (media, CRM, website, and other platforms) for reporting.
• Media Data Literacy: Build a working understanding of digital media and advertising platforms across Search, Display, Social, CTV and OLV, and how that data flows into our dashboards and client deliverables.
• Cross-functional Collaboration: Work closely with other areas of the agency, including Media, Creative, Account Services and Strategy, and coordinate with the Data Analytics team to keep data collection aligned with client KPIs and objectives.
• Client Data Expertise: Become a go-to resource on each client’s data sources and reporting nuances, fielding ad-hoc data requests as they arise.
• Quality & Accuracy: Check data and reports for accuracy, catching and flagging discrepancies before they reach clients.
• Best Practices: Follow data handling and storage best practices to maintain data privacy and security standards.

Tools & Technologies

• Languages & Data Handling: Python and SQL
• Reporting & Visualization: Experience with BI visualization tools such as Tableau, PowerBI, Google Data Studio (aka Looker Studio)
• Media & Advertising Data: Exposure to media/advertising platforms such as Google Ads, Meta, or programmatic/DSP data is preferred
• Cloud & Data Infrastructure: Exposure to Azure-based data tools (e.g., Azure Synapse, Azure Data Factory, Azure SQL Database, Databricks) and CRM or media hub data is a plus
• Spreadsheets & Ad-Hoc Analysis: Advanced Excel/Google Sheets skills for quick-turnaround analysis

Qualifications

• Bachelor’s degree in data science, business analytics, statistics, economics, engineering, or a related field (or equivalent practical experience).
• 2–3 years of experience working with SQL and Python in an analytics or reporting role
• 2-3 years of experience using marketing or media data in analysis work
• Solid working knowledge of SQL and Python for data analysis and reporting, with strong attention to detail when working with large datasets
• Excellent communication and collaboration skills; ability to translate technical findings into clear, client-friendly presentations and reports for non-technical stakeholders
• Strong project management and prioritization skills, with the ability to manage multiple deadlines in a fast-paced agency environment
• Experience or interest in pharma or healthcare marketing is a plus

At Deerfield, we are dedicated to building a diverse, inclusive, and authentic work environment, so if this role and our culture excite you, we encourage you to apply even if you do not have the exact experience or meet all requirements outlined in this job posting. Our HR team will review your resume and experience to see if you align at a different level or possibly better align to other open positions.

Deerfield is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.