Description
There's likely a reason you've taken the time out of your busy day to review this opportunity at PulsePoint. Maybe you're in need of a change or there's 'an itch you're looking to scratch'. Whatever the reason, ask yourself the following questions:
If you answered yes to the above questions, you are in luck… PulsePoint is hiring!
A Bit About Us
PulsePoint is a fast-growing healthcare technology company (with adtech roots) using real-time data to transform healthcare. We help brands and agencies interpret the hard-to-read signals across the health journey and unify these digital determinants of health with real-world data to produce the most dimensional view of the customer. Our award-winning advertising platforms use machine learning and programmatic automation to seamlessly activate this data, making marketing, predictive analytics, and decision support easy and instantaneous.
Our Data & Analytics team is at the very heart of what makes PulsePoint an innovative, fast-paced and market-changing company.
Our path forward is through data and this team is in the driver seat for the journey.
The Big Picture:
Data Analytics team is looking for a motivated Sr. Data Analyst with strong SQL and Python skills to contribute to Client Reporting support and collaborate closely with business teams to run reliable and scalable reporting infrastructure. The ideal candidate has strong analytical skills, a keen eye for detail, experience with complex SQL queries, and is eager to learn and grow within a data-driven environment.
Specifically, here are some things you'll be working on:
Collaborate with business teams to turn client requirements into scripts
Troubleshoot client reporting issues and work on improvements for future reports
Perform data analysis to identify trends, patterns, and anomalies in the data
Write, optimize, and maintain complex SQL queries from various databases
Perform cross DB system checks and migrations
Research and document report generation processes, data sources, and methodologies for transparency and future reference
Build and maintain robust data models and schemas that support client reporting and internal dashboard functionalities (Tableau/Looker/Python Scripts)
What are the “must-haves” we’re looking for?:
At least 3-5 years of experience as a Data Analyst or Data Engineer
Strong SQL skills (experience with complex queries/multi join/CTEs/window functions a must)
Hands-on experience with Python for data manipulation, analysis, and scripting
Good communication skills, with the ability to present data findings clearly
Strong organizational skills, attention to details and the ability to manage multiple tasks simultaneously
Strong analytical and problem-solving skills, with attention to detail and a proactive approach to data-driven decision-making
Excellent communication and interpersonal skills to collaborate effectively with cross-functional teams
Experience with distributed query engines (hive/presto/trino/bigquery)
Familiarity with analysis and reporting tools (Excel, Tableau, Looker)
Willingness and ability to work 3:30pm-12:30am IST, or overlap at least 4 hours with East Coast U.S. work hours
What are the “nice-to-haves” we’re looking for?:
Location & Hours:
Comp Structure & Benefits:
Comp structure: fixed (inclusive of PF, Gratuity, and a 25k INR medical premium) + a target annual bonus that is approximately 5% of the gross annual earnings. Note that we don’t offer stock options.
Time Off: 21 PTOs + 10 company-wide holidays
Health Insurance Policy (Self & Family): Every employee and their immediate family are covered under Health Insurance Policy worth INR. 500,000
Term Life Insurance & Personal Accidental Insurance: Every employee is covered under Term Life Insurance and Personal Accident Insurance Policy worth INR. 25,00,000/- each
Selection Process:
1st SQL Test (45 minutes)
2nd SQL Test (25 minutes)
Initial Screening Call (30 minutes)
Video Call w/ Manager, Reporting & Analytics (45 minutes)
Video Call w/ VP of Analytics & Client Reporting (30 minutes)
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.
