Data/Solution Architect - Life Sciences/Pharmaceuticals Domain

Job Description:

Analyzing existing data sources:

- Expert understanding of data models and various 1 to many, many to many and other patterns, normalization and denormalization patterns and purposes.

- Expert understanding of Star/Dimensional, Snowflake modelling techniques.

- Advanced SQL skills - Data Partitioning, Stored Procedures/Macros, Recursive SQLs.

- Extensive Experience in working across Mutiple DBs, mainly Oracle/Databricks both on-premise and cloud based.

Extensive Experience in ETL concepts:

- Profile data sources to reverse engineer data model and relationships between tables, identify key fields, and infer meaning of attributes.

- Meet with system owners to tie observations of data patterns with business processes and use cases that lead to those patterns.

- Conduct root cause analysis (RCA) to identify underlying issues and drive effective solutions.

- Perform frequency distribution analysis to identify patterns and trends in the data.

Architecting data strategy for Future State:

- Profile the data sources to identify anomalies, inconsistencies, and data quality issues.

- Take ownership of the data, ensuring accuracy, completeness, and reliability.

- Develop target data model that provides optimal long term functional opportunities.

- Design the right change data capture, audit strategy.

- Identify where reference tables are necessary.

- Design mapping tables / helper tables to support configurable ETL.