Senior Azure Cloud Data Specialist

We are looking for experienced Azure Cloud Data Specialist for Product Program Management tooling area.

Job Description
Tasks:
1. PPM Pipeline performance improvement Report Authorization, FB_allocation and other pipelines
-Identify problematic queries which are more time consuming, work on improving query performance and data extraction time improvement.

2.Team Concept implementation on the tables and History data reading from the snapshot tables from snapshot table
- New logic implementation in allocation and capacity tables on data modelling to accept HR organization and team organization hierarchy
- DB objects restructuring which are depended on these model changes like adding more columns and index rebuilding

3. Historical snapshot table creations and making the view available for Allocation and Capacity
- FB table snapshot logic implementation and history table and view creation for excel exports

4. Operation Organization tables extension to n-6 layer to get more squad groups
- Update ADF copy query with the n-6 level, changes in dependent table structure and views

Study items:
1. User data anonymization and data deletion: User personal data which is older than 2 years need to be anonymize and project data which is older than 10 years need to be deleted.

2. Impact of HR tooling renewal program on present architecture: All single HR tools in the company will be replaced by a new unique solution. Special focus should be on existing interfaces, which harvest HR data for PPM needs and if any help is required from Azure DB side in Architecture logic.

Skill Requirements
Azure Cloud Development * * * * * (mandatory)
Azure Data Factory * * * * * (mandatory)
SQL code development on Oracle and Microsoft SQL server * * * * * (mandatory)
Code Repositories like Visual Studio for SQL code development or Oracle SQL * * * * * (mandatory)
Azure DevOps * * * * * (mandatory)
Jira Data model * * * (important)
HP/Microfocus PPM Data model * * * (important)

Spoken Languages: English
Experience Level: Senior
Job Start Date: 16th Feb 2022
Job End Date: 31st Aug 2022
Work Location: Portugal: Lissabon, Finland: Tampere, Helsinki, Oulu, India: Bangalore, Poland: Wroclaw

Job itself can be done totally remotely, but the person needs to be able to visit some of these offices for practical reasons, like for example fetching the laptop and setting it up.

Required Allocation 100%
Remote Work yes