Entry-Level Data Analyst

About the Role

Matrix Medical Communications publishes medical content for doctors in dermatology, oncology, and neurology, with sponsorship opportunities for clients. The data team measures program performance (email, video, web, print), maintains audience data, and generates reports and dashboards. This entry-level analyst will work alongside the data lead, with the role evolving based on team needs and individual strengths.

Key Responsibilities

• Campaign Reporting:
• Generate weekly and monthly performance reports for pharmaceutical clients and their media agencies.
• Perform recurring data submissions to agency partners, adhering to their specific formats and schedules.
• Track campaign results against client guarantees and flag programs requiring pacing adjustments.
• Dashboards and Client Deliverables:
• Manage dashboards within the in-house analytics application used by sales, editorial, and leadership.
• Create client-facing summaries and slide decks detailing campaign and program results.
• Data Pipelines and Infrastructure:
• Manage automated cloud jobs that ingest data from email platforms, YouTube, web analytics, and other sources into a PostgreSQL database.
• Monitor these jobs, investigate alerts, and correct any issues.
• Build and maintain the internal analytics web application.
• Audience and List Management:
• Maintain physician subscriber data (new sign-ups, address updates, unsubscribes, email list synchronization).
• Build audience pulls and segments for campaigns, and prepare files for print mailings.
• Match client target lists (by NPI and email) to the audience and report on reach.
• Data Quality:
• Conduct routine daily reviews of all data sets, proactively identifying and resolving inconsistencies to ensure data accuracy and reliability.
• Establish and enforce standardized metric definitions for consistency and comparability across reports.
• Requests and Analysis:
• Respond to questions from sales, editorial, and leadership regarding audience counts, campaign results, and performance drivers.
• Contribute to longer-term projects, such as physician targeting, new data sources, and editorial insight tools.

Requirements & Tech Stack

• Must Have:
• Comfort with SQL, including writing queries with joins, grouping, and aggregation.
• Some Python knowledge, or a clear willingness to learn it quickly, particularly pandas.
• Strong attention to detail for data validation and inconsistency detection.
• Ability to explain data and its origin clearly to non-technical audiences.
• Curiosity, self-teaching ability for new tools, and good questioning skills.
• Comfort with AI tools and the judgment to verify their output.
• Experience with PostgreSQL or another relational database.
• Nice to Have:
• Git and basic command-line usage.
• Exposure to cloud platforms (Azure, AWS) or working with APIs.
• Experience with a dashboard or BI tool (Power BI, Tableau, Looker) and PowerPoint skills.
• Exposure to JavaScript or React.
• Familiarity with email marketing metrics, healthcare, or pharma.

Qualifications

• A degree in a quantitative field (statistics, math, computer science, economics, information systems, or similar), or equivalent experience.
• Internships, class projects, and personal projects are considered relevant experience.