Sr. Data Analyst, Programmatic Advertising

WebMD and its affiliates is an Equal Opportunity/Affirmative Action employer and does not discriminate on the basis of race, ancestry, color, religion, sex, gender, age, marital status, sexual orientation, gender identity, national origin, medical condition, disability, veterans status, or any other basis protected by law.

About PulsePoint:PulsePoint is a fast-growing healthcare technology company (with adtech roots) using real-time data to transform healthcare. We help brands and agencies interpret the hard-to-read signals across the health journey and unify these digital determinants of health with real-world data to produce the most dimensional view of the customer. Our award-winning advertising platforms use machine learning and programmatic automation to seamlessly activate this data, making marketing, predictive analytics, and decision support easy and instantaneous.

Description:Our Data & Analytics team is at the very heart of what makes PulsePoint an innovative, fast-paced and market changing company.

Our path forward is through data and this team is in the driver seat for the journey.

This is an exciting opportunity to support the Legal omnichannel/programmatic strategy, collaborate with Legal business leaders, and help our parent company expand the Legal vertical into programmatic capabilities.

The Big Picture:Our Data Analysts build, deliver & continually innovate on PulsePoint's insightful reporting and data-driven solutions. Their efforts help alleviate friction points and streamline processes that enable internal teams to provide exceptional service, powering the decisions of our customers. In short, they are the conduit through which we will revolutionize health decisions through real time data.

What You’ll Be Doing:Audience model development for LegalDevelop audience characteristicsProvide close analytical support to campaign management to develop, optimize, and troubleshoot campaigns and audience deploymentsWork with Product and Data Engineering teams to turn the models into a “test and production” environment (e.g., prepare data aggregates and data pipelines to facilitate the insights and put the audience model to work against the bidstream)Collaborate with internal teams to delight our customers with timely and accurate data reporting which meets all requirements;Research & implement new data products or capabilitiesAutomate data visualization and reporting capabilities that empower users (both internal and external) to access data on their own thereby improving quality, accuracy and speedSynthesize raw data into actionable insights to drive business results, identify key trends and opportunities for business teams and report the findings in a simple, compelling wayEvaluate and approve additional data partners or data assets to be utilized for identity resolution, targeting or measurementEnhance PulsePoint's data reporting and insights generation capability by publishing internal reports about Health dataAct as the “Subject Matter Expert” to help internal teams understand the capabilities of our platforms, how to implement & troubleshoot

RequirementsWhat are the ‘must haves’ we’re looking for?Minimum 3-5 years of relevant experience in:Creating SQL queries from scratch using real business data;Highly proficient knowledge of Excel (pivot tables, VLOOKUP, formulas, functions)Data analysis & manipulationPythonAt least a Bachelor’s degree in Business Intelligence and Analytics or closely related fieldFull-stack toolset: hard stats/data skills, model development, campaigns execution, business sense, real-time data engineeringExperience in Programmatic/Adtech

What other things would get us excited about you:One of:ELT experienceTableau/Looker/PowerBIExperience with automationStats backgroundAble to organize large data sets to answer critical questions, extrapolate trends, and tell a storyFamiliarity with health-related data setsProject Management skills

Benefits:Comprehensive healthcare with medical, dental, and vision options, and 100%-paid life & disability insurance401(k) MatchGenerous paid vacation and sick timePaid parental leave & adoption assistanceAnnual tuition assistanceBetter Yourself Wellness programCommuter benefits and commuting subsidyGroup volunteer opportunities and fun eventsA referral bonus program -- we love hiring referrals here at PulsePointAnd there’s a lot more!

What are ‘red flags’ for us:Candidates won’t succeed here if they haven’t worked closely with data sets or have simply translated requirements created by others into SQL without a deeper understanding of how the data impacts our business and, in turn, our clients’ success metrics.

Selection Process:Online SQL test (40 mins)Initial Phone Screen (30 mins)Video Calls w/ SVP of Analytics, Sr. Data Analyst, and Sr. Director of Analytics (30 mins each)Video Call w/ IB Exec (30 mins)