Trouvez votre prochaine offre d’emploi ou de mission freelance Data Warehouse

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.

Data Analytics Senior Manager – Kings Cross London The Data Analytics team provides information that is accurate, consistent, timely and reliable, and ensure the information is easily available to users for direct consumption or integration with other systems. The DA team trains CSI managers and staff to use the data as an analytical tool for the purpose of understanding and option exploration. Champion enterprise-wide culture of fact-based decisions, data quality and accountability. Serve as the administrative chair facilitating a business data analytics governance council which shall review and approve information policies, data analytics priorities and resource allocations. Review and recommend approval for information related policies, procedures and standards. Directs, organizes, and leads DA workstream projects. Works on highly complex, cross-functional, and enterprise solutions. Establishes processes, roles and quality criteria for workstream planning process including inception, technical design, development, testing and delivery of DA solutions. Reviews and approves work plans, timelines, deliverables and resource commitments. Reviews and approves data architecture, data models and specifications. Establishes and publishes performance metrics and plans for DA service demand and service levels. Prepares and manages annual capital and operating budgets for DA assets, personnel and services. Recruits, hires, develops and motivates the DA team members. Reviews and approves functional requirements and business cases for DA improvements. Advises executives on how DA (processes, practices and technologies) play a critical role in improving business management and optimization. Aligns DA technologies with CSI strategic initiatives. Approves selection of tools, frameworks and mechanisms for data analytics. Responsible for strategic, tactical, operational, financial, human, and technical resource managerial responsibilities associated with the following DA and DA-related functional areas: Data governance Data preparation (sourcing, acquisition, integration) Data warehousing Reporting, analytics, data exploration Information delivery (portals, mobile) DA competency center or center of excellence (DA COE) A university degree in computer science, economics, operations, management, or a related field is required A minimum of five (5) years of progressively responsible experience in a directly related area, during which both professional and management capabilities have been clearly demonstrated. Industry/domain skills: Extensive expertise in finance, HR, sales, marketing, product lifecycle management, manufacturing and post-sales service. Medical device or pharmaceutical industry experience is preferred. Experience in and understanding of a wide variety of analytical processes (governance, measurement, etc.). Experience with agile software development. A solid understanding of key trends including machine learning and artificial intelligence. General business skills: Analytical mind with a problem-solving aptitude expressed with clear, concise written, verbal and presentation skills. Experience managing global, complex projects and teams. Ability to complete projects and achieve results in an ambiguous work environment. Ability to take initiative and be innovative. Ability to establish and articulate a vision, set goals, develop and execute strategies, and track and measure results. Ability to build and motivate a team to achieve well communicated expectations. Strong leadership and consensus building abilities across global cultures and all levels of management. The salary for this role is expected to be in the range £70K - £85K. Location is Kings Cross London. Please send your CV to us in Word format along with your salary and availability.

Data Analytics Senior Manager – Kings Cross London The Data Analytics team provides information that is accurate, consistent, timely and reliable, and ensure the information is easily available to users for direct consumption or integration with other systems. The Data Analytics team trains CSI managers and staff to use the data as an analytical tool for the purpose of understanding and option exploration. Champion enterprise-wide culture of fact-based decisions, data quality and accountability. Serve as the administrative chair facilitating a business data analytics governance council which shall review and approve information policies, data analytics priorities and resource allocations. Review and recommend approval for information related policies, procedures and standards. Directs, organizes, and leads Data Ananlytics workstream projects. Works on highly complex, cross-functional, and enterprise solutions. Establishes processes, roles and quality criteria for workstream planning process including inception, technical design, development, testing and delivery of DA solutions. Reviews and approves work plans, timelines, deliverables and resource commitments. Reviews and approves data architecture, data models and specifications. Establishes and publishes performance metrics and plans for DA service demand and service levels. Prepares and manages annual capital and operating budgets for DA assets, personnel and services. Recruits, hires, develops and motivates the DA team members. Reviews and approves functional requirements and business cases for DA improvements. Advises executives on how DA (processes, practices and technologies) play a critical role in improving business management and optimization. Aligns DA technologies with CSI strategic initiatives. Approves selection of tools, frameworks and mechanisms for data analytics. Responsible for strategic, tactical, operational, financial, human, and technical resource managerial responsibilities associated with the following DA and DA-related functional areas: Data governance Data preparation (sourcing, acquisition, integration) Data warehousing Reporting, analytics, data exploration Information delivery (portals, mobile) DA competency center or center of excellence (DA COE) A university degree in computer science, economics, operations, management, or a related field is required A minimum of five (5) years of progressively responsible experience in a directly related area, during which both professional and management capabilities have been clearly demonstrated. Industry/domain skills: Extensive expertise in finance, HR, sales, marketing, product lifecycle management, manufacturing and post-sales service. Medical device or pharmaceutical industry experience is preferred. Experience in and understanding of a wide variety of analytical processes (governance, measurement, etc.). Experience with agile software development. A solid understanding of key trends including machine learning and artificial intelligence. General business skills: Analytical mind with a problem-solving aptitude expressed with clear, concise written, verbal and presentation skills. Experience managing global, complex projects and teams. Ability to complete projects and achieve results in an ambiguous work environment. Ability to take initiative and be innovative. Ability to establish and articulate a vision, set goals, develop and execute strategies, and track and measure results. Ability to build and motivate a team to achieve well communicated expectations. Strong leadership and consensus building abilities across global cultures and all levels of management. The salary for this role is expected to be in the range £70K - £85K. Location is Kings Cross London. Please send your CV to us in Word format along with your salary and availability.

