Senior Analyst, Data Enablement (Media Advertising)

PHM is the leading health media agency in the US. We are designed for—and dedicated to—delivering best-in-class solutions that connect people with meaningful health and wellness solutions every day. Guided by our genuine passion for health and wellness, our work across the entire media ecosystem helps real patients navigate the most pivotal moments of their healthcare journeys.

While we have grown to be the No. 1 agency in our industry, at heart we’re still a startup. It’s that energy and spirit of innovation that allows us to create bold and meaningful “health media firsts” for our clients, and to do it all with #phmlove.

The Senior Analyst of Data Engineering will play a hands-on and supportive role within PHM’s Data Enablement Department. This team is responsible for processing and maintaining all incoming data, as well as serving as the primary liaison for PHM’s data needs with HCP publishers.

This individual will work closely with internal teams, external partners, and industry vendors to monitor data transfers, conduct data quality assurance, and maintain documentation. Additionally, they will support the Director of Data Engineering in enforcing enterprise-wide data processes and protocols.

The ideal candidate will have previous experience in a similar role within media advertising. 

This is a hybrid role requiring 3 days in office.

Responsibilities

• Support a portfolio of data projects across multiple client accounts.
• Collaborate with cross-functional teams, including Media Tech, BI, Media, Strategy, Investments, and Tech & Data.
• Leverage data warehouse and ETL solutions to manage and execute data transfers efficiently.
• Automate data retrieval, transformation, and loading processes to improve efficiency.
• Execute data management tasks, such as feed ingestion and metadata organization.
• Monitor and enhance data stability, security, and compliance in all processes.
• Analyze trends, present insights, and provide recommendations to both internal and external stakeholders.
• Troubleshoot and resolve data engineering issues in collaboration with BI, Technology, and Data teams.
• Maintain and enforce best practices for data handling, storage, and utilization.

• Experience managing and resolving database and BI-related incidents and service requests for media advertising initiatives. 
• Strong understanding of database structures, theories, principles, and ETL/data warehousing concepts.
• Proficiency in SQL, ETL processes, and analyzing large datasets.
• Strong communication skills with the ability to translate complex technical concepts into user-friendly language.
• Experience in technical documentation and data governance best practices.
• Technical Skills & Experience

• SQL & Data Engineering: Minimum 2 years of SQL experience, 1 year of ETL experience, and 2 years analyzing large datasets.
• Business Intelligence Tools: Minimum 2 years of BI experience with platforms like Tableau and Datorama.
• Data & Cloud Technologies: Experience with data warehouses and cloud solutions (Databricks preferred, AWS/Azure a plus).
• Marketing Data Experience: Familiarity with web and digital marketing data (preferred).
• Advanced Excel Skills: Strong knowledge of data manipulation within Excel.

Compensation Range: $72,390 - $109,480 Annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 3/13/25.

#LI-RB4

Salary : $72,390 - $109,480