Dans le cadre d'un programme international de transformation autour de la mise en place d'une solution Integrated Business Planning (Kinaxis Maestro), notre client recherche un IT Data & Integration Manager afin de renforcer l'équipe Data & Integration. Le consultant interviendra à la fois sur : le support de la phase Demand Planning, déjà en production ; la mise en œuvre des interfaces nécessaires au déploiement de la phase Supply Planning. Il évoluera dans un environnement international, en forte interaction avec les équipes Métier, IT, Data, SAP et l'intégrateur en charge de Kinaxis Maestro. Vos missions : En tant qu'IT Data & Integration Manager, vous serez responsable de la coordination et du suivi des flux de données entre les systèmes d'information de l'entreprise et Kinaxis Maestro. À ce titre, vous serez amené à : Assurer le support fonctionnel de la phase Demand Planning déjà en production (analyse des tickets, suivi des anomalies et coordination des corrections). Concevoir et spécifier les nouveaux flux de données entre GCP, SAP et Kinaxis Maestro. Faire le lien entre les équipes Métier, IT, Data & Integration et l'intégrateur. Rédiger les spécifications fonctionnelles des interfaces. Produire les jeux de données et fichiers de référence nécessaires aux phases de validation. Rédiger des requêtes SQL sur les objets GCP / BigQuery afin d'extraire les données nécessaires aux équipes projet. Participer aux campagnes de tests fonctionnels et accompagner les équipes métiers lors des recettes. Participer à la définition des règles de transformation et de conversion des données. Contribuer à l'automatisation des interfaces. Participer au Go-Live et accompagner la stabilisation de la solution. Mettre en place et améliorer le monitoring des interfaces. Produire et maintenir la documentation fonctionnelle et technique (schémas d'architecture, mappings, règles de gestion, documentation RUN).
ContexteDans le cadre d'un besoin sur le périmètre Middleware, BI & Database / Cloud, Integration & BI, recherche d'un Ingénieur Middleware & MFT niveau L3, avec une expertise autour des solutions de transfert de fichiers CFT et B2BI. Niveau : SL1 Lot : Lot 2 – MIDDLEWARE & BI & DATABASE Domaine : Cloud, Integration & BI Certification : Non requise Missions principalesAdministrer et maintenir les plateformes MFT / Middleware. Assurer l'expertise technique niveau L3 sur les environnements CFT et B2BI. Configurer et maintenir les flux de transferts de fichiers. Analyser et résoudre les incidents complexes liés aux échanges de fichiers. Assurer le maintien en conditions opérationnelles des plateformes. Participer aux évolutions, installations, migrations et montées de version. Optimiser et sécuriser les échanges de données. Mettre en œuvre des procédures d'automatisation et d'exploitation. Assurer le support technique auprès des équipes de production. Produire et maintenir la documentation technique. Compétences prioritaires CFT / Transfer CFT B2BI MFT – Managed File Transfer Middleware Transferts de fichiers / échanges de flux Administration et production Support L3 Compétences complémentaires intéressantes : Linux / Unix Shell / scripting SFTP / FTP / FTPS Sécurisation des flux Protocoles réseau Automatisation Troubleshooting Gestion d'incidents / ITIL
SQL Server Database Engineer with SSIS Our Client is bank based in Central London – who are looking to recruit Database Engineer with at least 5 to 7 years sold expertise of working SQL Server SSIS and SSRS. Responsible for the development and delivery of pipelines (collect, validate and prepare high quality data) to automate and streamline processes required by different departments. Support existing SSIS ETLs (overnight and intraday), proactively fine-tune and enhance existing codes to increase robustness and error monitoring. Support the internal IT department with changes and upgrades to software platforms. Convert legacy Hyperion reports to SSRS. Software Development: Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation end of day cycle. Understanding business requirements in order to develop and deliver appropriate solutions based on system definition documents. Proficiency in advanced 4GL programming languages and able to apply to the fully development life-cycle. Database Support To build data pipelines within the SQL environment in SSIS packages, where required, introduce new field and data types for new information to be collated in the CORE environment. To build tabular models (SSAS) for different business units. To build reports based on business requirements using SQL SSRS. To integrate with all the Bank's sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net. Ensure that the environment is running optimally and with high standard house-keeping procedures. Sharepoint Integration: To integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry. To utilise web services to integrate from cutting edge technology into legacy systems such as Equation. End of Day Cycle: To provide second and third level support for in-house programmes during the end of day cycle. To be able to analyse and rectify any problems raised in an independent and team scenario. To take ownership of a problem and deliver a solution in a timely manner. Provide out of office hours support. Risk & Regulatory Duties Maintain knowledge of all applicable regulatory requirements including the Bank's Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk. Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies. Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department. Training & Competence Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines. Proactively seek to complete recommended technical and behavioural competencies training required for your role. Act in accordance with the FCA/PRA Code of Conduct. Fulfil all prescribed business continuity requirements as set out in the organisational or departmental specific plans or as instructed by the Line Manager/Head of Department. Qualifications/Experience Degree level qualified or equivalent. MS SQL stack (SSIS, SSAS, SSRS) to high level of proficiency - Essential C# Programming / JavaScript programming - Desirable Knowledge and Skills Software analysis and design good practice Dimensional modelling, Entity Relationship modelling, Normalised modelling. Data warehouse design concepts, (Inmon, Kimball) The position is based in Central and you will be required to be in the office for 3 days a week. Please note the Client does NOT provide sponsorship. The salary for this position is in the range £60K – £75K. Please do send your CV to us in Word format along with your salary and availability.
