Must-Have:
• Involved in the design, build and integration of data from various sources and the management of the existing Data Ingestion solutions in SQL Server and Azure environments. fabric - mandatory
• Managing the delivery of multiple projects related to the Microsoft Distribution Data Ingestion (SSIS and Azure) on a day-to-day basis, within agreed constraints and the specified tolerances of scope, time, cost and quality.
• The candidate should also have experience in either moving data to Kraken or consuming data from Kraken.
Key responsibilities:
• fabric - mandatory
• Understanding business requirements relating to business data sources with the ability to integrate them and/ or transform them effectively in accordance with business needs.
• The customization and development of Extract, Transform and Load routines, modelling, queries, reports and analysis.
• The support of existing data marts, warehouse process chains and associated models and queries.
• Facilitating the follow up meetings and removing obstacles that affect the team.
• Ensuring the successful delivery of all assigned Data Engineering work on projects across all ESB business units and their successful deployment to production, including use cases developed by our Data Science & Analytics team.
• Implement changes (CR’s) or current developments relating to existing data warehouses.
• Tracking project status and managing the project teams to mitigate issues and risks.
• Troubleshooting and resolving issues with any of our SQL Server and Azure data repositories.