Sr. Data Analyst
Job ID 2024-6626
Description
Medscape, a division of WebMD, develops and hosts physician portals and related mobile applications that make it easier for physicians and healthcare professionals to access clinical reference sources, stay abreast of the latest clinical information, learn about new treatment options, earn continuing medical education credits and communicate with peers.
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/MD Alert is currently seeking a Client Data Liaison 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:
- Dedicated client facing point of contact for both the Agency & Manufacturer
- Attending regular meetings driven by Sales Executives, Project Managers and Account Managers to review the status of campaigns.
- Work with all internal & external stakeholders on alignment and execution of reporting requirements
- Internal champion for swift resolution of client inquiries
- Dedicated point of contact for all User Level Data related questions and issues
- Work internally with owners of individual reports/brands to ensure timely resolution issues
- Develop a strong end-to-end knowledge of business processes and data lineage and flow
- Raise and review gaps in client expectations/asks and manage timelines for new features to be included in client solutions
Qualifications:
- Advanced SQL skills - must be able to write complex SQL with multiple table joins against very large data sets
- Strong problem-solving skills and ability to provide and implement solutions.
- 2+ years working knowledge of at least one of Google Big Query, SQL Server, Vertica.
- Experience with database discovery tools, such as DBWeaver or DbVisualizer
- Industry experience in business analysis, business and technical requirements gathering.
- Relationship management or other relevant client-facing experience.
- Self-motivated and demonstrable skills in work in cross-departmental teams to delivery business 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