Digital Platforms, Senior Data Engineer

PCI TRGR Penn Pharmaceutical Services Ltd; Philadelphia (Philadelphia County); On-site; USD 120,000 - 180,000; Full time

Job summary

PCI Pharma Services seeks a Senior Data Engineer specializing in the Databricks platform to design, build, and support scalable data pipelines on AWS. You will own data models, governance, and CI/CD practices to ensure reliable analytics and AI/ML readiness across teams.

You will collaborate with the Data Platform Lead, Product, Project Management, Testing, Customer Success, and external partners to deliver resilient data solutions and maintain compliance with regulatory standards.

Qualifications

• Hands-on design, development and operation of an enterprise data platform on Databricks and AWS.
• Experience with Delta Lake, data modeling (3NF, star schemas) and scalable data pipelines.
• Ability to collaborate with cross-functional teams including Product, Project Management, Testing and DevOps.

Responsibilities

• Data Platform Engineering: design, develop, and maintain scalable data pipelines using Databricks (Spark / Delta Lake).
• Build robust ETL/ELT workflows leveraging PySpark and Databricks SQL.
• Implement and support medallion architecture (Bronze, Silver, Gold layers).
• Design and maintain efficient data models, including 3NF, star schema, and canonical models, as appropriate.
• Support and maintain Data Catalog and Data Governance frameworks to ensure data quality and compliance.
• Build and maintain CI/CD pipelines to enable reliable deployment across environments.
• Collaborate with external partners for development activities and ongoing production support.

Skills

Databricks

PySpark

AWS

Data Modeling

CI/CD

Tools

Delta Lake

Spark

Job description

Life changing therapies. Global impact. Bridge to thousands of biopharma companies and their patients. We are PCI. Our investment is in People who make an impact, drive progress and create a better tomorrow. Our strategy includes building teams across our global network to pioneer and shape the future of PCI.

Summary

The Senior Data Engineer (Databricks Platform) is a senior individual contributor responsible for the hands-on design, development, optimization, and operational support of the enterprise data platform built on Databricks and AWS technologies. This role ensures scalable, secure, and high-performance data pipelines, models, and integrations that power analytics, reporting, and advanced AI/ML use cases across the organization. The role brings deep expertise in distributed data processing, Delta Lake architecture, data modeling, ETL/ELT frameworks, and cloud environments (AWS). This role focuses on execution excellence, platform reliability, and technical problem resolution, while collaborating closely with Data Platform Lead, Product, Project Management, Testing, Customer Success, and external development partners.

Responsibilities

• Data Platform Engineering Design, develop, and maintain scalable data pipelines using Databricks (Spark / Delta Lake).
• Build robust ETL/ELT workflows leveraging PySpark and Databricks SQL.
• Implement and support medallion architecture (Bronze, Silver, Gold layers).
• Design and maintain efficient data models, including 3NF, star schema, and canonical models, as appropriate.
• Support and maintain Data Catalog and Data Governance frameworks to ensure data quality and compliance.
• Build and maintain CI/CD pipelines to enable reliable deployment across environments.
• Collaborate with external partners for development activities and ongoing production support.

Cloud & AWS Environment Support

• Demonstrate hands-on experience with AWS Glue, S3, and Lambda.
• Provide operational support for AWS-hosted infrastructure, including application services, data services, and system integrations.
• Monitor cloud environments for availability, performance, security, and cost efficiency; elevate risks and issues to the Technical Lead when required.
• Support deployment activities and ensure environment readiness in collaboration with DevOps and technical stakeholders.
• Contribute to cloud operational best practices focused on scalability, resilience, security, and incident response.

Testing Support

Partner with Testing and QA teams to support User Acceptance Testing (UAT) and validation activities by:

• Reviewing test cases for technical accuracy and risk coverage
• Triaging defects identified during testing cycles
• Ensuring test environment readiness and stability
• Provide technical input during release readiness discussions and risk evaluations.

Cross-Functional Collaboration

Collaborate closely with Product Managers, Project Managers, QA, DevOps, and external development partners to ensure successful solution delivery and ongoing platform stability. Translate business and operational requirements into scalable technical solutions aligned with approved architecture and enterprise standards. Support secure and reliable integration with internal enterprise systems and data sources.

Compliance & Operational Expectations

• Ensure adherence to all applicable PCI, cGMP, GCP, and regulatory policies.
• Participate in occasional overtime and/or weekend work as required to support critical releases or production needs.
• Maintain consistent attendance and reliable availability as essential functions of the role.
• Perform additional duties as assigned by the Data Platform Technical Lead or management.

Join us and be part of building the bridge between life changing therapies and patients. Let’s talk future

Equal Employment Opportunity (EEO) Statement

PCI Pharma Services is an Equal Opportunity/Affirmative Action Employer. We do not unlawfully discriminate on the basis of race, color, religion, age, sex, creed, national origin, ancestry, citizenship status, marital or domestic or civil union status, familial status, affectional or sexual orientation, gender identity or expression, genetics, disability, military eligibility or veteran status, or any other protected status. At PCI, Equity and Inclusion are at the core of our company’s purpose: Together, delivering life-changing therapies. We are committed to cultivating an inclusive workplace by holding ourselves accountable to the highest standards of understanding, fairness, respect, and equal opportunity – at every level. We envision a PCI community where everyone can belong and grow, and we strive to bring this vision to reality by continuously and intentionally assessing our people practices, policies and programs, marketing approach, and workplace culture.

Why work for PCI Pharma Services?

At PCI, we have an uncompromising focus on providing quality and operational excellence and providing the industry leading customer experience. Our people make all of this happen, so providing an industry leading experience for our people is equally as important. By creating an authentic culture of purposeful work, we aspire to be an interesting and fulfilling place for talented individuals to grow careers. We live a philosophy of intentional learning combined with real-life experience supported by a fair and competitive rewards program. We are individuals, teams and a company that believes in our purpose and our approach is simple, the people who work at PCI fuel our business; we don’t say no, we figure out how.