Solution Architect

Duration: 06 Months+

IDEA (Data Lake) consists of independent and dedicated data sets storing data for each data source like IMPACT, HELIX, IRT, RAVE and so on. IDM1 and IDM2 consolidate data from some of these sources and make it available for efficient querying, reporting and downstream consumption. The advent of large scale changes that new projects like CTMS, ACE, Iverick Bio integration, etc. will dictate, poses the need for a Solution and Data architect who can help with the following aspects of IDEA/IDM :

New ingestions: Solution and Data architects need to analyze the impact and ensure that IDEA is able to seamlessly accommodate any new ingestions that new projects will bring.

IDEA and IDM Designing: Projects like CTMS will require new data structures, data models, storage mechanisms to be created in IDEA to house Veeva CTMS data. This data needs to be taken further down to IDM layers to make it available reports/dashboards and downstream systems that require a consolidated data set from multiple sources like CTMS, Helix, CROs and so on.

Data Modeling: An Architect will create data models that define how data will be organized in IDEA and how to establish relationship between entities in IDM layers. Proper data modeling is essential for data integrity and efficient data retrieval.

Data Integration: At present, our operational data sources like HELIX, IRT, RAVE and downstream systems like Trifecta, CluePoints are integrated with IMPACT. CTMS Replacement project proposes a new landscape where these systems will decouple from IMPACT and integrate with IDEA.

Responsibilities:

An architect will need to work with system owners/SMEs to determine the feasibility of this design, the best way to integrate with IDEA, designing and implementing the data integration (ETL) processes while ensuring data quality and business continuity.

Performance Optimization: Currently, IDEA is facing challenges with ingesting high volumes of data. Data architect would be able to help with optimizing our processes, explore performance-enhancing features for efficient querying and reporting even when dealing with large volumes of data.

Data Governance: An architect dedicated to IDEA can help evolve IDEA, determine what is best for IDEA keeping M&D and Astellas' strategy and 3-year ambition plan /roadmap in mind.

Shift: Day