DescriptionThere'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: Do you want to join a company that takes pride in the work they do? Do you want to work for a company that helps you navigate your career and invests in your development? Is having an open and transparent leadership team important to you in your next role? If you answered yes to the above questions, you are in luck… PulsePoint is hiring!A Bit About UsPulsePoint 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 scriptsTroubleshoot client reporting issues and work on improvements for future reportsPerform data analysis to identify trends, patterns, and anomalies in the dataWrite, optimize, and maintain complex SQL queries from various databasesPerform cross DB system checks and migrationsResearch and document report generation processes, data sources, and methodologies for transparency and future referenceBuild 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 EngineerStrong SQL skills (experience with complex queries/multi join/CTEs/window functions a must)Hands-on experience with Python for data manipulation, analysis, and scriptingGood communication skills, with the ability to present data findings clearlyStrong organizational skills, attention to details and the ability to manage multiple tasks simultaneouslyStrong analytical and problem-solving skills, with attention to detail and a proactive approach to data-driven decision-makingExcellent communication and interpersonal skills to collaborate effectively with cross-functional teamsExperience 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 hoursWhat are the nice-to-haves we’re looking for:Exposure to DevOps tools including JIRA, Git, Docker, and Alluxio is a plusLocation & Hours:Can work remotely anywhere in IndiaHours: 3:30pm-12:30am IST (ending at 2pm ET)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.We can hire this as Mumbai office-based or fully remoteTime Off:21 PTOs + 10 company-wide holidaysHealth Insurance Policy (Self & Family):Every employee and their immediate family are covered under Health Insurance Policy worth INR. 500,000Term Life Insurance & Personal Accidental Insurance:Every employee is covered under Term Life Insurance and Personal Accident Insurance Policy worth INR. 25,00,000/- eachSelection 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.
