Key Facts

Remote From:

United Kingdom

Full time

English

Hard Skills

SQL (Programming Language) Python (Programming Language) Apache Spark Apache Kafka Data-Flow Analysis Kubernetes Linux Graphite (Software) Data Architecture File Systems +22 more

Other Skills

•
Mentorship
•
Teamwork
•
Collaboration
•
Communication

Roles & Responsibilities

8+ years of data engineering experience.
Strong SQL and Python skills, with 3+ years of Spark experience.
Experience with Hadoop and Hive in on-prem environments.
Proficiency in Linux and a solid understanding of RDBMS and query optimization; knowledge of distributed production systems and cloud migration (AWS/GCP/Azure) is a plus.

Requirements:

Design, build, and maintain reliable and scalable enterprise-level distributed transactional data processing systems to scale the business and support new initiatives.
Optimize data processing jobs to efficiently utilize Kafka, Hadoop, Presto, Spark, and Kubernetes resources; monitor data quality across systems.
Ingest, validate, and process internal and third-party data; create and maintain data flows in Python, Spark, Hive, SQL, and Presto with a focus on accuracy and low lag.
Collaborate within a small, diverse team and provide mentorship to junior engineers; review DDLs for databases and Hive framework jobs to ensure standards.

PulsePoint

Marketing & Advertising

About PulsePoint

PulsePoint is an advanced data and technology company that is breaking new ground with programmatic solutions for healthcare organizations, to personalize information and improve outcomes. We are leading a revolution in radical health personalization to help organizations improve how they provide care, education and support to people when they need it most. Through programmatic automation, we interpret the hard to read signals of the customer journey and understand the connection points between relevance and engagement. This enables us to deliver a suite of tools that allow for the seamless activation of health options.

Company type: SME

Industry: Marketing & Advertising

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

Description

A bit about us:

PulsePoint is a leading healthcare ad technology company that uses real-world data in real-time to optimize campaign performance and revolutionize health decision-making. Leveraging proprietary datasets and methodology, PulsePoint targets healthcare professionals and patients with an unprecedented level of accuracy—delivering unparalleled results to the clients we serve. The company is now a part of Internet Brands, a KKR portfolio company and owner of WebMD Health Corp.

Sr. Data Engineer

PulsePoint Data Engineering team plays a key role in our technology company that’s experiencing exponential growth. Our data pipeline processes over 80 billion impressions a day (> 20 TB of data, 200 TB uncompressed). This data is used to generate reports, update budgets, and drive our optimization engines. We do all this while running against tight SLAs and provide stats and reports as close to real-time as possible.

The most exciting part about working at PulsePoint is the enormous potential for personal and professional growth. We are always seeking new and better tools to help us meet challenges such as adopting proven open-source technologies to make our data infrastructure more nimble, scalable and robust. Some of the cutting-edge technologies we have recently implemented are Kafka, Spark Streaming, Presto, Airflow, and Kubernetes.

What you'll be doing:

Design, build, and maintain reliable and scalable enterprise-level distributed transactional data processing systems for scaling the existing business and supporting new business initiatives
Optimize jobs to utilize Kafka, Hadoop, Presto, Spark, and Kubernetes resources in the most efficient way
Monitor and provide transparency into data quality across systems (accuracy, consistency, completeness, etc)
Increase accessibility and effectiveness of data (work with analysts, data scientists, and developers to build/deploy tools and datasets that fit their use cases)
Collaborate within a small team with diverse technology backgrounds
Provide mentorship and guidance to junior team members

Team Responsibilities:

Ingest, validate and process internal & third party data
Create, maintain and monitor data flows in Python, Spark, Hive, SQL and Presto for consistency, accuracy and lag time
Maintain and enhance framework for jobs(primarily aggregate jobs in Spark and Hive)
Create different consumers for data in Kafka using Spark Streaming for near time aggregation
Tools evaluation
Backups/Retention/High Availability/Capacity Planning
Review/Approval - DDL for database, Hive Framework jobs and Spark Streaming to make sure they meet our standards

Technologies We Use:

Python - primary repo language
Airflow/Luigi - for job scheduling
Docker - Packaged container image with all dependencies
Graphite - for monitoring data flows
Hive - SQL data warehouse layer for data in HDFS
Kafka - distributed commit log storage
Kubernetes - Distributed cluster resource manager
Presto/Trino - fast parallel data warehouse and data federation layer
Spark Streaming - Near time aggregation
SQL Server - Reliable OLTP RDBMS
Apache Iceberg
GCP - BigQuery for performance, Looker for dashboards

Requirements

8+ years of data engineering experience
Strong skills in and current experience with SQL and Python
Strong recent Spark experience (3+ years)
Experience working in on-prem environments
Hadoop and Hive experience
Experience in Scala/Java is a plus (Polyglot programmer preferred!)
Proficiency in Linux
Strong understanding of RDBMS and query optimization
Passion for engineering and computer science around data
East Coast U.S. hours 9am-6pm EST; you can work fully remotely
Notice period needs to be less than 2 months (or 2 months max)
Knowledge and exposure to distributed production systems i.e Hadoop
Knowledge and exposure to Cloud migration (AWS/GCP/Azure) is a plus

Location:

We can hire as FTE in the, U.S., UK and Netherlands
We can hire as long-term contractor (independent or B2B) in most other countries

Selection Process:

1) CodeSignal Online Assessment

2) Initial Screen (30 mins)

3) Hiring Manager Interview (45 mins)

4) Tech Challenge

5) Interview with Sr. Data Engineer (60 mins)

6) Team Interviews (90 mins + 3 x 45 mins) + SVP of Engineering (30 mins)

7) WebMD Sr. Director, DBA (30 mins)

Note that leetcode-style live coding challenges will be involved in the process.

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.