Consultant_Project Manager – Data Management

PharmaACE is a growing Global Healthcare Consulting Firm, headquartered in Princeton, New Jersey. Our expert teams of Business Analysts, based across the US, Canada, Europe, and India, provide Analytics and Business Solutions using our worldwide delivery models for a wide range of clients. Our clients include established, multinational BioPharma leaders and innovators, as well as entrepreneurial firms on the cutting edge of science. We have deep expertise in Forecasting, Business Analytics, Competitive Intelligence, Sales Analytics, and the Analytics Center of Excellence Model. Our wealth of therapeutic area experience cuts across Oncology, Immuno- science, CNS, CV-Met, and Rare Diseases. We support our clients' needs in Primary Care, Specialty Care, and Hospital business units, and we have managed portfolios in the Biologics space, Branded Pharmaceuticals, Generics, APIs, Diagnostics, and Packaging & Delivery Systems.

Brief Introduction -

This role is ideal for a technically strong Project Manager who can lead data engineering and BI reporting initiatives for Data Management / Data Warehouse enhancement projects. You will manage delivery, ensure compliance with program standards, and bring innovative solutions to accelerate timelines.

Responsibilities-

Project Planning & Governance

Define scope, timelines, and deliverables for Data Warehouse and Data Engineering projects

Ensure adherence to standards and governance defined by the larger program

Maintain detailed project plans, risk registers, and progress reports

Technical Leadership (SME Role)

Act as the Subject Matter Expert for Data Warehousing, and BI reporting

Design and validate data pipelines, ETL / ELT workflows, and integration strategies for analytics and BI platforms

Hands-on experience with Snowflake, Databricks, and modern cloud data ecosystems (AWS, Azure, GCP)

Solve complex technical challenges without relying on other architects or SMEs

BI Reporting Enablement

Oversee integration with BI tools and ensure optimized reporting structures

Strong experience with Tableau, MicroStrategy, and Tellius for dashboarding and visualization

Translate business requirements into scalable reporting and analytics solutions

Quality Assurance & Compliance

Validate data accuracy and integrity post-deployment

Coordinate UAT and manage defect resolution

Ensure compliance with pharma data privacy and regulatory standards

Process Optimization & Continuous Innovation

Identify opportunities for automation and performance improvements in ETL and reporting processes

Foster an innovative mindset to leverage emerging technologies, including

Generative AI , for accelerating project delivery and improving efficiency.

Qualifications-

Bachelor’s or Master’s in Engineering, Computer Science, or related field

Minimum 5 years of experience in

data management , with at least 3 years in

Data Warehouse / Data Lakehouse and Data Engineering projects

Strong experience managing

data platforms for large pharmaceutical clients

Deep expertise in

data architecture, ETL / ELT processes, data modeling, and BI reporting

Hands-on experience with

Snowflake, Databricks , and cloud-based data platforms (AWS, Azure, GCP).

Familiarity with BI tools such as

Tableau, MicroStrategy, PowerBI, Tellius

Exposure to

Generative AI

for accelerating project delivery is a strong plus

Ability to quickly learn and adapt to new tools and processes for faster onboarding

PMP or Agile certification preferred

Other Competencies

Strong analytical and problem-solving skills; ability to think strategically and act tactically

Excellent communication and stakeholder management skills

Entrepreneurial orientation and ability to work in a fast-paced environment

Proficiency in MS Excel, PowerPoint, and project management tools (JIRA, MS Project, MS ADO)