Senior Analyst, Data Engineering (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.

Responsible for developing and supporting data products and automation, the Senior Analyst, Data Engineering, Tech & Data plays a critical role in the development of Business Intelligence (BI) and data warehouse solutions and initiatives utilized by internal and external stakeholders. These solutions and initiatives include dashboard visualization and reporting development; data warehouse solution design and development; and data ingestion, quality assessment, and delivery.

The ideal candidate will have previous experience designing solutions for media advertising initiatives.  

This is a hybrid role requiring 3 days a week in office.

• Create high performance data products and BI solutions (leveraging Datorama, Tableau, Power BI, etc)
• Support a portfolio of different clients across the agency 

• Collaborate with Engineering and BI teams to optimize and maintain data products and solutions
• Track and resolve data product and database related incidents and support requests
• Build data flow automations for the retrieval, transformation, and loading of data
• Maintain best practices for managing and storing data
  • ETL/data feed creation and management
  • Metadata management
  • Create, alter, delete, grant permissions, indexing, updating
  • Query tuning
• Tools
  • Database Platforms: SQL Server, RedShift
  • BI Platforms: Tableau, Datorama, Power BI
  • Cloud Technologies: Databricks, Snowflake, AWS, Azure, Python

• BS Degree within a preferred subject area of: Computer Science, Information Technology, or related field
• Experience designing solutions for media advertising initiatives 
• 2 years of experience designing and developing BI and data solutions
• Client-facing experience or experience working directly with internal stakeholder teams
• Strong understanding of database structures, theories, principles, and practices
• Strong understanding of ETL and data warehouse principles
• Ability to present complex ideas in user-friendly language
• 1 years SQL experience, 1 years ETL experience
• 1   years experience working in cloud technologies (Snowflake, Databricks)
• 1 years experience developing data solutions in BI tools (Tableau, Datorama, Power BI)

Preferred Skills:

• 2 years of BI experience and/or experience working in BI Tools such as Tableau, Datorama, and Power BI
• Experience analyzing large data sets
• Experience with database structures, theories, principles, and practices
• Experience tracking and resolving BI and database related incidents and requests
• Experience with digital marketing data and/or pharmaceutical data
• Experience writing or maintaining technical documentation

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 03/13/2025.

#LI-RB4

Salary : $72,390 - $109,480