Consultant, Data Aggregation

Beghouconsulting; New York (NY); Hybrid; USD 90,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) with company match

Generous PTO and holidays

Job summary

Beghou is seeking an experienced Data Aggregation Lead to manage conception, execution, and delivery of data aggregation systems for life sciences firms. You will oversee client interactions, define project scopes, and drive growth across data initiatives and hub services.

You will lead teams, manage budgets, and coordinate with global stakeholders while promoting innovation and collaboration within a hybrid work environment.

Qualifications

• Bachelor’s or advanced degree with at least 5 years of relevant professional experience.
• Proficiency with MS Office; advanced Excel.
• Experience implementing or supporting patient and/or payer data management solutions in the US pharmaceutical market.
• Experience with patient-level claims, hub, and specialty pharmacy data.
• HIPAA-compliant data management.
• Experience with external vendors and data exchanges.
• Coding skills (SAS, Python, R, VBA) and data viz tools (Tableau, Power BI).

Responsibilities

• Oversee and develop Data Aggregation projects and capabilities; deliver quality client services on time and budget.
• Develop data management and reporting suites across patient and channel data.
• Analytics and reporting for patient support programs, hub services, prior authorizations, appeals, and copay assistance.
• Define project scope and approach; conduct issue analysis and hypothesis development.
• Coordinate data exchanges with vendors and resolve data quality issues.
• Synthesize findings, develop recommendations, and communicate results to clients and internal teams.
• Contribute to product development initiatives and build data processes.
• Coach and mentor junior team members and manage client relationships.

Skills

Data Aggregation

Project management

Communication

HIPAA data

SAS

Python

R

Power BI

Tableau

Excel advanced

Education

Bachelor’s or advanced degree

Tools

SQL

CRM systems

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.

Our mission is to bring together analytical minds and innovative technology to help life sciences companies navigate the complexity of health care and improve patient outcomes.

Position Overview

This position leads client projects in the conception, execution, and delivery of Data Aggregation systems for life science firms. Additionally, this position plays a pivotal role in managing client interactions regarding existing and future Data Aggregation projects and identifies areas for future growth.

Responsibilities

• Oversee and develop Data Aggregation (specialty pharmacy, hub, specialty distributor, 3PL) projects and capabilities; consistently deliver quality client services and drive projects within expected timeframes and on budget.
• Develop data management and reporting suites across patient and channel data.
• Manage analytics and reporting for patient support programs, including hub services, prior authorizations, appeals, and copay assistance.
• Work with project leadership to define project scope and development approach for each project, including conducting issue analysis and hypothesis development.
• Coordinate with data vendors to establish data exchanges and to resolve data quality issues.
• Synthesize findings, develop recommendations, and communicate results to clients and internal teams.
• Contribute to product development initiatives.
• Work independently or with a team to build out data processes.
• Coordinate with diverse teams, including those globally.
• Provide project leadership for team members regarding process improvements, planned approaches for client requests, or transition of new deliverables.
• Monitor progress, manage risk, and ensure key stakeholders are kept informed about progress and expected outcomes; manage project finances by maintaining financial summaries, drafting SOWs for new work, and managing client invoices.
• Assist in supporting management, including promoting employee engagement, recruiting, training, and providing ongoing education, employee mentorship and coaching; contribute to internal initiatives as needed.
• Foster an innovative and inclusive team-oriented work environment.
• Coach and mentor junior team members on their professional development and serve as their Professional Development Manager.
• Grow external client engagements, owning aspects of the relationship between the client and the firm.

Qualifications

• Bachelor’s or advanced degree with at least 5 years of relevant professional experience.
• Proficiency using Microsoft Office products, such as PowerPoint and Word; advanced Excel skills required.
• Proven experience implementing or supporting patient and/or payer data management solutions in the US pharmaceutical market.
• Experience working with patient-level claims, hub, and specialty pharmacy data.
• Experience with HIPAA‑compliant data management.
• Experience working with specialty distributor EDI (852, 867) data preferred.
• Experience with other commercial life sciences datasets (CRM, payer reference, claims, etc.) preferred.
• Coding skills (SAS, Python, R, VBA, etc.) and knowledge of data visualization software such as Tableau or Power BI, preferred.
• Strong project management and people management skills.
• Advanced analytical and problem‑solving abilities.
• Excellent organizational, time management, and communication skills.
• Knowledge of data management best practices in the pharmaceutical industry.

Preferred Qualifications

• Experience in specialty therapeutics, oncology, or rare disease.
• Knowledge of medical and pharmacy claims structures, including ICD‑10, CPT, and NDC codes.
• Familiarity with patient services platforms such as Salesforce, AssistRx, or ConnectiveRx.
• Experience managing external vendors and partners.

Compensation and Benefits

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, skill sets; experience and training; licensure and certifications; and other business and organizational needs. At Beghou, it is not typical for an individual to be hired at or near the top of the range for their role, and compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $90,000 to $110,000.

Health & Wellness

We provide comprehensive medical, dental, and vision insurance, as well as life & AD&D coverage, disability insurance, and a Lifestyle Wellness Account to help you feel your best.

Work‑Life Balance

Our generous PTO, company holidays, and paid parental & bonding leave help you recharge and be present where it matters most. With a flexible hybrid work policy, you’ll enjoy the balance of in‑person collaboration and remote flexibility.

Financial Wellness

We invest in your future with a 401(k) and employer match, tax‑free commuter, health, and childcare accounts, and performance bonuses. You’ll also receive a monthly phone stipend and access to an employee discount program.

Growth & Giving Back

Through mentorship, training, and tuition reimbursement, we help you grow your career while supporting causes you care about with a charitable donation match.

Culture & Values

Collaboration, innovation, and inclusion define us. Here, you’ll join a community that values your ideas and celebrates your impact.

Equal Opportunity Employer

We are committed to fostering an inclusive company culture that respects and promotes diverse backgrounds and points of view. We seek candidates who will add to our culture and support the company’s vision of a diverse, equitable, inclusive, and collaborative workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, disability, age, or veteran status. We are proud to be an equal‑opportunity employer. If you are excited about this role but do not meet 100% of the qualifications listed, we still encourage you to apply. You may be just the right candidate for this or other roles.

Must be legally authorized to work in the United States.

We are currently unable to consider candidates who require, or will require in the future, sponsorship for work authorization. Applicants must be authorized to work in the US on a permanent and ongoing basis without the need for current or future employer‑sponsored work authorization.