Find your next tech and IT Job or contract Data Warehouse

Contexte : Dans le cadre d'un programme stratégique de transformation des SI Achats, notre client recherche un Consultant Senior Data Migration pour piloter la migration des données vers une nouvelle plateforme Procure-to-Pay (P2P). Le consultant interviendra sur la conception fonctionnelle de la migration, la modélisation des données, la gouvernance, la qualité des données ainsi que la coordination entre les équipes métiers et techniques. Missions : · Concevoir les modèles de données cibles et les matrices de mapping (Source-to-Target Mapping). · Définir les règles de gestion, de transformation, d'historisation et de traçabilité des données. · Construire et maintenir le dictionnaire de données et le Data Lineage. · Piloter les différentes phases de migration (préparation, paramétrage, tests, validation et mise en production). · Garantir la qualité, la conformité et la gouvernance des données migrées. · Animer les ateliers avec les équipes Achats, Finance et Data. · Assurer l'interface entre les équipes métiers, Data et développement. · Valider la conformité fonctionnelle des développements. · Concevoir les modèles décisionnels et contribuer aux reportings Power BI. · Définir les indicateurs métiers et assurer la cohérence des données analytiques. Compétences requises : · Migration de données. · Modélisation de données. · SQL. · Data Warehouse. · Source-to-Target Mapping. · Data Lineage. · Gouvernance et qualité des données. · Procure-to-Pay (P2P). · Power BI. · Animation d'ateliers métiers. · Rédaction de spécifications fonctionnelles. Environnement technique : · SQL · Microsoft Fabric · Azure Data Factory · Power BI · Python · Data Warehouse · Self-Service BI

Database Engineer with SQL Server Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. 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. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language. Data warehouse design concepts, (Inmon or Kimball) The Client is a Bank based in the City of London. This is a 2 year FTC position with a salary of circa £65K - £70K. Do send your CV to us in Word format along with your salary and availability.

Data Engineer with C# Dot Net asp.net with SQL Server SSIS SSRS Our Client is a bank based in Central London who are looking to recruit at least 7 years plus experience as a Data Engineer with the ability to work with C# Dot net and SQL Server with SSIS. You must have solid expertise of at least 7 years experience of working with and developing software with C# Dot Net and MS SQL Server and SSIS, SSRS and SSAS – SSIS is very important for this position. Must be an excellent problem solver and adept writing documentation for all projects. You ideally have worked on banking systems particularly Core Banking. Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation, Kondor, Eximbills, end of day cycle. Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Build data flows within the SQL environment in SSIS and SSAS packages. Integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry. Utilise web services to integrate from cutting edge technology into legacy systems such as Equation. Integrate with all the systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net. 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. Must Have Skills Software analysis and design. SQL Server query language with SSIS. Data warehouse design concepts, (Inmon or Kimball) Experience of developing software with C# Dot Net and asp.net and SQL Server is a must. Must have solid experience of working with SSIS and building data warehouses. The Client is a Bank based in the Central London. Must have a degree qualification. This is a 12 month FTC position with a salary of circa £55K - £70K. This is a hybrid position - you will be required to be in the office at least 3 days week. Do send your CV to us in Word format along with your salary and availability.

Software Developer with C# Dot Net asp.net with SQL Server SSIS SSRS Our Client is a bank based in Central London who are looking to recruit at least 7 years plus experience as a Data Engineer with the ability to work with C# Dot net and SQL Server with SSIS. You must have solid expertise of at least 7 years' experience of working with and developing software with C# Dot Net and MS SQL Server and SSIS, SSRS and SSAS – SSIS is very important for this position. Must be an excellent problem solver and adept writing documentation for all projects. You ideally have worked on banking systems particularly Core Banking. Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation, Kondor, Eximbills, end of day cycle. Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Build data flows within the SQL environment in SSIS and SSAS packages. Integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry. Utilise web services to integrate from cutting edge technology into legacy systems such as Equation. Integrate with all the systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net. 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. Must Have Skills Software analysis and design. SQL Server query language with SSIS. Data warehouse design concepts, (Inmon or Kimball) Experience of developing software with C# Dot Net and asp.net and SQL Server is a must. Must have solid experience of working with SSIS and building data warehouses. The Client is a Bank based in the Central London. Must have a degree qualification. This is a 12 month FTC position with a salary of circa £60K - £70K. This is a hybrid position - you will be required to be in the office at least 3 days week. Do send your CV to us in Word format along with your salary and availability.

