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

Application Support Analyst Reporting to the IT Service Delivery Manager, the Application Support Analyst has primary responsibility for providing day to day operational support for the Company Application Portfolio, through the effective use and management of incident, requests and problems. You will be responsible for the regular monitoring and maintenance of the application portfolio. You will be responsible for the change management process for the Company, ensuring that the all changes are managed in accordance with the appropriate policies and that they have an appropriate roll-back plan and are scheduled in conjunction with the SSC and 3 party suppliers as appropriate. In addition you will provide appropriate SharePoint expertise, in terms of support, content management and development of sites, services and functionality. Responsibilities Provide 2 and 3 line support for the Company application portfolio Monitor application systems, identifying performance trends and taking action when necessary to stop problems arising Liaise with 3 party suppliers, ensuring issues are escalated and dealt with as necessary and to SLA Manage all system access requests Own application/system documentation and the data repository that holds that information (i.e. SharePoint) Provide technical support to the application architect and project services as required for project deliverables Ensure that pro-formas are completed and submitted and track delivery Provide test support for new and enhanced systems/applications Responsible for Change Management process, ensuring that changes are managed, roll-back plans are in place and that they are appropriately scheduled and approved, liasing with SSC Change Manager Owns Configuration Management process Responsible for scheduled maintenance and capacity planning Ensure that security, compliance and legislation is considered in all aspects of the role and associated processes Responsible for the development and maintenance of the Corp data warehouse Run reports and conduct analysis in-line with Business/Management requirements Responsible for the provision of performance information, ensuring timely, accurate reports are provided to the necessary parties Work with the Application Architect and Project Services to ensure that data/information analysis and reporting is considered in the development of new and enhanced systems design to ensure consideration is given to the linking, matching and cleansing of data across systems. Knowledge & Experience Proven experience working in 1 and 2 line support role Experience of working with ITIL processes within an organisation, in particular, incident, request, change and problem Management Experience working in a customer facing technical role Proven experience working with and managing 3 party suppliers Experience managing assets, both hardware and software Knowledge and understanding of the Company application portfolio Personal Attributes Excellent team working and interpersonal communication skills Exceptional oral and written communication skills Good team player and collaborative Ability to work on own initiative and with minimal supervision Technical background in application support and maintenance Ability to manage competing priorities Excellent attention to detail Analytical, with excellent problem-solving skills Ability to put the Customer at the heart of everything they do The position is based in Central London. The salary for this role is £35K - £40K + Benefits. Please do send your CV to us in Word format along with your salary and notice period.

Job Title: Senior Power BI Developer Location: Completely Remote role, can be Located anywhere in the UK! Salary: Depending on experience Job Type: Permanent, Full Time We're proud to be a trusted leader in SQL development services, and in database, server, cloud, and application services. We enjoy helping our clients, many of which are well-known household brands, stay connected and supported. We are seeking an experienced Senior Power BI Developer to design, develop and support modern business intelligence and analytics solutions using Power BI and other SQL Server technologies. About the role: The successful candidate will combine strong technical expertise with excellent stakeholder engagement skills, helping clients and internal teams transform raw data into meaningful business insights. The role will involve creating enterprise-grade Power BI reporting platforms, and mentoring junior developers to support their technical and professional growth. This is an excellent opportunity for someone who enjoys working across the full BI lifecycle, from requirements gathering and solution design through to development, deployment, optimisation and support. Key duties: Business Intelligence & Reporting Design, develop and maintain enterprise Power BI solutions Design and maintain scalable data models using dimensional modelling and star schema best practices Create intuitive dashboards, reports and visualisations that enable data-driven decision making. Develop and maintain semantic models, datasets, dataflows and Power BI workspaces. Implement best practices for report performance, usability, security and governance. Develop advanced DAX calculations, measures and KPIs. Optimise report and dataset performance, ensuring reliability and scalability Wider Fabric Knowledge would be advantageous Understanding of data warehouse solutions would be ideal but not essential Client & Stakeholder Engagement Work directly with clients and business stakeholders to understand requirements Translate business requirements into robust technical solutions Conduct workshops, technical reviews and design sessions Produce high-quality technical documentation and solution designs Provide guidance and recommendations on best practices and future roadmap opportunities Leadership & Mentoring Provide technical leadership within the BI aspect of the Development team Mentor and support junior BI Developers and Data Engineers Undertake code reviews and provide constructive technical feedback Assist in developing standards, frameworks and development methodologies Promote continual learning and knowledge sharing across the team About you Essential Strong commercial experience developing Power BI solutions Advanced knowledge of Power BI including: DAX Power Query Semantic Models Row Level Security (RLS) Workspace and deployment management Extensive SQL Server development experience Experience designing and implementing dimensional models Experience gathering requirements and producing technical documentation Experience working directly with business stakeholders and clients Experience troubleshooting and performance tuning reporting and database solutions Experience using source control systems such as Git and Azure DevOps Desirable Experience with Azure Data Services Experience with Microsoft Fabric Data Factory Experience with Lakehouse architectures Experience with PowerShell automation Experience with CI/CD pipelines and automated deployments Experience with Python for data engineering or analytics An understanding of data warehousing principles and methodologies is preferable Experience developing ETL/ELT processes Knowledge of Microsoft Fabric and modern data platform technologies is preferable Knowledge of Microsoft Purview and data governance frameworks Microsoft certifications including PL-300, DP-600 or DP-203 Personal Attributes Excellent analytical and problem-solving skills. Strong communication and stakeholder management abilities. Passion for data and new technologies. Self-motivated and capable of working independently. Strong mentoring and coaching capabilities. Commercial awareness and customer-focused mindset. Ability to prioritise and manage multiple assignments simultaneously. Commitment to continual professional development. Why join us: Competitive salary and benefits package Generous Pension Contribution Scheme (up to 10% match) Income Protection/Life Insurance 5 weeks' annual leave (pro rata) plus options to buy/sell days Paid birthday leave, volunteering days, and extra leave for long service Work with modern Microsoft technologies including Fabric, Power BI and Azure. Opportunity to influence technical direction and best practices. Supportive environment focused on learning and professional growth. Exposure to a diverse client base and challenging projects. Opportunity to mentor and develop the next generation of BI professionals. Company-sponsored training and certifications Quarterly team training and get-togethers Please click on the APPLY button to send your CV, you will then be sent a link to a Skills Assessment Form. Only candidates that complete the Skills Assessment form will be considered. Expected recruitment timeline: Applications close: 17 September First interviews: Week of 21 September via video Second interviews: 14 October in person Candidates with experience of; Power BI Developer, Senior BI Developer, Business Intelligence Developer, BI Analyst, Data Visualization Specialist, Microsoft Fabric Developer, DAX Developer, SQL & Power BI Engineer, BI Consultant, Analytics Developer, Reporting Specialist, Data Modeller, Enterprise BI Developer, BI Technical Lead, Business Intelligence Analyst also be considered for this role. IndeedH2F

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.

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