US_Data and Analytics Specialist II

Job Description: Hybrid - 2 days in office Core Duties and Responsibilities • Data management and development of business intelligence reporting o Ability to absorb and logically structure information into analytical deliverables with established frameworks and tools o Gather requirements, design, and create reports to automate manual processes o Maintain the translation table for media to determine whether we have contacted or engaged with an individual o Review publisher data that has been loaded monthly, and maintain publisher status documentation • Leveraging Adobe Analytics to deliver actionable and comprehensive insights o Measure the impact of paid media on the website and present key findings o Prepare monthly report on account registrations by the Adobe CID for PHM, and provide recommendations to improve account registrations • Optimize digital paid media across display, email, paid search, and social o Extracting paid media data from a variety of sources, manipulating, and analyzing using quantitative and visualization tools o Responsible for populating omnichannel marketing report that provides holistic view on brands performance o Review the Media QBR to validate numbers are accurate, and point out discrepancies in insights Experience: • 3+ years in a business intelligence role • Candidate with prior work experience in digital analytics role is strongly referred o Consulting, analytics, or digital agency background • Experience using industry-standard business intelligence tools to formulate metrics, create data quality management assessments and tools to perform ad hoc data inquiries • High-level attention to detail Skills/Knowledge/Experience • Preference for candidate with prior work experience in digital marketing analytics • Experience with the Adobe Marketing Suite or Google Analytics • Expertise with SQL (Snowflake preferred) • Expertise with Business Intelligence tools: Power BI, Tableau, or Qliksense • Knowledge of and proficiency with digital marketing channels outside of website (i.e. social, search, paid media) • Biotech/pharma experience helpful • Strong analytical and quantitative skillset