Spécifications techniques et développements du DataWarehouse, du ou des Datamart(s) dans le cadre du projet de mise en œuvre du SID Sinistralité (SIRRAH). Le développeur Informatica doit développer les workflows d'alimentation des différents schéma de la base de donnée (DWH et DM) de ce nouveau SID à partir : - modélisation de bdd mise à disposition par les BAS - des mappings mis à disposition par les BAS - différentes informations récoltées en atelier de travail - des normes et standards de développements ETL en place Il participera aux différentes phases du projet de la conception jusqu'à la mise en production en passant les phases de tests (intégration/recette/homologation) Il sera en outre supervisé par le techlead Informatica de l'équipe en place. Appropriation des modèles de données source et cible impactant le SID • Développement des nouveaux worflow et évolution des worflows existants • Rédactions des SFT DWH/Datamart • Correction des anomalies Informatica

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 Consultant BI (H/F) à Namur, Belgique. Modalités : Mode hybride - Site client basé à Namur Durée de la mission : 12 mois renouvelables Responsabilités : Contribuer aux réunions de travail et de brainstormings, Prise de connaissance des concepts (formulaire, démarche, soumission, … ) et rationalisation de ceux-ci, Analyse des sources et données disponibles, Analyse des rapports existants (réalisés en Excel et SAP BO), Modélisation de la base de données décisionnelle (modèle conceptuel / modèle en étoile) intégrant les différentes sources de données, Réalisation / finalisation d'un POC, en local, sur un PC avec Power BI Desktop permettant de : Extraire (E) et intégrer les données utiles des sources de données disponibles, Transformer (T) vers ce qui est attendu dans la BDD de destination (filtrage, fusion, agrégation, changement de format, …), Charger (L) les données transformées dans la base de données décisionnelle (BDD) : Consulter la BDD et exploiter ses données : réalisation de quelques rapports et tableaux bord, Extensions et industrialisation du POC sur l'infrastructure DB/réseau mise à disposition par le SPW (Equipe CSID – Informatique Décisionnelle / Pole Data), dans le cloud ou en local, Analyse/conception et automatisation de l'intégration avec les sources de données et les back-offices fournisseurs du DWH. Comprendre les données disponibles sur les différentes sources, la documentation fournie (en particulier les schémas de base de données), les rapports existants (excel et BI). Faire les liens entre ces données et d'analyser les besoins en consolidation de données; Concevoir la structure de la BBD ; Développer le datawarehouse associé ; Développer les procédures de chargement et outils de consultation ; documenter le travail effectué ; Environnement linguistique de la mission : Français

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é.

