Job Details

NAVA Software solutions is looking for a Data Architect

Details:

Data Architect Data Warehouse ODI and OIC

Location: 100% Remote

Duration: 6-12 months

Mandatory:

• Strong understanding of Pharma datasources such as Symphony and Veeva OpenData.
• Industry experience (Pharma/Biotech) is a MUST.

Job Function:
The Data Architect is a role for a BioPharma client building a Data Warehouse. The Data Architect will be responsible for designing and writing ETL solutions using Oracle's Data Integrator (ODI) and Oracle Integration Cloud (OIC) software tools (and related technologies) for Life Sciences (Pharmaceutical, Biotech, Medical Device) clients. They will be leading ETL developers to create and test ETL and Integration code.

Primary Responsibilities:

• Design overall Data Warehouse data model and ETL solution.
• Partner with client Commercial Sales and Marketing, Market Access, Commercial Operations, and other stakeholders to design and build ETL workflows.
• Create source to target mappings for simple to complex data integration tasks.
• Integrate enterprise applications such as Veeva CRM and Oracle ERP with other enterprise applications and data feeds.
• Document Technical Requirements based on Data Requirements
• Provide estimates and timelines to deliver functionality based on Data Requirements
• Provide updates and status reports to the Project Manager around progress and any issues or blockers
• Provide advice and guidance on functionality and implementation strategy for Oracle ODI/OIC
• Lead ETL developers to ensure they are developing code according to design and team standards. Reviews all code created by ETL developers.

Qualifications:

Apart from Technical skills, Industry experience (Pharma/Biotech) is a MUST.

• Strong knowledge of Oracle Data Integrator for batch application development within a Data Warehouse environment.
• Experience modeling a data warehouse solution for staging, enterprise data warehouse and DataMart schemas.
• Strong understanding of Pharma data sources such as Symphony and Veeva OpenData.
• Significant experience with Oracle Integration Cloud for building data connections between various applications in the client's environment, especially Veeva CRM and Oracle Fusion ERP.
• ODI and OIC configuration and setup experience
• Strong understanding of data warehousing and source to target mapping concepts
• Minimum of 5 years' experience working with ODI, OIC and Data Warehouses
• Experience working with a Pharmaceutical, Biotech or Medical Device organization.
• Experience working in an agile delivery environment.
• Ability to handle multiple priorities and work under pressure.
• Good functional knowledge of Life Sciences commercialization processes.
• Experience leading ETL developers.
• Experience with building ETL frameworks for auditing and logging job progress and completion.
• Familiarity with the following is a big plus:
• Experience with Commercial Data (KOL, HCP, HCO, Prescription, Sales Territories etc)