Data Engineer

Informatics Team Member

Informatics at Fortrea is a high profile, high impact team that focuses on creating innovative data-driven solutions to improve the speed, cost, and quality of drug development. As a market leader in central laboratory and pre-clinical services and top 5 provider of phase III clinical trial management services, Fortrea has assembled the most comprehensive investigator and clinical lab database in the pharmaceutical industry, spanning greater than 11,000 protocols, greater than 600 indications, greater than 175,000 unique investigators, and greater than 14 million patient visits over the past 10 years. The role of the informatics team is to lead breakthrough innovations that will unlock the power of this data to help pharmaceutical and biotechnology companies bring the miracles of medicine to the people in need faster and more efficiently. As a key member of the Informatics team, you will be responsible for defining the architecture of data flows between information sources, operational databases, data warehouses and other large information stores using modern ETL and master data management technologies. Working in a highly collaborative environment, you will develop innovative and efficient solutions to enable integration of data into scalable and maintainable repositories to enable instantaneous, secure, and intuitive access by Fortrea's global network of employees, partners, and clients. Key areas of focus include: 1) the integration of preclinical, clinical, health outcomes, and social networking data to improve protocol design, clinical site selection, and patient enrollment 2) the design of real-time repositories drawn from multiple operational systems to enhance the efficiency and quality of clinical monitoring; 3) the development of enterprise-wide repositories to integrate operational and scientific data from multiple businesses to support ongoing processes and ad hoc data exploration; and 4) collaboration with application developers and analysts to develop strategies for creating, maintaining and delivering best-in-class analytic solutions. We seek smart, focused, passionate self-starters who bring energy, new ideas and practical experience to a fast-paced and dynamic team, are obsessed with delivering useful and elegant solutions, and care deeply about their customers and each other.

Summary of Responsibilities:

• Contribute to architectural vision for Fortrea's data architecture, data integration and master data management strategies.
• Design and implement core ETL workflows for Fortrea's information integration and reporting infrastructure.
• Participate in the design and development of high-performing, scalable and maintainable data repositories for analytic purposes.
• Participate in the full development cycle from product inception, research and prototyping to release in production.
• Measurably impact company performance by delivering high quality, scalable data products.
• Supervise external resources.
• All other duties as needed or assigned.

Qualifications (Minimum Required):

• BS/MS in computer science, information systems, life sciences, or similar.
• Fortrea may consider relevant and equivalent experience in lieu of educational requirements.
• Competencies:
• Required: (Core Competencies)
• A passion for innovating with data sciences at scale; applying modern technologies to large data sets and creating measurable business value.
• Obsessive attention to detail, passion for the end-user experience.
• General problem-solving skills, versatility.
• Collaborative mindset, team spirit.

Experience (Minimum Required):

• Required:
• 4+ years of designing ETL processes, designing data transfer and synchronization schemes, and implementing complex ETL workflows.
• Solid understanding of operational and dimensional database models, including logical and physical design using SQL Server, Oracle, or similar.
• Experience delivering data to staging environments, data warehouses and data marts.
• Experience with master data management approaches, tools, and design patterns.
• Proficiency in database programming using T-SQL, PL/SQL, or similar.
• Proficiency in query performance tuning.
• Proven ability to take ownership and lead a project with minimal supervision.
• Excellent interpersonal and communication skills, with strong written and verbal presentation.
• Preferred:
• Experience in pharmaceutical R and D, clinical development and/or healthcare IT, and working knowledge of standard medical terminologies, coding systems and data standards.
• Familiarity with NoSQL databases, including Solr, MongoDB, CouchDB, or similar.
• Familiarity with Hadoop or other distributed data stores and NoSQL databases.
• Familiarity with semantic web, OWL, RDF.
• Programming skills in C#.

Preferred Qualifications Include:

• Minimum Required:
• BS/MS in computer science, information systems, life sciences, or similar.
• Competencies:
• Required: (Core Competencies)
• A passion for innovating with data sciences at scale; applying modern technologies to large data sets and creating measurable business value.
• Obsessive attention to detail, passion for the end-user experience.
• General problem-solving skills, versatility.
• Collaborative mindset, team spirit.

Physical Demands/Work Environment:

• Occasional travel required.
• Occasional weekend and evening hours required.
• Travel Requirements: Yes Identify the expected travel requirements of the position: 10% of time 50% of the above that requires overnight stay Travel is primarily to where: Fortrea and client sites