MS SQL Server DBA Database Administrator – Investment Bank – Canary Wharf - London Our Client is an International Bank with offices in Canary Wharf London. They are now looking to recruit a Senior MS SQL Server DBA with at least 5 years expertise. Although the role is for a Senior MS SQL Server DBA – the Client would like you to have a background in Data Warehousing. As MS SQL Server DBA with Application Support you will be involved with developing and implementing solutions for the banks financial systems. As an MS SQL Server DBA role will involve the following: Ensure the integrity, security and accuracy of production database environment, ensuring good performance of the dependent applications. Plan and implement operating procedures for backup of database and recovery of database information. Develops database-related application development standards covering database creation, software placement, storage and auditing. Ensures the integrity of the recovery system at all times. Initiates formal testing of the recovery system. Develops database procedures as necessary to enhance the application suite as required. Responds to, resolves and documents support calls for the production and test applications. Maintains to a high standard documentation supporting the build, maintenance and operational procedures of the database environment. Acts as the technical liaison between database operations and vendor support. Performs other related duties as assigned. You must have at least 5 to 7 years solid expertise as a MS SQL Server DBA – Database Administrator. Must have the Microsoft SQL Server Administration (Enterprise Edition) experience. High Level T-SQL programming (SP, Functions, Triggers). Operation, design and implementation experience of Mirroring, Log Shipping and SQL Server Replication. SQL Reporting services and Analysis services maintenance and tuning. Configuration and operation of clustered database Servers using external storage. Scripting stored procedures. Security concepts of database management. Change management concepts and application The role will be to work as a MS SQL DBA with an element of supporting financial applications. Salary for this role is negotiable - but is expected to be in the range £55K - £70K + benefits. Please send your CV's to us in MS Word format.

Kajenthi @ RED Global – Recherche Tech Lead Informatica – Freelance – 6 mois + - Paris – Hybride Dans le cadre d'un programme de transformation Data, nous recherchons un Tech Lead Informatica pour assurer la maîtrise d'œuvre des projets d'intégration de données. Vous serez le référent technique des équipes de développement et garantirez la qualité, la performance et la bonne exécution des solutions ETL. Responsabilités Piloter les chantiers techniques et coordonner les développements Informatica. Traduire les besoins fonctionnels en solutions techniques en collaboration avec les équipes MOA. Participer à la conception technique et à l'architecture des flux de données. Encadrer les développeurs ETL et assurer les revues de code. Garantir le respect des normes de développement, des bonnes pratiques et de la qualité des livrables. Estimer les charges, planifier les développements et suivre l'avancement des travaux. Participer aux ateliers de conception avec les métiers, architectes et équipes Data. Superviser les phases de développement, tests, recette et mise en production. Assurer le support technique de niveau 3 et le traitement des incidents complexes. Identifier les axes d'amélioration et contribuer à l'évolution de la plateforme Data. Produire et maintenir la documentation technique. Profil recherché Minimum 8 ans d'expérience sur des projets Informatica. Expertise sur Informatica PowerCenter et/ou Informatica Intelligent Cloud Services (IICS). Expérience confirmée en pilotage technique (MOE ou Tech Lead). Solides compétences en SQL (Oracle, SQL Server, PostgreSQL). Bonne maîtrise des architectures décisionnelles (Data Warehouse, Data Lake) et des processus ETL. Expérience des environnements Cloud (Azure, AWS ou GCP) appréciée. Connaissance des outils de versioning, d'intégration continue et des méthodologies Agile. Excellentes capacités de coordination, de communication et d'accompagnement des équipes. Français courant Si vous etes interressé par la mission, n'hésitez pas à m'envoyer votre CV sur

