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, Immunoscience, 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 :

- Bachelors or Masters 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).