Senior Data Coordinator Marketing

Position Overview

Penn Medicine is dedicated to its tripartite mission of delivering the highest level of patient care, conducting innovative research, and educating future leaders in medicine. As part of this leading academic medical center, you will collaborate with top clinical, technical, and business professionals. The Senior Data Coordinator Marketing is responsible for supporting and managing Marketing data sources – ensuring data quality, preparing outputs for Marketing’s DataMart and CRM systems, and providing insightful analysis to inform marketing strategies.

Key Responsibilities

• Supports Marketing data infrastructure, including the Marketing DataMart and the Marketing CRM platform.
• Prepares data outputs and queries from the Marketing DataMart and CRM system.
• Performs ongoing data preparation for the marketing and physician databases by gathering, analyzing, repairing, and integrating data from numerous sources.
• Conducts regular audits to ensure data consistency and accuracy.
• Creates and maintains clear documentation for data management elements – including data sources, fields, data models, table structures, and queries.
• Assists the marketing team with data interpretation and increases awareness of available data.
• Sets up Access databases or Excel worksheets as needed, including creating macros using VBA to automate routine tasks.
• Supports the monthly ETL (Extract, Transform, Load) process when applicable.
• Performs duties in accordance with Penn Medicine’s values, policies, and procedures.
• Completes other duties as assigned to support the department and health system organization.

Required Qualifications

• Bachelor of Arts or Science
• 3+ years of professional experience working with large volumes of data
• Demonstrated proficiency in managing complex data sets
• Advanced Excel skills and advanced knowledge of SQL or similar querying languages
• Strong communication and project management skills with excellent attention to detail

Preferred Qualifications

• 1+ years of professional experience working with marketing-specific datasets
• Master of Arts or Science
• Proficiency in Salesforce or other CRM systems
• Familiarity with marketing analytics, performance metrics, and ETL processes

Benefits & Perks

• Comprehensive Compensation and Benefits Program: Includes one of the finest prepaid tuition assistance programs in the region.
• Employee health and wellness initiatives
• Opportunities to work alongside top professionals in clinical, technical, and business fields