Director, Business Intelligence

Jobvite, Inc.; United States; On-site; USD 150,000 - 160,000; Full time

Benefits offered by this job

Health Insurance

Paid Time Off

401(k) Retirement Plan with employer</

Life and Disability Insurance

Employee Assistance Program

Commuter/Transit Benefits

Job summary

WebMD is seeking a Director - Database Analysis to join our Business Intelligence team. In this role, you will generate revenue and business insights through database analysis and solve analytical business problems posed by all levels of management, from C-suite to operations.

You will lead ad hoc analyses on a 180 TB data warehouse using advanced SQL, support new data products, and guide junior staff. Collaboration with Sales on RFPs and campaigns is expected to optimize financial return.

Qualifications

• Bachelor’s degree in economics, finance, marketing, or quantitative field (or 8 years equivalent experience).
• Minimum of 8 years experience in financial or marketing analysis.
• Strong database analysis experience, including authoring code in SQL or comparable language.

Responsibilities

• Conduct ad hoc database, financial, marketing, and other quantitative analyses on a 180 TB data warehouse.
• Support the development of new data products and predictive analysis to increase sales.
• Provide analytical support to optimize site performance and financial return; mentor junior staff.

Skills

Advanced SQL

Database analysis

Tableau

Excel

Toad/DB Visualizer

Analytical thinking

Education

Bachelor’s degree in economics, finance, marketing, or quantitative field

8 years equivalent experience

Tools

Vertica

Adobe Analytics

Job description

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.

Position Overview:

WebMD is searching for a Director - Database Analysis to join our Business Intelligence team. In this role, your primary responsibilities will be to generate revenue and business insights through database analysis and solve analytical business problems posed by all levels of management, spanning C-Suite to operations at WebMD.

Key Responsibilities:

• Conduct ad hoc database, financial, marketing, and other forms of quantitative analysis (using self-authored advanced SQL code against a 180 TB data warehouse) to discover answers to widely varying, one-off business questions (including CTE, windowing functions, time series analysis against multiple tables, each with over a billion rows).

• Support the development of new data products and increase sales volume through machine learning and predictive analysis using modeling software from SAP.

• Provide ad hoc analytical and database analysis support to optimize site user interaction and financial return for WebMD.com.

• Provide guidance, management, and leadership to junior staff members.

Support the Sales organization with RFP responses, campaign optimization across media tactics, and renewal efforts by developing creative, quantitative means to prove the value of WebMD.

Typical Assignments:

• Meetings with Senior Management, Marketing, Project Management, and Product Management staff to understand business goals and sales challenges.

• Identifying analytical approaches and appropriate data to investigate business issues/challenges.

• Developing and executing analyses across databases (e.g., Vertica), web analytics (e.g., Adobe), spreadsheet (e.g., Excel), and presentation (Tableau) technologies.

• Validating quality of data and analysis.

Presenting findings with actionable recommendations.

Working Environments & Tool Usage:

• SQL via Toad, DB Visualizer, etc. (60% of time and effort)

• Tableau (20%)

• Excel (10%)

PowerPoint (10%)

Minimum Qualifications:

• Bachelor’s degree in economics, finance, marketing, or quantitative field (or 8 years equivalent experience).

• Minimum of 8 years experience in financial or marketing analysis.

• Strong database analysis experience, including authoring code in SQL or comparable language.

• Strong ability to multi-task in a fast-paced environment.

• Intellectual curiosity, responsible, accountable, and result-driven.

Salary range: $150,000 - $160,000

Bonus Eligible:This position is also eligible for a discretionary company bonus, based upon business results.

Benefits: Employees in this position are eligible to participate in the company sponsored benefit programs, including the following within the first 12 months of employment:

• Health Insurance (medical, dental, and vision coverage)
• Paid Time Off (including vacation, sick leave, and flexible holiday days)
• 401(k) Retirement Plan with employer matching
• Life and Disability Insurance
• Employee Assistance Program (EAP)
• Commuter and/or Transit Benefits (if applicable)

Eligibility for specific benefits may vary based on job classification, schedule (e.g., full-time vs. part-time), work location and length of employment.