En tant qu'Architecte Data, vous concevez et faites évoluer les plateformes de données de l'entreprise. Vous définissez les architectures cibles, accompagnez les équipes techniques et garantissez des solutions performantes, sécurisées et évolutives répondant aux enjeux métiers. Vos missions : Concevoir des architectures Data modernes (Data Lake, Lakehouse, Data Warehouse, Data Mesh). Définir les stratégies d'ingestion, de transformation et de restitution des données (batch & streaming). Garantir la qualité, la sécurité, la performance et la gouvernance des plateformes. Définir les standards d'architecture, de CI/CD et d'observabilité. Optimiser les performances et les coûts des plateformes (FinOps). Accompagner les équipes Data et participer aux instances d'architecture dans un environnement Agile/SAFe.

Dans le cadre du renforcement d'une équipe Data, nous recherchons un Data Engineer Microsoft Fabric confirmé afin de participer à la conception, au développement et à l'industrialisation des traitements de données sur la plateforme Microsoft Fabric. Vous interviendrez sur l'ensemble de la chaîne de traitement des données, de l'ingestion à la mise à disposition, en garantissant la qualité, la performance et la fiabilité des pipelines. Vos missionsConcevoir, développer et maintenir des pipelines de données sous Microsoft Fabric. Développer les traitements de transformation de données en Python, PySpark et SQL. Concevoir et exploiter des architectures Lakehouse, Delta Lake et Data Warehouse. Paramétrer et configurer les différents composants de l'écosystème Microsoft Fabric. Garantir la qualité, la performance et la fiabilité des traitements de données. Automatiser les déploiements et contribuer à l'industrialisation des développements (CI/CD). Participer aux phases de tests, de recette et de mise en production. Assurer la maintenance évolutive et corrective des solutions Data. Collaborer avec les équipes Data, BI, Architecture et Métiers afin de répondre aux besoins fonctionnels et techniques. Participer à l'amélioration continue des bonnes pratiques de développement et de gouvernance des données.