BI Consultant – Dutch / FrenchLocalisation : Bruxelles, Belgique Secteur : Énergie Langue : Néerlandais ou Français ContexteDans le cadre d'un projet dans le secteur de l'énergie, nous recherchons un Consultant BI capable d'accompagner les équipes métier dans l'analyse, la valorisation et l'exploitation des données. Le consultant intégrera une équipe Data & Innovation et contribuera au développement d'une véritable culture data au sein de l'entreprise. Missions principalesComprendre les processus métier et les enjeux liés aux domaines Grid, Finance et Logistique. Recueillir, analyser et challenger les besoins des utilisateurs. Traduire les problématiques métier en analyses de données pertinentes et en recommandations opérationnelles. Concevoir et développer des rapports et dashboards Power BI pour les différentes lignes métier. Concevoir des visualisations claires, intuitives et orientées utilisateurs. Appliquer les principes de Data Storytelling et d'Information Design. Accompagner les utilisateurs dans l'interprétation des résultats et l'adoption des solutions proposées. Contribuer aux initiatives du Data Office autour de la Data Governance, Data Quality et Data Products. Participer à la diffusion d'une culture Data au sein de l'entreprise. Data & InnovationLe profil recherché doit être curieux, ouvert à l'innovation et attentif aux évolutions du marché Data & Analytics. Une bonne connaissance ou un intérêt pour les sujets suivants est apprécié : Data Products Data Mesh Data Governance Data Quality Intelligence artificielle générative et analytique Utilisation de l'IA pour améliorer la productivité et accélérer l'analyse des données. Compétences requisesBusiness & secteurExpérience significative en Data Analysis et accompagnement des métiers. Expérience significative dans le secteur de l'énergie, permettant de comprendre rapidement les enjeux et processus spécifiques du domaine. Capacité à traduire les besoins métier en solutions analytiques à forte valeur ajoutée. Capacité à fournir des analyses permettant d'appuyer la prise de décision. Data & AnalyticsExpérience significative dans un environnement Data Warehouse, Data Platform ou plateforme analytique équivalente. Très bonne compréhension des concepts de : Modélisation des données Intégration des données Valorisation des données SQL : maîtrise indispensable. Capacité à analyser des données complexes et à en extraire des insights exploitables pour le métier. Reporting & VisualisationExpérience significative avec Microsoft Power BI. Maîtrise de la conception de rapports et dashboards orientés métier. Bonne connaissance des principes de : Data Visualization Ergonomie Data Storytelling Information Design AtoutsExpérience avec SAS Visual Analytics. Certification officielle Microsoft Power BI. Profil recherchéNous recherchons un Consultant BI confirmé/senior, orienté métier et data, capable de faire le lien entre les besoins business et les solutions analytiques. Le candidat doit être autonome, analytique, communicatif et capable de transformer des données complexes en recommandations claires et exploitables. Langue : Néerlandais ou Français. ⚠️ Point important : l'expérience dans le secteur de l'énergie et la maîtrise de Power BI sont des critères majeurs pour cette mission.

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.

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 SSIS and Network Engineer 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. 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 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 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 Statistic, 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.

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.

Consultant BI Confirmé / Senior – Intégration Data & Reporting DécisionnelContexte de la missionDans le cadre du déploiement d'une solution de pilotage et de reporting pour plusieurs entités ultramarines d'un grand groupe immobilier, notre client recherche un consultant BI expérimenté afin de renforcer son équipe décisionnelle. La mission consiste à contribuer à l'intégration de données issues d'un système métier spécifique au sein de l'infocentre groupe, ainsi qu'à la conception, au développement et à la maintenance des solutions de reporting décisionnel. Le consultant interviendra sur l'ensemble de la chaîne décisionnelle : analyse des besoins, conception, développement, tests, mise en production et accompagnement des utilisateurs. Missions principalesAnalyse et cadrage fonctionnelRecueillir et analyser les besoins auprès des équipes métiers. Participer aux ateliers de cadrage. Comprendre les enjeux fonctionnels et décisionnels. Formaliser les besoins fonctionnels et techniques. Rédiger les spécifications associées aux évolutions demandées. Conception et développement décisionnelConcevoir et développer des solutions BI adaptées aux besoins métiers. Développer les flux d'intégration de données. Participer à l'intégration des données issues du système métier dans l'infocentre. Concevoir et maintenir des tableaux de bord et reportings décisionnels. Garantir la cohérence, la qualité et la fiabilité des données exploitées. Tests et mise en productionRéaliser les tests unitaires. Participer aux phases de recette fonctionnelle et technique. Préparer les livrables nécessaires aux mises en production. Accompagner les déploiements. Assurer le suivi de la qualité des données. Accompagnement utilisateursAssister les utilisateurs métiers dans l'exploitation des outils décisionnels. Former et accompagner les équipes. Assurer le support fonctionnel et technique. Participer à l'amélioration continue des solutions BI. Environnement techniqueBI & ReportingQlik Sense QlikView NPrinting Framework décisionnel groupe Data & IntégrationDataiku OTIC / GENIO V16 OpCon V22 Concepts ETL Datawarehouse Infocentre Bases de donnéesIBM DB2 400 IBM DB2 BLU SQL Server Oracle MySQL Outils projet & DevOpsGit Bitbucket Jira Jalios Sciforma ERP métierIKOS (Sopra)