Data Engineer (Remote) in PulsePoint

A bit about us:PulsePoint is a leading 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.Data EngineerPulsePoint 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 (> 20TB of data, 220 TB uncompressed). This data is used to generate reports, update budgets, and drive our optimization engines. We do all this while running against extremely 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 initiativesOptimize jobs to utilize Kafka, Hadoop, Presto, Spark, and Kubernetes resources in the most efficient wayMonitor 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 backgroundsProvide mentorship and guidance to junior team membersTeam Responsibilities:Ingest, validate and process internal & third party dataCreate, maintain and monitor data flows in Spark, Hive, SQL and Presto for consistency, accuracy and lag timeMaintain 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 aggregationTool evaluation/selection/implementationBackups/Retention/High Availability/Capacity PlanningReview/Approval - DDL for database, Hive Framework jobs and Spark Streaming to make sure they meet our standardsTechnologies We Use:Airflow - for job schedulingDocker - Packaged container image with all dependenciesGraphite/Beacon - for monitoring data flowsHive - SQL data warehouse layer for data in HDFSKafka- distributed commit log storageKubernetes - Distributed cluster resource managerPresto - fast parallel data warehouse and data federation layerSpark Streaming - Near time aggregationSQL Server - Reliable OLTP RDBMSGCP BQRequirements:5+ years of data engineering experienceStrong recent Spark experienceOn-prem experienceFluency in Python, experience in Scala/Java is a hugeplus (Polyglot programmer preferred!)Proficiency in LinuxStrong understanding of RDBMS, SQL;Passion for engineering and computer science around dataKnowledge and exposure to distributed production systems i.e Hadoop is a huge plusKnowledge and exposure to Cloud migration is a plusWilling and able to work East Coast U.S. hours (9am-6pm EST), you can work remotelyWillingness to participate in 24x7 on-call rotationSelection Process:1) Initial Screen (30 mins)2) Hiring Manager Interview (45 mins)3) Tech Challenge4) Team Interview (60 mins + 3 x 45 mins) + SVP of Engineering (15 mins)5) WebMD Sr. Director, DBA (30 mins)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. Show more Show less Посадовий рівень Старший середній рівень Тип зайнятості Повний робочий день Посадові обов’язки Аналітик і Інженерія Галузі Маркетингові послуги