Tâches : - Qlik Replicate: - Replication tasks (Source: SAP, Destination: Snowflake) - Snowflake: - Medallion structure (Bronze: Raw, Silver: Core, Gold: Published) - Matillion: - Data transformation tasks between Snowflake layers - Other data tools (Alteryx, Tableau, SAP Business Objects): - Alteryx flows reading snowflake to publish Alteryx yxdb and Tableau data sets - SAP Business Objects / BW reports distributed directly to end users via email. Répartition estimée des tâches : - Snowflake: 50% - Qlik Replicate: 15% - Matillion: 25% - Other data tools: 10% Mandatory skills - Qlik, Snowflake,Matillion Desired - SAP BO Bonus - Alteryx, Tableau Outils à connaître : - Qlik Replicate o Configure, optimise and monitor data replication pipelines o CDC Management o Endpoints Source: SAP, Target: Snowflake - Snowflake o Warehouse design – architect, build and optimise data warehouses within Snowflake o Integration with Qlik and/Matillion - Matillion o Build and maintain transformation pipelines using Matillion ETL - SAP Business Objects o Universe Development – design, build and maintain Information Design Tool (IDT) and Universe Design Tool (UDT) layers o Report Creation – develop reports and dashboards using Web Intelligence (WebI) - Alteryx o Knowledge of design, build and maintenance of ETL workflows with Alteryx Designer - Tableau o Knowledge of data preparation for tableau datasets
Data Engineer with C# Dot Net asp.net with SQL Server SSRS and Power BI Our Client is a bank based in City 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 SSRS. You must have solid expertise of at least 7 to 10 years experience of working with and developing software with C# Dot Net and MS SQL Server and SSRS – SSRS is very important for this position. Additionally, you must have sound experience of working with Power BI and Python. 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 SSRS packages. Risk & Regulatory 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. Main Skills Software analysis and design. SQL Server query language with SSRS. 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 SSRS and building data warehouses and reporting services. Experience of working with and developing software with Power BI and Python are essential. The Client is a Bank based in the City London. Must have a degree qualification. This is a 12 month FTC position with a salary of circa £65K - £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 : Dans le cadre d'un programme stratégique de transformation des SI Achats, notre client recherche un Consultant Senior Data Migration pour piloter la migration des données vers une nouvelle plateforme Procure-to-Pay (P2P). Le consultant interviendra sur la conception fonctionnelle de la migration, la modélisation des données, la gouvernance, la qualité des données ainsi que la coordination entre les équipes métiers et techniques. Missions : · Concevoir les modèles de données cibles et les matrices de mapping (Source-to-Target Mapping). · Définir les règles de gestion, de transformation, d'historisation et de traçabilité des données. · Construire et maintenir le dictionnaire de données et le Data Lineage. · Piloter les différentes phases de migration (préparation, paramétrage, tests, validation et mise en production). · Garantir la qualité, la conformité et la gouvernance des données migrées. · Animer les ateliers avec les équipes Achats, Finance et Data. · Assurer l'interface entre les équipes métiers, Data et développement. · Valider la conformité fonctionnelle des développements. · Concevoir les modèles décisionnels et contribuer aux reportings Power BI. · Définir les indicateurs métiers et assurer la cohérence des données analytiques. Compétences requises : · Migration de données. · Modélisation de données. · SQL. · Data Warehouse. · Source-to-Target Mapping. · Data Lineage. · Gouvernance et qualité des données. · Procure-to-Pay (P2P). · Power BI. · Animation d'ateliers métiers. · Rédaction de spécifications fonctionnelles. Environnement technique : · SQL · Microsoft Fabric · Azure Data Factory · Power BI · Python · Data Warehouse · Self-Service BI
Au sein d'une Direction des Services Socles et Poste de Travail, vous intervenez sur une plateforme Data centralisant de multiples sources d'information liées à la gestion des actifs informatiques, aux identités numériques, aux référentiels d'entreprise et aux données de gestion. Ces données sont consolidées au sein d'un Data Warehouse Cloud Azure afin de produire des indicateurs décisionnels, des tableaux de bord Power BI et des reportings destinés aux différentes directions métiers. Les principaux usages concernent notamment : Le pilotage des services internes ; Le suivi de la consommation et de la facturation des offres de services ; L'aide à la décision ; Le suivi des projets et déploiements ; L'historisation des données ; L'amélioration de la gouvernance des actifs IT. Missions principalesDans le cadre de l'évolution et de l'industrialisation de la plateforme Data, vous intervenez en tant qu'Ingénieur Data avec une forte dimension DevOps. Data Engineering & SupervisionConcevoir, développer et maintenir des pipelines de traitement de données sur Azure Databricks. Développer des notebooks PySpark permettant l'alimentation des couches Bronze, Silver et Gold selon l'architecture Médaillon. Exploiter et optimiser les formats de données Parquet, Delta Lake et CSV. Garantir la qualité, la performance et la fiabilité des traitements. Optimiser les jobs existants afin de réduire les temps d'exécution et les coûts d'exploitation. Mettre en place et maintenir les dispositifs de supervision et de monitoring des flux de données. Assurer le suivi de la qualité des données et la gestion des alertes. Participer à la résolution d'incidents et à l'amélioration continue de la plateforme. Collaborer avec les équipes métiers et techniques afin de comprendre les besoins et proposer des solutions adaptées. DevOps & Infrastructure CloudParticiper à l'administration et à l'évolution de l'infrastructure cloud Azure. Maintenir et faire évoluer les infrastructures as code via Terraform. Développer et maintenir les pipelines de déploiement sous Jenkins. Contribuer aux processus CI/CD et aux bonnes pratiques d'industrialisation. Réaliser des revues de code et participer à la gestion des dépôts GitHub. Contribuer à l'automatisation des déploiements et à l'amélioration des standards techniques.
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.
