Senior Data Analyst

Job ID 2021-3597

Market Research & Analytics New York, New York


Description

Position at WebMD

WebMD is the most recognized and trusted brand of health information and the leading provider of health information services, serving consumers, physicians, healthcare professionals, employers and health plans through our public and private online portals and WebMD the Magazine. The WebMD Health Network includes WebMD, Medscape, MedicineNet, eMedicine, RxList, theheart.org and Medscape Education. Our consumer portals and mobile health applications provide engaging, relevant and credible health and wellness information, personalized health assessment tools and access to online communities.

WebMD 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.

Responsibilities: Internet Brands/Medscape is currently seeking a Sr.Data Analyst responsible for understanding data process flow and reporting requirements.  This role will vet requirements; identify data handoffs; understand transformations and pinpoint potential for data loss or corruption. With this understanding the role will develop reporting tools across multiple platforms to follow the data, identify anomalies and provide analysis, recommendations, and remediation steps. The role requires a full technical knowledge of all phases of the marketing pipeline and being able access the data across multiple database and data stores.  This role will play an active role in quality assurance reviews, working with QA Teams and other business verticals to resolve issues.

 

Responsibilities Include:

 

  • Meet with internal clients to understand products, applications, data flows and marketing strategy.
  • Use SQL and analytic skills to analyze program engagement, provide trend analyses.
  • Develop Data objects and reports to support the requirements of the role.
  • Unit test program setups and reports.
  • Data analysis.
  • Maintain documentation data process.
  • Translate business requirements and understand technical designs.
  • Investigating changes in traffic, engagement, retention and click through and assisting in identifying root causes.
  • Creating standard and ad-hoc reports provided daily/weekly/monthly with insights into emerging patterns aligned with business initiatives that may be driving the changes

 

Qualifications:

  • A bachelor's degree in computer science, information systems, statistics or a related discipline, or 4 years of experience in data analysis.
  • Working knowledge of Unix/Linux.
  • 4 years working knowledge of at least one of Oracle RDBMS, SQL Server, Vertica.
  • 2 years working knowledge of NoSQL data bases such as Mongo.
  • Advanced SQL skills - must be able to write complex SQL with multiple table joins against very large data sets
  • Experience with database discovery tools, such as Toad or DbVisualizer
  • Self-motivated, proactive and self-sufficient with the ability to create intelligent, creative, and action-oriented results
  • Experience working through problems, identifying root causes and providing solutions
  • Strong practical experience with Excel. Proficient in advanced analytic functions such as vlookup, named ranges, pivot tables, formulas, etc.
  • Proficiency with Microsoft Office Suite