ACCROCHE SI LA GESTION DES DONNEES EST TON DADA, TU PEUX GAGNER LA COURSE EN LISANT CETTE ANNONCE ... CE QUE TU RECHERCHES : Evoluer au sein d'une équipe dynamique Participer à des projets innovants d'envergure Relever des défis liés à la gestion et à l'analyse de données Donner un nouveau souffle à ta carrière Alors nous avons la mission idéale pour toi. Au sein d'un acteur majeur du secteur de l'assurance, tu participeras à l'analyse, et à la conception d'un entrepôt de données :Analyse des besoins, tu feras Modélisation et structuration des données, tu assureras Les pipelines de données, tu développeras Les bonnes pratiques de gestion des données, tu instaureras Des solutions de stockage et de traitement, tu optimiseras Des analyses avancées et de la valorisation des données, tu réaliseras Ton équipe, tu accompagneras Aux instances de pilotage, tu participeras QUI TU ES : Diplômé(e) de la formation qui va bien Surdoué(e) ou dôté(e) d'une expérience de 10 ans minimum Expert(e) en gestion et analyse de données gestion et analyse de données Power BI, MS BI Habile avec les outils SSIS, Powershell, Transact SQL, PL-SQL AU-DELÀ DES COMPÉTENCES TECHNIQUES, TU ES / AS : Dynamique : tu n'aimes pas rester les deux pieds dans le même sabot Autonome : un guide du Routard te suffira Esprit de synthèse : tu sais aller à l'essentiel Capacité d'adaptation : tu es un vrai caméléon Sens de la communication : les mots n'ont pas de secret pour toi Force de proposition : tu es l'Aladdin de l'informatique Esprit d'équipe : un pour tous et tous pour un !
Le consultant sera chargé de concevoir, développer, maintenir et optimiser les processus d'intégration de données ainsi que les solutions basées sur SQL, qui alimentent les applications et plateformes de reporting clients. Le poste nécessite une solide expertise opérationnelle de Microsoft SQL Server, T-SQL et SQL Server Integration Services (SSIS), avec une attention particulière portée à la fiabilité des données, aux performances des traitements et à la maintenabilité des solutions. Le consultant travaillera en étroite collaboration avec l'équipe IT en charge du reporting clients, les analystes métier et les autres équipes IT. Missions et responsabilités principales Développement ETL et intégration des données Concevoir, développer et maintenir des processus ETL à l'aide de SQL Server Integration Services (SSIS). Développer et faire évoluer des packages SSIS permettant d'extraire, de transformer et de charger des données provenant de plusieurs systèmes sources. Mettre en œuvre des mécanismes de chargement incrémental et complet. Gérer les dépendances entre les données, les séquences d'exécution, la gestion des erreurs et les processus de reprise. Améliorer les performances, la fiabilité et la maintenabilité des traitements ETL. Mettre en place des mécanismes de supervision, de journalisation et de contrôle des processus d'intégration des données. Développement et optimisation SQL Server Concevoir, développer et maintenir des procédures stockées, des vues, des fonctions et des requêtes T-SQL complexes. Développer et optimiser les logiques de transformation et d'intégration des données. Contribuer à la conception et à l'évolution des structures de données SQL Server. Analyser et optimiser les performances des requêtes SQL, les plans d'exécution et les stratégies d'indexation. Mettre en œuvre des chargements de données efficaces, la gestion de l'historisation et des mécanismes de rapprochement. Garantir l'intégrité, la cohérence et la traçabilité des données dans l'environnement de reporting. Qualité des données et support de production Mettre en place des contrôles de qualité des données et des processus de rapprochement. Analyser et résoudre les problèmes liés à l'intégration des données ainsi que les incidents de production. Superviser l'exécution quotidienne des traitements batch et identifier les points de blocage ou de ralentissement. Améliorer la gestion des erreurs, la journalisation et les capacités de redémarrage des traitements. Participer aux tests, aux validations et aux mises en production. Maintenir la documentation technique et les standards de développement. Évolutions fonctionnelles et collaboration Traduire les besoins fonctionnels en spécifications techniques et en solutions de développement. Contribuer à l'évolution des solutions existantes de traitement des données dédiées au reporting clients. Intégrer de nouvelles sources de données et adapter les processus ETL existants à l'évolution des besoins métier. Collaborer avec les analystes métier, les développeurs et les équipes responsables des systèmes sources de données. Participer aux revues de code, aux échanges techniques et aux initiatives d'amélioration continue.
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.
Database Engineer with SQL Server and SSIS Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. You must have solid expertise of at least 5 years experience of working with MS SQL Server and SSIS – SSIS is very important for this position. 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) Must have solid experience of working with SSIS and building data warehouses and some knowledge of reporting using SSRS. The Client is a Bank based in the Central London. This is a 12 month FTC position with a salary of circa £55K - £70K. 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.
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.
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.
Mission : Concevoir, développer et maintenir des processus ETL sous SSIS Développer et optimiser des procédures stockées, vues, fonctions et requêtes T-SQL complexes Mettre en place et améliorer les mécanismes de chargement, de contrôle qualité et de supervision des données Optimiser les performances des traitements ETL et SQL Server Assurer le support de production, l'analyse des incidents et les corrections associées Participer aux évolutions fonctionnelles des solutions de Client Reporting Collaborer avec les équipes métiers, analystes fonctionnels et équipes IT Participer aux revues de code et aux démarches d'amélioration continue Profil : Expérience confirmée (7 à 12 ans) en développement SQL Server et SSIS Expertise avancée sur Microsoft SQL Server, T-SQL et SQL Server Integration Services Bonne maîtrise de Git, Azure DevOps et des pratiques CI/CD Connaissance d'Azure SQL Database Maîtrise des architectures ETL, de la modélisation de données et de l'optimisation des performances SQL Une expérience dans l'Asset Management ou les services financiers est un véritable plus Français et anglais professionnels Autonome, rigoureux, orienté solution et doté d'un excellent esprit d'analyse
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.
Contexte de la mission Dans le contexte de l'implémentation des solutions décisionnelles visant à superviser la gestion immobilière de notre client, aussi bien d'un point de vue stratégique qu'opérationnel, et afin de faciliter la communication avec les différents Pôles Métiers, ils utilisent les opportunités de collaboration en ligne offertes par Power BI ainsi que les outils de la suite Microsoft tels que SSIS, SQL Server et Oracle. Détails de la prestation Profil recherché : - Le prestataire devra disposer d'une expertise confirmée en Business Intelligence, principalement dans l'analyse, la conception d'un entrepôt de données - Il devra démontrer une forte capacité à appréhender l'environnement existant, à comprendre les modèles de données, les flux, les indicateurs et les règles de gestion, notamment dans le contexte des données immobilières. - Une capacité d'analyse, de structuration et de synthèse élevée est attendue afin de qualifier les besoins métiers, d'identifier les éventuels écarts ou incohérences et de proposer des solutions BI adaptées, fiables et facilement utilisables. - La prestation nécessite également une bonne capacité de collaboration avec les équipes métiers et techniques, ainsi qu'un niveau élevé d'autonomie et de communication.
Data Engineer with SQL Server SSIS and C# Dot Net asp.net Our Client is a bank based in Central London who are looking to recruit 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 5 years experience of working with and developing software with C# Dot Net and MS SQL Server and SSIS – SSIS is very important for this position. 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. Data 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 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. Knowledge and 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 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.
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 Engineer with C# Dot Net asp.net with SQL Server SSIS 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 – 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. Data 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 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. Key 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.
Dans le contexte de l'implémentation des solutions décisionnelles visant à superviser la gestion immobilière aussi bien d'un point de vue stratégique qu'opérationnel, et afin de faciliter la communication avec les différents Pôles Métiers, nous utilisons les opportunités de collaboration en ligne offertes par Power BI ainsi que les outils de la suite Microsoft tels que SSIS, SQL Server et Oracle. - Le prestataire devra disposer d'une expertise confirmée en Business Intelligence, principalement dans l'analyse, la conception d'un entrepôt de données - Il devra démontrer une forte capacité à appréhender l'environnement existant, à comprendre les modèles de données, les flux, les indicateurs et les règles de gestion, notamment dans le contexte des données immobilières.- - Une capacité d'analyse, de structuration et de synthèse élevée est attendue afin de qualifier les besoins métiers, d'identifier les éventuels écarts ou incohérences et de proposer des solutions BI adaptées, fiables et facilement utilisables. - La prestation nécessite également une bonne capacité de collaboration avec les équipes métiers et techniques, ainsi qu'un niveau élevé d'autonomie et de communication.
