Data Engineer II

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