Scope:

Capacity is required to complete various backlog items, and enhancements to the Quality Data Product, and Applications using it. The following bullet points below are in scope for the delivery and execution of backlog items.

• Build data integration and transformations using AWS Glue, leveraging existing frameworks where possible
• Implement mechanism to configure user defined metadata to adjust business defined capabilities within the application
• Design decisions will be made for how many user-defined inputs will be feasible in the application.
• Airflow orchestration of data refresh loads
• Support in producing documentation in line with Merck standards:some text
  • Creation of design artifacts
  • Creation of IQ for deployments
  • Creation and/or input into the creation of SOPs
  • Visualization in Qlik Sense:
  • Provide reporting on data lineage and KPI calculation definitions
  • Leverage Qlik Sense deployment automation
  • Provide support to Business Change Management activities and creation or edits to company training materials
  • If the Merck Qlik Sense environments undergo a planned upgrade, SDG will provide
  • Assistance to facilitate testing and possible remediation.

Tech stack: 

• SQL, GIT HUB, Jenkins (legacy: SPARK SQL)
• New archit.: DBT, data modelling
• QLIK

‍