Consultant- Data Aggregation

Beghou; Pune District; Remote; INR 1,000,000 - 1,500,000; Full time

Benefits offered by this job

Collaborative team environment

Opportunities for personal growth

Innovative AI-focused projects

Job summary

A life sciences consulting firm in Pune, India, is seeking a Patient Data Aggregator responsible for the secure collection and management of sensitive patient data. This role involves collaborating with various teams to ensure compliance with data privacy regulations and implementing solutions for data aggregation using Python and PySpark. Candidates should have a Master's degree in Computer Science along with 5+ years in the consulting industry. Familiarity with U.S. pharmaceutical datasets and HISEC standards is crucial. A collaborative and growth-focused work environment awaits you.

Qualifications

• 5+ years of relevant consulting-industry experience.
• Strong understanding of HIPAA and GDPR regulations.
• Ability to work in a High Security environment (HISEC).

Responsibilities

• Collect, clean, and aggregate patient-level data from various sources.
• Apply tokenization techniques for data safety.
• Design and implement end-to-end data aggregation solutions.

Skills

Strong understanding of U.S. pharmaceutical datasets

Logical thinking and problem-solving skills

Strong programming skills in Python

Data modeling and analytics expertise

Experience with data management best practices

Education

Engineering/Master’s degree in Computer Science

Tools

PySpark

Snowflake

Microsoft Office products

Airflow

Job description

Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and building foundational data analytics infrastructures to leveraging artificial intelligence to improve customer insights and engagement, Beghou helps life sciences companies maximize performance across their portfolios. Beghou also deploys proprietary and third-party technology solutions to help companies forecast performance, design territories, manage customer data, organize, and report on medical and commercial data, and more. Headquartered in Evanston, Illinois, we have 10 global offices.

The Patient Data Aggregator is responsible for the secure collection, standardization, and aggregation of sensitive patient data across multiple systems to support clinical, operational, and research needs. This role requires a strong understanding of data privacy protocols, including de‑identification methodologies such as tokenization and expert determination, and must operate within a HISEC‑compliant (High Security) environment. The candidate will collaborate with cross‑functional teams to ensure data is managed in a secure, compliant, and usable manner. If you are passionate about utilizing your expertise in U.S. pharmaceutical datasets to drive client success, we invite you to apply for this exciting opportunity!

Responsibilities

• Collect, clean, and aggregate patient‑level data from Electronic Health Records (EHRs), lab systems, and external databases.
• Apply tokenization techniques to replace direct identifiers while preserving data integrity for linkage and analysis.
• Perform or support expert determination de‐identification processes to evaluate and minimize re‑identification risk in datasets.
• Ensure all activities comply with HIPAA, and institutional privacy policies, particularly within HISEC environments.
• Manage and maintain secure data pipelines and repositories for sensitive patient information.
• Assist in the development of standard operating procedures (SOPs) for secure data aggregation and handling.
• Support the generation of anonymized datasets for research, analytics, or external data sharing initiatives.
• Monitor data quality, flag inconsistencies, and ensure proper documentation of data provenance and transformation.
• Provide support for audits, security assessments, and internal data governance reviews.
• Design and implement end‑to‑end data aggregation solutions tailored to business requirements using Python and PySpark.
• Synthesize findings, develop recommendations, and communicate results to clients and internal teams.
• Assume project management responsibilities for data aggregation implementation on each project with minimal supervision, including managing onshore/client communication, leading meetings, and drafting agendas.
• Manage multiple projects simultaneously while meeting deadlines.

Qualifications

• Engineering/Master’s degree from a Tier‑I/Tier‑II institution/university in Computer Science or relevant concentration, with evidence of strong academic performance.
• 5+ years of relevant consulting‑industry experience.
• Deep understanding of data management best practices, data modeling, and data analytics.
• Strong understanding of U.S. pharmaceutical datasets and their applications.
• Experience with tokenization tools/methods and expert determination for de‑identification.
• Logical thinking and problem‑solving skills along with an ability to collaborate.
• Familiarity with HISEC standards or other high‑security frameworks.
• Strong programming skills in Python and working knowledge of PySpark.
• Proficiency in Microsoft Office products, data analysis tools (e.g., Snowflake, Redshift), and job orchestration (Airflow, Databricks workflows).
• Strong understanding of HIPAA, GDPR, and related data privacy regulations.
• Excellent verbal and written communication skills, with the ability to convey complex information clearly to diverse audiences.
• Strong organizational abilities and effective time‑management skills.
• Ability to thrive in an international matrix environment and willingness to support U.S. clients during U.S. working hours with 3‑4 hours of overlap.

At Beghou Consulting, you'll join a highly collaborative, values‑driven team where technical excellence, analytical rigor, and personal growth converge. Whether you're passionate about AI innovation, building commercialization strategies, or shaping the next generation of data‑first solutions in life sciences, this is a place to make an impact!

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.