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

Pour un grand compte bancaire, à Paris : Contexte : 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 internes 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 Compétences requises • Capacité d'analyse et synthèse • Bonne compréhension des besoins et enjeux métier (la connaissance du domaine de l'assurance et/ou de la caution est un plus) • Maîtrise des modèles de données relationnelles/étoiles et de leur modélisation • Maîtrise du langage SQL • Qualités rédactionnelles • Aptitude relationnelle à travailler en équipe et avec de multiples interlocuteurs • Autonome, rigoureux et fiable • Bonne connaissance des SGBD (Oracle & SQL Server sont un plus) • Maitrise de l'ETL (Informatica) Environnement fonctionnel & technique : Informatica powercenter 10.4 Oracle Exadata Méthodes & Outils : Agilité SAFE

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.

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

Our client based in Newbury is looking for a Data Scientist with experience in designing scalable, secure and high performance data solutions. This is a 6 months contract with good possibility of extension. The role is hybrid with 2-3 days onsite in Newbury. Required experience: * Data science, ML , EDA and feature engineering. Experience of having ideated, developed and deployed to production end to end data science use cases. * Design and architect scalable, secure, and high -performance data solutions primarily using the Snowflake platform. * Leverage Openflow experience to optimize data workflows and integrations. * Develop and maintain ETL/ELT pipelines for data ingestion from various sources, including Salesforce, relation, files and NoSQL databases. * Collaborate with data engineers, analysts, and business stakeholders to translate business requirements into technical solutions. * Implement dimensional modeling techniques to support data warehousing and business intelligence needs. * Build and optimize data pipelines across cloud environments (Azure and AWS) ensuring efficient data movement and transformation. * Ensure data quality, governance, and security best practices are adhered to across the data architecture. * Support analytics and reporting teams by enabling data access and integration with Power BI and Tableau dashboards. * Stay current with emerging data technologies and recommend improvements to existing data architecture. LA International is an award-winning partner of choice for many of the world's most influential companies and government organisations. Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance. A multiple award-winning organisation, having secured the prestigious Queens Award for Enterprise: International Trade over consecutive years. We are committed to fostering an inclusive, equitable and accessible workplace where everyone feels valued and supported. We welcome applications from all individuals, regardless of background or identity, and we encourage candidates who may not meet every listed requirement to still apply. If you require any adjustments or support during the recruitment process, please let us know and we will work with you to ensure a fair and accessible experience. Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.