For one of our Düsseldorf-based clients we’re looking for a freelance Azure ETL Developer (w/m/d)


Project description:
The project has the purpose to provide reporting on daily logistics, purchasing and production information based upon several SAP modules and manual flat file data for the business units and Functions worldwide.
 
Tasks:
The contractor will work on the subcomponent “Purchasing” which will serve the purpose to extract and transform data from SAP Purchasing Module and load it to reporting into PowerBI datasets.
 

• Functional and technical consulting of business analysis and facilitate documentation of business requirements that will be validated and approved by the client.
• Independently implement the needed business functions (as described in the task above) in the application’s business core layer including the related deployment activities.
• Implement the required functionality (according to the above-mentioned business requirements) in Supply Chain BI data model and PowerBI dashboards.
• Establish and align data quality KPIs for the subcomponents (features) as mentioned above according to the business requirements (mentioned above)
• Perform functional unit testing; in case of business requirements (mentioned above) are not working, fix to be applied, starting at point 1 again.
• Conduct guiding of user testing (business acceptance testing), referring documentation mentioned below, by introducing the new subcomponents. (business acceptance testing)
• Functional consulting of documentation of business logics and procedures that will be validated and approved by the client.
• Handover of implementation to internal and external maintenance organizations according to above mentioned documentation.

 
Used tool stack:

• Azure Cloud services (Azure Synapse, Azure BLOB, Azure Databricks, Azure Data Factory, Azure Data Lake),
• Azure Dev Ops
• Microsoft Power BI

 
Used coding:

• SQL (Modelling techniques: Dimensional, Snowflake is a must, Data Vault preferred),
• Python preferred,
• C# preferred

 
 
Project start: ASAP
Project duration: 12+ months
Project language: English (must), German (nice-to-have)
Project location: 100% remote (40 hrs./week)