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