The Data Engineer will work closely with clients and the eCS Biometrics team to optimize the elluminate® platform for end-to-end solutions to aggregate, transform, access and report on clinical data throughout the life cycle of a clinical trial. This includes study design in elluminate®, collaboration on specifications, and configuration of the various modules to including Data Central, Clinical Data Analytics and Trial Operational Analytics, Risk-Based Quality Management (RBQM), Statistical Computing Environment (SCE) and Operational Insights. The Data Engineer will be involved in standard ETL activities as well as programming custom listings, visualizations and analytics tools using Mapper and Qlik. The position involves a high level of quality control as well as adherence to standard operation procedures and work instructions and a constant drive towards automation and process improvement.
KEY TASKS & RESPONSIBILITIES
- Design, develop, test, and deploy highly efficient code for supporting SDTM, Custom reports and Visualizations using tools like MS SQL, elluminate® Mapper and Qlik
- Configure ETL processes to support of the aggregation and standardization of clinical data from various sources including EDC systems, SAS and central laboratory vendors
- Work with Analytics developers, other team members and clients to review the business requirements and translate them into database objects and visualizations
- Manage multiple timelines and deliverables (for single or multiple clients) and managing client communications as assigned
- Provide diagnostic support and fix defects as needed
- Ensure compliance with eClinical Solutions/industry quality standards, regulations, guidelines, and procedures
- Other duties as assigned
CANDIDATE’S PROFILE
Education & Experience
- 3+ years of professional experience preferred
- Bachelor's degree or equivalent experience preferred
- Experience with database/warehouse architecture, design and development preferred
- Knowledge of various data platforms and warehouses including SQL Server, DB2, Teradata, AWS, Azure, Snowflake, etc.
- Understanding of Cloud / Hybrid data architecture concepts is a plus
- Knowledge of clinical trial data is a plus - CDISC ODM, SDTM, or ADAM standards
- Experience in Pharmaceutical/Biotechnology/Life Science industry is a plus
Professional Skills
- Critical thinking, problem solving and strong initiative
- Communication and task management skills while working with technical and non-technical teams (both internal to eCS and clients)
- Must be team oriented with strong collaboration, prioritization, and adaptability skills
- Excellent knowledge of English; verbal and written communication skills with ability to interact with users and clients providing solutions
- Excited to learn new tools and product modules and adapt to changing technology and requirements
- Experience in the Life Sciences industry, CRO / Clinical Trial regulated environment preferred
Technical Skills
- Proficient in SQL, T-SQL, PL/SQL programing
- Experience in Microsoft Office Applications, specifically MS Project and MS Excel
- Familiarity with multiple Database Platforms: Oracle, SQL Server, Teradata, DB2 Oracle
- Familiarity with Data Reporting Tools: QlikSense, QlikView, Spotfire, Tableau, JReview, Business Objects, Cognos, MicroStrategy, IBM DataStage, Informatica, Spark or related
- Familiarity with other languages and concepts: .NET, C#, Python, R, Java, HTML, SSRS, AWS, Azure, Spark, REST APIs, Big Data, ETL, Data Pipelines, Data Modelling, Data Analytics, BI, Data Warehouse, Data Lake or related
