This website uses cookies to ensure you get the best experience. Learn more

Data Engineer ; AES

Accelerated Enrollment Solutions (AES) is a business unit of PPD that offers both sponsors and contract research organizations best-in-class clinical trial research site and patient enrollment solutions, with tiered offerings combining the expertise, as needed, of industry leaders PPD, Synexus, Acurian and Optimal Research.

Summarized Purpose

Provides systemsanalysis, design, development, testing and support for moderately complextechnical information system components.

Essential Functions

• Designs and developscomponents and services according to specifications within a team environment.

• Prepares detailedsystem documentation including requirements, specifications, test plans anduser manuals.

• Performs unit andsystem tests and, as needed, validation testing.

• Assists DBA withdatabase design.

• Strong SQL andAnalytical skills to pull data from Snowflake/Oracle/SQL Server and performusage analysis and/or data profiling.

• Understanding of datawarehousing and data modelling principles

• Experience in understandingboth logical and physical data models

• Coordinates withOperations staff on deployment of applications.

• Works with businesspartners to analyze and address support requests including training.

• Provides support forexisting systems and technologies, including second line application supportduring and after deployment.

• Ensures all activitiesare performed with quality and compliance.

• Design andimplementation of ETL batches that meet the SLAs for the business' BusinessIntelligence reporting.

• Development of datacollection, data staging, data movement, data quality and archiving strategies.

• Plan and conduct ETLUnit and development tests, monitoring results and taking corrective actionwhen necessary.

• Design automationprocesses to control data access, transformation and movement and ensuressource system data availability

Job Qualification:


Education and Experience:
  • Bachelor's degree or equivalent and relevant formal academic / vocational qualification
  • Previous experience that provides the knowledge, skills, and abilities to perform the job (comparable to 3+ years') or equivalent combination of education, training, and experience

Knowledge, Skills and Abilities

• Experienced in the use of the ETL tools (Talend/Informatica) and Cloud based database tools (Snowflake/Redshift/Google Cloud)
• Client focused approach with strong interpersonal skills
• Must be able to multitask and pay close attention to detail
• Solid knowledge of basic relational database platforms (Snowflake, Oracle, SQL Server) and languages (PL/SQL, SQL)
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Strong logic, analysis, and problem-solving skills
• A good understanding of the concepts and best practices of data warehouse ETL design.
• Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively
• Have designed and developed ETL work packages on at least one data warehouse project.
• Expertise with big data tools: Hadoop, Spark, Kafka, etc. is a plus
• Expertise on any of the programming languages: Python or Scala
• Experience in building and optimizing 'big data' data pipelines, architectures and data sets.
• Experience with AWS cloud services: Snowflake, Redshift, S3, EC2, EMR

Diversity Statement

PPD is proud to be an affirmative action employer that values diversity as a strength and fosters an environment of mutual respect. PPD is committed to providing equal employment opportunities without regard to age, race, color, pregnancy, national origin, religion, sex, gender identity, sexual orientation, disability, veteran status or status within any other protected group.

Apply Now

Share this