Bonjour à tous 😀 🚀Nous avons une nouvelle opportunité au sein de notre client. Nous recherchons un(e) Data Engineer BI confirmé(e) pour rejoindre son équipe data. L'objectif : consolider les données de l'entreprise à des fins analytiques et statistiques, sur des projets stratégiques comme les lancements de produits, la consolidation des données et le suivi d'activité. Tu travailleras en lien étroit avec les équipes métiers, dans un contexte agile. Vos missions : Challenger, cadrer, chiffrer et prioriser les besoins métiers Développer et optimiser des traitements ETL et SQL Explorer et analyser les données Industrialiser et déployer les flux de données Assurer le suivi du run et améliorer en continu la qualité des livrables Participer à des POC sur de nouvelles technologies Maintenir la documentation et présenter tes travaux à l'équipe Environnement technique : SSIS SQL Server / Transact-SQL IBM Cognos Analytics Tableau SSAS multidimensionnel Java (un plus)
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 £65K – £75K. Please do send your CV to us in Word format along with your salary and availability.
Notre client, un grand groupe industriel, recherche un Expert BDD SQL Server dans le cadre d'une mission de build axée sur le déploiement et la configuration de bases de données sur des environnements de serveurs virtuels ou physiques. Le prestataire interviendra en phase de construction et sera responsable de la complétude du dossier d'architecture détaillé. Les déploiements devront être conformes au dossier d'architecture technique général ainsi qu'aux standards du groupe. Les spécifications d'entrée de la prestation comprennent le dossier d'architecture générale, les dossiers d'architecture détaillée (partiels) et la documentation éditeur. Ce type de mission requiert une capacité à produire une documentation technique rigoureuse et à intervenir en autonomie sur des environnements complexes, en lien avec les équipes de run auxquelles un transfert de compétences devra être assuré. Responsabilités : - Étude du besoin en base de données - Définition des stratégies de migration - Installation et configuration des bases de données selon le DAT et les préconisations éditeur - Mise en place des sauvegardes - Support N3 du prestataire en charge du run - Participation au transfert de compétences vers les équipes de run - Contribution au rapport d'audit des bases de données existantes - Contribution au plan de migration base de données - Contribution au manuel d'installation des bases de données - Contribution au manuel d'exploitation - Contribution au dossier d'architecture détaillé Télétravail : 2 jours par semaine Localisation : Massy
Data Analyst with SQL Server and SSIS 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. 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 visualisation 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 Bank/Group applicable 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 issue to the business promptly and without delays. Ensuring any data sharing requests are discussed with business/DPO so that prior authorisation 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 visualisation tools such as Power BI - Experience in working with scripting language such as VBA and Python - Experience in 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 judgement in enabling the provision of sound advice on regulation and practice, proactive management of compliance and regulatory risk You will have at least 3 to 5 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 Statistic, Information Systems, or similar) This is an exciting position within a bank with interesting projects. The salary for this position is in the range £40K- £45K. Please do send your CV to us in Word format along with you salary and availability.
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.
Data Analyst with SQL Server and SSIS 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. 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 visualisation 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 Bank/Group applicable 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 issue to the business promptly and without delays. Ensuring any data sharing requests are discussed with business/DPO so that prior authorisation 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 visualisation tools such as Power BI - Experience in working with scripting language such as VBA and Python - Experience in 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 judgement in enabling the provision of sound advice on regulation and practice, proactive management of compliance and regulatory risk You will have at least 3 to 5 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 Statistic, Information Systems, or similar) This is an exciting position within a bank with interesting projects based in Central London. This is a hybrid role – you will be required to be in the office 3 days every week. The salary for this position is in the range £40K- £45K. Please do send your CV to us in Word format along with you salary and availability.
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.
Database Engineer with SQL and C# Our Client is a City based bank – looking to recruit a Database Engineer with at least 3 to 5 years expertise of developing and supporting SQL and C#. 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 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. Introduce new field and data types for new information to be collated in the CORE environment. To integrate with all the Bank's sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net. Build reports based on business requirements using Hyperion Interactive Reports. Ensure that the environment is running optimally and to utilise house-keeping procedures. Sharepoint Integration: 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. End of Day Cycle: Provide second and third level support for in-house programmes during the end of day cycle. Able to analyse and rectify any problems raised in an independent and team scenario. 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. Conduct Act in accordance with the FCA/PRA Code of Conduct. Business Continuity 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. SQL Programming. C# Software development. Knowledge and Skills C# Programming to high level of proficiency. Software analysis and design. SQL query language. Dimensional modelling Data warehouse design concepts, (Inmon or Kimball) This is a Full-Time Contract initially for 6 months – but likely to become permanent. Salary for this position will be £55K - £60K per annum. The Client is based in the City of London. Please do send your CV to us in Word format along with your salary and availability.
Description des Besoins Enjeux et objectifs Un profil avec des connaissances sur les technologies Microsoft BI (SSIS, SSRS et SSAS) ainsi que la maitrise du SQL, doté d'un bon relationnel et ayant la volonté de travailler en équipe. Le profil devra avoir une capacité et une volonté de montée en charge et disposer d'un sens logique avancé. Par ailleurs il devra maitriser les composantes suivantes : · DataViz : rapports dynamiques et Power BI · Datawarehouse : conception et modélisation (DataBricks ) · Base de Données : SQL Server · ETL/ELT: SSIS Description des prestations et résultats attendus Description détaillée des tâches o Migration entrepôt legacy BDD o Migration Datahub BDD o Migration des ETL SSIS o Migration de procédures stockées o Migration DataViz SSRS, SSAS et power bi
Merci de contacter Sumi Delplanque via LinkedIn. Mission Full remote / Une fois par mois à Toulouse La mission de l'Ingénieur de Données consiste à s'engager dans la refonte de toutes les applications relatives aux rotations de l'équipage, en se concentrant sur la fusion des fonctionnalités en une seule application. Ce rôle est essentiel pour garantir que de nouveaux pipelines de données sont construits efficacement à partir de la nouvelle application source tout en comprenant les processus existants. Responsabilités :Comprendre les systèmes et processus existants liés aux rotations de l'équipage. Construire de nouveaux pipelines de données pour intégrer les données de diverses sources dans l'entrepôt de données (DWH). Mettre en œuvre des fonctionnalités pour extraire et visualiser les données à l'aide d'outils de visualisation des données appropriés. Collaborer étroitement avec les ingénieurs de données et les analystes commerciaux sur le projet. Compétences Requises :Solides compétences en SQL (spécifiquement BigQuery + Dataform) Expérience avec des outils de visualisation des données (par exemple, SAP BO, PowerBI) Connaissance d'Informatica (IDMC : Intelligent Data Management Cloud) Familiarité avec Google Cloud Platform et Terraform Minimum de 3 ans d'expérience pertinente Atouts :Autonomie dans l'examen et la suggestion d'améliorations sur le code existant Capacité à utiliser des outils d'IA (par exemple, Copilot) Bonnes compétences d'intégration au sein de l'équipe Maîtrise du français avec de bonnes compétences en communication en anglais Autres Détails :Lieu : Toulouse ( quelques jours par mois ) et Full Remote Taille de l'équipe : L'équipe projet se compose de 2 développeurs et 1 chef de projet, faisant partie d'une équipe plus large de 15 personnes Durée estimée : 6 à 12 mois Présence sur site : Une fois par mois ou quelques jours par mois
Dans le cadre du développement de nos activités, nous recherchons un(e) Data Analyst / Analytics Engineer confirmé(e), capable de valoriser les données, de produire des analyses pertinentes et d'accompagner les équipes métiers dans leurs prises de décision. Nous souhaitons intégrer un profil curieux, autonome et force de proposition, à l'aise aussi bien dans les environnements techniques que dans les échanges avec les interlocuteurs métiers. Vos missions : Rattaché(e) à nos équipes, vous interviendrez sur les missions suivantes : Collecter, manipuler et exploiter des données issues de différentes sources. Réaliser des analyses approfondies afin d'identifier des tendances, des opportunités et des leviers d'amélioration. Concevoir et maintenir des reportings et dashboards adaptés aux besoins métiers. Formuler des recommandations concrètes à partir des analyses réalisées. Accompagner les équipes Marketing dans la compréhension et l'exploitation des données. Participer à la mise en place et à l'optimisation des outils de Data Analytics et de Marketing Automation. Contribuer à l'amélioration de la qualité, de la fiabilité et de la gouvernance des données. Collaborer avec les équipes IT et métiers pour faire évoluer les pratiques et les solutions Data.
Dans le cadre du renforcement de son équipe dédiée aux tests non-régression (TNR), notre client recherche un Consultant QA / Test Automation spécialisé dans l'automatisation des tests. Vous interviendrez au sein d'une équipe existante, en autonomie ou en binôme selon les besoins, sur un patrimoine de tests automatisés conséquent comprenant plus de 3 000 cas de tests, ainsi que les scripts et frameworks associés. La mission est principalement orientée vers l'exécution, la maintenance et le développement de tests automatisés. 📋 Vos missions • Assurer l'exécution des campagnes de tests automatisés et participer aux campagnes de tests menées par l'équipe • Maintenir et faire évoluer les scripts de tests existants • Développer de nouveaux scripts de tests automatisés selon les besoins • Analyser les résultats des campagnes de tests • Identifier, qualifier et documenter les anomalies détectées • Assurer le suivi des anomalies et contribuer à la production des indicateurs de qualité • S'approprier un patrimoine de tests et des frameworks existants • Intervenir sur les bases de données SQL pour consulter, mettre à jour, modifier et supprimer des données
Nous recherchons un expert DBA Apache Cassandra disposant également de compétences SQL, dans le cadre du remplacement d'un consultant. L'objectif est de reprendre rapidement un périmètre existant et d'en assurer la continuité opérationnelle, en garantissant ainsi la stabilité du service pendant la transition. Périmètre d'intervention envisagé : Reprendre l'administration des bases Cassandra et assurer le suivi de l'existant Superviser les bases, diagnostiquer les incidents et contribuer à leur résolution Participer à l'amélioration de la stabilité et des performances Intervenir sur les sujets SQL associés au périmètre.