Data Analyst

WebMD Ignite, Inc.; Newark (NJ); Hybrid; USD 77,000 - 85,000; Full time

Benefits offered by this job

Health Insurance

PTO

401(k) Retirement Plan

Life and Disability Insurance

Employee Assistance Program

Commuter/Transit Benefits

Job summary

WebMD Ignite, Inc. is seeking a Client Data Analyst in Newark, NJ to understand data flows, vet requirements, and develop reporting across multiple data stores.

You will identify anomalies, provide analyses, and drive remediation steps as part of the marketing pipeline. The role requires knowledge of SQL, Big Query, Excel and Looker, with responsibilities including metadata management, weekly data deliveries, and publishing monthly metrics for campaigns.

Qualifications

• Bachelor's degree in computer science, information systems, statistics or a related discipline, or 1–2 years of data analysis experience.
• 1–2 years working knowledge of at least one of Google BigQuery, SQL Server, Vertica.
• 1–2 years of professional experience in reporting and data analysis using SQL, Excel and Looker.
• Familiarity with SQL; ability to write queries to retrieve and manipulate data from large data sets.
• Experience with visualization tools such as Tableau, Looker, Power BI.
• Industry experience in business analytics, dashboards, KPIs and actionable insights.

Responsibilities

• Understand data process flow and reporting requirements across platforms.
• Vet requirements, identify data handoffs, and note transformations.
• Develop reporting tools to trace data, identify anomalies, and provide remediation steps.
• QA reviews with QA teams and other business verticals to resolve issues.
• Publish monthly metrics for campaigns; run queries as needed.
• Ad hoc tasks for Sales to fulfill client requests.

Skills

Strong problem-solving

Self-motivated

Cross-departmental teamwork

Effective communication

Relationship management

Business analysis

Education

Bachelor's degree in CS/IS/Statistics

Tools

Google BigQuery

SQL Server

Vertica

Looker

Tableau

Power BI

Job description

Jobson Healthcare Information (JHI) is a premier healthcare information and marketing services provider, with leading positions in a variety of growing healthcare markets such as pharmacy, eye care, clinician (physicians, nurse practitioners and physician assistants) and the managed markets (managed care, hospitals and government). Through its diversified, multi-media portfolio of marketing services, information databases, publications, medical education programs, events, websites and other digital and traditional media services, JHI is uniquely positioned to inform and educate a highly targeted network of approximately one million healthcare professionals across multiple specialties.

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.

WebMD/MD Alert is currently seeking a Client 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 databases 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:

• Management of metadata files for PLD custom values
• Troubleshooting aggregate and PLD data issues (skills required: SQL, Big Query, Excel, Looker)
• Setup of tactics for weekly data delivery
• Development and Maintenance of Data Spec (FIAs). This requires several client meetings with client contacts (skills required: Effective Communication, Relationship Management, Business Analysis)
• Publishing monthly metrics for e-tumor board campaigns. It involves some manual operations and running individual queries (skills required: SQL, Big Query, Excel, Looker)
• Ad hoc tasks by Sales team to fulfill client requests

Qualifications:

• A bachelor's degree in computer science, information systems, statistics or a related discipline, or 1-2 years of experience in data analysis
• 1-2 years working knowledge of at least one of Google Big Query, SQL Server, Vertica.
• 1-2 years of professional experience in reporting and data analysis using SQL, Excel and data visualization tools (Looker)
• Familiarity with SQL - must be able to write queries in SQL to retrieve and manipulate data from large data sets
• Experience with Visualization tools such as Tableau, Looker, Power BI etc.
• Industry experience in business analytics, building dashboards, presenting KPIs and creating actionable insights.
• Strong problem-solving skills and ability to provide and implement solutions.
• Self-motivated and demonstrable skills in work in cross-departmental teams to delivery business solutions

Salary range: $76,500 - $85,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.