Senior Data Analyst with SQL Server SSIS and Network Engineering Our Client a bank based in Central London is seeking a highly motivated Data Analyst to play a key role in building and maintaining a robust digital data infrastructure. This position supports data users across the business, ensuring high-quality data extraction, reporting, and analytics capabilities. Working closely with the IT Manager and various business units, you will help strengthen compliance and regulatory risk management through effective management information (MI) reporting and analytical insights. The Client would ideally like you to have experience of Network Engineering in addition to the Data Engineering skills. Must have at least 7 to 10 years solid Data Engineering experience and ideally 1 to 2 years Networking Engineering and Support experience. Ideally have the following skills LAN/WAN Administer, maintain, and optimize Windows and Linux server environments. · Manage VMware virtualized infrastructure (vSphere 8 and above). · Oversee enterprise backup and disaster recovery solutions using Veeam Backup & Replication. · Manage Veeam ONE monitoring and Veeam Recovery Orchestrator (VRO) environments. · Administer endpoint security and encryption solutions, including Symantec Endpoint Protection (SEP) and Symantec Endpoint Encryption (SEE). · Support endpoint DLP, SIEM, and security monitoring tools (e.g., Splunk, Tenable). · Manage patching processes using Manage Engine Patch Manager Plus. · Support Microsoft 365 services and related cloud technologies. The candidate must have strong technical expertise in Windows/Linux, VMware, Microsoft 365, networking, cybersecurity, and infrastructure management who also enjoys solving complex challenges and driving operational excellence Responsibilities Develop, maintain, and enhance the Branch's digital data infrastructure to ensure reliability and accessibility. Deliver accurate and timely data extraction, MI analysis, and reporting to support operational, compliance, and regulatory needs. Work collaboratively with IT and business departments to understand data requirements and provide analytical support. Explore, evaluate, and propose new technologies/tools to improve data management, governance, and reporting efficiency. Ensure data integrity and support the implementation of best practices in data governance. Assist in identifying and managing data-related risks, supporting the Branch's compliance and regulatory frameworks. Must have: Strong analytical skills with experience in data extraction, transformation, and reporting. Proficiency in SQL Server, data visualisation tools (e.g., Power BI, Tableau), and data management technologies. Understanding of data governance, regulatory reporting, and compliance requirements (banking/financial sector experience a plus). Excellent problem-solving skills and attention to detail. Ability to collaborate effectively with cross-functional teams and communicate complex information clearly. Coming from an IT support function is a bonus Data Analysis and Management  Maintain and develop SSIS packages  Perform ad-hoc data extraction and analytics based on requirements from business  Develop data visualization for business  Work with business to enhance the data available to the data warehouse  Assist in testing reporting solutions developed by external vendors  Support and maintain the generation of internal MI reports  Support and advise the business on data related matters and automation possibilities  Any other responsibilities / tasks as assigned by the Head of IT from time to time Business Performance  Support the department's operations as and when needed and any other tasks assigned by the business stakeholders.  Work with the Managers to ensure the business is in compliant with applicable rules and regulations that falls within the department's remit.  Work with the business to ensure timely submission of relevant department's reports  To adhere and follow all applicable Bank/Group policies and procedures. Data accuracy and ownership duties  To ensure all data worked on and or/shared with internal/external clients are accurate.  Escalate any data issues to the business promptly and without delays.  Ensuring any data sharing requests are discussed with business/DPO so that prior authorization is given and follows GDPR / department's SOPs. Regulatory Compliance duties Comply with all applicable individual conduct rules (especially the FCA Conduct Rules, Regulations, Bank policies and procedures and the banking Compliance. Technical/Functional skills - Knowledge in SQL query is essential - Working experience in administration and development with SQL (experience with SQL Server and SQL Server Integration Service is preferred) - Experience in working with data visualization tools such as Power BI - Experience in working with scripting language such as VBA and Python - Experience working with Power Automate is a plus - Required understanding of the business and business units Personal skills (Soft Competencies [Core/Leadership]) - Personal integrity and ethics - Good judgment in enabling the provision of sound advice on regulation and practice, proactive management of compliance and regulatory risk You will have at least 7 to 10 years' relevant experience working in the data field, preferably in an established bank or financial institution. Qualifications (Basic Degree/Diploma) Bachelor's Degree or Professional Qualification in the relevant discipline (Degrees in Statistics, Information Systems, or similar) This is an exciting position within a bank with interesting projects based in Central London. The salary for this position is in the range £60K- £75K. Please do send your CV to us in Word format along with you salary and availability.

Nous recherchons un Développeur DataStage Senior capable de prendre en charge des projets d'intégration de données de bout en bout. Au-delà de l'expertise technique, le consultant devra être autonome, force de proposition et capable d'interagir directement avec les équipes métiers afin de recueillir les besoins, proposer des solutions et piloter les travaux jusqu'à leur mise en production. MissionsRecueillir et analyser les besoins métiers. Participer au cadrage et à la définition des solutions d'intégration de données. Concevoir l'architecture technique et les flux DataStage. Développer, tester et déployer les traitements ETL. Assurer la qualité des données et la performance des traitements. Piloter les différentes phases du projet : conception, réalisation, recette, mise en production. Animer les échanges avec les équipes métiers et techniques. Assurer la documentation, le transfert de compétences et le support post-déploiement. Être garant des bonnes pratiques de développement et d'exploitation. Compétences requisesTechniquesIBM DataStage (expert). Développement ETL complexe. SQL avancé. Modélisation de données. Optimisation des performances. Environnements décisionnels et Data Warehouse. Maîtrise du cycle de vie projet. FonctionnellesRecueil et formalisation des besoins métiers. Animation d'ateliers. Rédaction de spécifications fonctionnelles et techniques. Accompagnement des utilisateurs. Profil recherchéMinimum 5 ans d'expérience sur DataStage. Développeur senior confirmé avec forte autonomie. Expérience de gestion de projet en mode projet de A à Z. Capacité à intervenir en direct avec les métiers. Très bon relationnel et sens du service. Force de proposition. Capacité à prendre des décisions et à faire avancer les sujets sans supervision constante.

Application Support Analyst Our Client is looking to recruit an Application Support Analyst with at least 3 to 5 years 1 and 2 Line Support experience. Reporting to the Service Delivery Manager, the Application Support Analyst has primary responsibility for providing day to day operational support for the Application Portfolio, through the effective use and management of incident, requests and problems. ou will be responsible for the regular monitoring and maintenance of the application portfolio. You will be responsible for the change management process, ensuring that the all changes are managed in accordance with the appropriate policies and that they have an appropriate roll-back plan and are scheduled in conjunction with the SSC and 3 party suppliers as appropriate. Responsibilities Provide 2 and 3 line support for the application portfolio Monitor application systems, identifying performance trends and taking action when necessary to stop problems arising Liaise with 3 party suppliers, ensuring issues are escalated and dealt with as necessary and to SLA Own application/system documentation and the data repository that holds that information (i.e. SharePoint) Provide technical support to the application architect and project services as required for project deliverables Provide test support for new and enhanced systems/applications Responsible for Change Management process, ensuring that changes are managed, roll-back plans are in place and that they are appropriately scheduled and approved by CAB, liaising with Change Manager Owns Configuration Management process Responsible for scheduled maintenance and capacity planning Ensure that security, compliance and legislation is considered in all aspects of the role and associated processes Responsible for the development and maintenance of the data warehouse Run reports and conduct analysis in-line with Business/Management requirements Responsible for the provision of performance information, ensuring timely, accurate reports are provided to the necessary parties Work with the Application Architect and Project Services to ensure that data/information analysis and reporting is considered in the development of new and enhanced systems design to ensure consideration is given to the linking, matching and cleansing of data across systems. Experience Proven experience working in 2/3line support role Experience of working with ITIL processes within an organisation, in particular, incident, request, change and problem Management Experience working in a customer facing technical role Proven experience working with and managing 3 party suppliers Experience managing assets, both hardware and software The Client has offices in Peteborough. Salary for this role is £35K - £40K + Benefits. Please do send your CV to us in Word format along with your salary and availability

Votre mission Au sein de l'équipe Data, vous contribuez à la construction et à l'évolution de la plateforme de données qui alimente les projets d'analyse avancée, d'intelligence artificielle et de pilotage des activités de notre client. Vous garantissez la disponibilité, la fiabilité et la qualité des données utilisées par les métiers et les équipes Data. Principales responsabilités Concevoir et maintenir des pipelines de données robustes et performants Mettre en œuvre les processus d'ingestion de données provenant de multiples sources Garantir la qualité, la cohérence et la traçabilité des données Administrer et optimiser les Data Lakes et Data Warehouses Automatiser les traitements et assurer leur monitoring Collaborer avec les Data Scientists et les équipes métiers Participer aux projets de migration et d'optimisation Cloud Veiller au respect des règles de sécurité, conformité et gouvernance des données

Véritable référent technique, vous participerez aux choix d'architecture et piloterez les développements Data afin de construire une plateforme robuste, évolutive et pérenne. Vos missions Au sein des équipes Data, en collaboration étroite avec les équipes Infrastructure et les métiers, vous serez chargé de : Définir, concevoir et faire évoluer l'architecture Data (ingestion, stockage, modélisation et exposition des données). Piloter les activités de Data Engineering et garantir l'application des bonnes pratiques de développement. Encadrer, accompagner et faire monter en compétence les équipes de développement internes et externes. Arbitrer les choix techniques et assurer la cohérence globale de l'écosystème Data. Garantir la qualité, la performance, la maintenabilité et la scalabilité des solutions déployées. Structurer la documentation technique et contribuer à l'industrialisation des développements. Participer à l'amélioration continue des méthodes de travail et des processus Agile. Collaborer avec les différentes parties prenantes afin d'aligner les solutions techniques sur les besoins métiers. Environnement technique Technologies et outils Python SQL ETL / ELT Orchestration de pipelines de données Data Lake Data Warehouse Environnements Cloud DevOps et CI/CD Méthodologies Agile

Basée à Lille, Lyon, Nantes, Grenoble, Marseille, Paris et Bruxelles, Insitoo Freelances est une société du groupe Insitoo, spécialisée dans le placement et le sourcing des Freelances IT et Métier. Depuis 2007, Insitoo Freelances a su s'imposer comme une référence en matière de freelancing par son expertise dans l'IT et ses valeurs de transparence et de proximité. Actuellement, afin de répondre aux besoins de nos clients, nous recherchons un Business Analyst Data H/F à Lille, France. Contexte : Dans le cadre du développement stratégique de ses activités décisionnelles et du renforcement temporaire de sa Direction Data, l'entreprise souhaite accompagner la montée en charge de ses projets data. L'enjeu principal réside dans l'optimisation de la chaîne de valeur de la donnée : de la capture des besoins métiers jusqu'à la mise à disposition d'indicateurs clés et de plateformes décisionnelles performantes. Les missions attendues par le Business Analyst Data H/F : -Recueillir, analyser et formaliser les besoins métiers liés à la donnée, notamment au travers d'ateliers avec les parties prenantes. - Rédiger les spécifications fonctionnelles nécessaires à l'alimentation des plateformes décisionnelles (Data Warehouse, Data Mart, etc.) et définir les indicateurs à mettre à disposition des utilisateurs. - Concevoir les stratégies et cahiers de recette, puis piloter et exécuter les phases de tests fonctionnels. - Documenter et maintenir la méta donnée. - Assurer la traduction et la transmission des besoins métiers auprès de l'équipe technique Data (Data Engineers, Data Analysts, Data Scientists, Architectes Data, etc.). - Accompagner les utilisateurs dans l'appropriation des solutions data en vulgarisant les concepts techniques et en produisant les supports associés (formations, guides utilisateurs, documentation fonctionnelle, etc.). Profil demandé : '- Titulaire d'un diplôme d'Ingénieur ou d'un Master spécialisé en Data, Business Intelligence ou Informatique décisionnelle. - Vous justifiez d'au moins 5 années d'expérience en tant que Business Analyst, idéalement dans un environnement Data ou décisionnel. - Vous maîtrisez les bases de données et le langage SQL, et êtes à l'aise avec la rédaction de livrables fonctionnels tels que les spécifications, les cahiers de recette et la documentation utilisateur. - Vous possédez de solides capacités d'analyse, de synthèse et de communication avec des interlocuteurs métiers et techniques. - Une connaissance du secteur de l'assurance et de Power BI constituerait un atout apprécié.

Application Support Analyst 2 and 3Line Our Client an international company a looking to recruit an Application Support Analyst with experience of 2 and 3 line support. The main responsibility for providing day to day operational support for the Clients Application Portfolio, through the effective use and management of incident, requests and problems. You will be responsible for the regular monitoring and maintenance of the application portfolio. In addition you will provide appropriate SharePoint expertise, in terms of support, content management and development of sites, services and functionality. Responsibilities Provide 2 and 3 line support for the Clients application portfolio Monitor application systems, identifying performance trends and taking action when necessary to stop problems arising Liaise with 3 party suppliers, ensuring issues are escalated and dealt with as necessary and to SLA Manage all system access requests Own application/system documentation and the data repository that holds that information (i.e. SharePoint) Provide technical support to the application architect and project services as required for project deliverables Ensure that pro-formas are completed and submitted and track delivery Provide test support for new and enhanced systems/applications Responsible for Change Management process, ensuring that changes are managed, roll-back plans are in place and that they are appropriately scheduled and approved Owns Configuration Management process Responsible for scheduled maintenance and capacity planning Ensure that security, compliance and legislation is considered in all aspects of the role and associated processes Responsible for the development and maintenance of the Clients data warehouse Run reports and conduct analysis in-line with Business/Management requirements Responsible for the provision of performance information, ensuring timely, accurate reports are provided to the necessary parties Work with the Application Architect and Project Services to ensure that data/information analysis and reporting is considered in the development of new and enhanced systems design to ensure consideration is given to the linking, matching and cleansing of data across systems. Experience Proven experience working in 1 and 2 line support role Experience of working with ITIL processes within an organisation, in particular, incident, request, change and problem Management Experience working in a customer facing technical role Proven experience working with and managing 3 party suppliers Experience managing assets, both hardware and software Knowledge and understanding of the application portfolio Excellent team working and interpersonal communication skills Exceptional oral and written communication skills Good team player and collaborative Ability to work on own initiative and with minimal supervision Technical background in application support and maintenance The position will be based in Peterborough. The salary for this role will be in the range £35K - £40K. Please do send your CV to us in Word format along with your notice period and availability.