Jobs
>
London

    Data Warehouse Project Lead - London, United Kingdom - Amber Labs

    Default job background
    Description

    Data Warehouse Project Lead

    Location: Remote – Must be UK based

    Work Pattern: Contract – approx. 3 months with high possibility of extension

    Security Clearance: BPSS

    The Company:

    At Amber Labs, we are a cutting-edge UK and European technology consultancy that prioritises empowering autonomy, promoting experimentation, and facilitating rapid learning to provide exceptional value to our clients. Our company culture is centred around collaboration, where all colleagues, regardless of their role, work together to minimise risk and shorten delivery times. Our team consists of highly-skilled cross-functional consultants, analysts, and support staff.

    The Role:

    We are seeking a highly skilled and experienced Data Warehouse Project Lead to join our dynamic team. As a Data Warehouse Project Lead, you will be responsible for overseeing the design, development, and implementation of data warehouse solutions in alignment with the organisation's strategic goals. The ideal candidate will have extensive enterprise experience, a proficient understanding of the Microsoft technology stack, and demonstrable expertise in data engineering and architecture.

    Key Responsibilities:

    • Lead the end-to-end implementation of data warehouse projects, from requirement gathering to deployment and maintenance.
    • Collaborate with stakeholders to define project scope, objectives, and deliverables.
    • Design and develop robust data warehouse architectures that support scalability, performance, and data integrity.
    • Implement best practices for data modelling, ETL processes, and data integration.
    • Optimise data warehouse performance through efficient query design, indexing strategies, and data partitioning.
    • Provide technical guidance and mentorship to team members, ensuring adherence to industry standards and best practices.
    • Work closely with business analysts and data scientists to understand analytical requirements and translate them into technical solutions.
    • Collaborate with cross-functional teams to ensure seamless integration of data warehouse solutions with existing systems and applications.
    • Stay updated on emerging trends and technologies in data management and analytics, and evaluate their potential impact on our data warehouse architecture.

    Requirements:

    • Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
    • Proven experience leading data warehouse projects in enterprise environments.
    • In-depth knowledge of the Microsoft technology stack, including SQL Server, SSIS, SSAS, and SSRS.
    • Strong proficiency in data modelling concepts and techniques (e.g., dimensional modelling, star schema, snowflake schema).
    • Expertise in designing and implementing ETL processes using industry-leading tools and frameworks.
    • Solid understanding of data governance principles, data quality management, and metadata management.
    • Excellent problem-solving skills and the ability to troubleshoot complex issues in data warehouse environments.
    • Exceptional communication and interpersonal skills, with the ability to effectively interact with stakeholders at all levels of the organisation.
    • Proven leadership abilities, with a track record of successfully leading and motivating teams to achieve project goals.
    • Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer Associate) would be a plus.

    Diversity & Inclusion:

    Here at Amber Labs, we are dedicated to fostering an inclusive and equitable workplace for all. Our commitment to diversity, equality, and inclusion includes:

    • Valuing the unique experiences, perspectives, and backgrounds of all employees and creating an environment where everyone feels welcomed, respected, and valued.
    • Prohibiting all forms of harassment, bullying, discrimination, and victimisation and promoting a culture of dignity and respect for all.
    • Educating all new hires on our Diversity and Inclusion policies and ensuring they are aware of their rights and responsibilities to create a safe and inclusive workplace.
    • By taking these steps, we are dedicated to building a workplace that reflects and celebrates the diversity of our employees and communities.

    This role at Amber Labs is a permanent position, and all employees are required to meet the Baseline Personnel Security Standard (BPSS). Please be advised that, at this time, we are unable to consider candidates who require sponsorship or hold a visa of any type.

    What Happens Next?

    Our Talent Acquisition Team will be in touch to advise you on the next steps. We have a two-stage interview process for most of our consultants. In certain cases, we may include a third and final stage, which is a conversation with the company Partners. This will only be considered if deemed necessary.


  • DEFRA

    Project Lead

    4 days ago


    DEFRA England, United Kingdom

    This is an exciting opportunity to be part of the development of a world class science facility delivering infrastructure critical to animal health and farming in the UK at the heart of Defra's agenda. A ten-year programme of work, with a significant budget has been secured to re ...

  • United Learning

    Project Lead

    20 hours ago


    United Learning London, United Kingdom

    **The Role** · United Learning are one of four partners selected by The Maths Excellence Fund to trial and test initiatives that will increase the attainment and progress of disadvantaged pupils with potential for Maths excellence. We have been awarded £1.9 million to fund our pr ...

  • Change Grow Live

    Project Lead

    20 hours ago


    Change Grow Live London, United Kingdom

    Overview: · **Join Our Compassionate Team: Project Lead Opportunity in Camden, London.** · At · **Change Grow Live**, our belief in creating positive impacts for our Service Users is at the heart of everything we do. Upheld by our core values to be · **"open, compassionate, and b ...

  • Equinor UK Limited

    Project Lead

    1 day ago


    Equinor UK Limited London, United Kingdom

    Project Lead - Pipeline · - Overview · Job ID: · 27903Country: · Great BritainLocation(s): · London, Leeds, AberdeenCompany: · Equinor UK LimitedContact Name: · Workplace: · OnshoreDiscipline: · Marketing & SupplyEducation Preferred: · Bachelor or Master's degreeExperience Prefer ...

  • Penrose Health

    Project Lead

    4 days ago


    Penrose Health London, United Kingdom

    **Our Patients Need You**: · At Penrose Health, our mission is to provide **the best healthcare** to our patients. We're a friendly team looking for like-minded people who can help us fulfill this mission and make a real difference to our patients' lives · **The job**: · We are s ...

  • St John Ambulance

    Project Lead

    3 days ago


    St John Ambulance London, United Kingdom

    **What's involved**: · **Department**: · Youth & Volunteering · **Salary**: · £12.71 Per Hour · **About the Role** · The NHS Cadets Project aims to attract and develop young people, preparing them to sustain themselves in health volunteering opportunities. Through a 36 week progr ...

  • The Movement Factory

    Project Lead

    2 days ago


    The Movement Factory London, United Kingdom

    **Part time worker,** 3 days per week: Tuesday, Wednesday, Thursday and x2 evenings per week. Willing to work evenings, weekends and ad hoc. · **Pro-rata salary**: £30,000 p/a, pro rata · **Location**: Peckham Rye, remote working and ad hoc · **Start date**: March 2023 and onward ...

  • Brixton BID

    Project Lead

    1 day ago


    Brixton BID London, United Kingdom

    We believe Brixton is like nowhere else. Established in 2014 by local businesses, the Brixton BID works to make our district a sustainable and distinctive destination. We provide additional opportunities for our members whilst creating an attractive environment for all. When Brix ...

  • Hammersmith & Fulham Council

    Project Lead

    3 days ago


    Hammersmith & Fulham Council Hammersmith, United Kingdom

    At Hammersmith & Fulham, we are ambitious in reforming the council to ensure this is a place for everybody. Within the Economy department, we aim to be efficient in everything that we do. We believe our residents deserve a place that is safe, clean and green, with high quality se ...

  • CREATIVE PERSONNEL Ltd

    Digital Project Lead

    20 hours ago


    CREATIVE PERSONNEL Ltd London, United Kingdom

    If you're an ambitious and experienced Project Manager or Project Lead with a clear and successful level of experience in performance marketing and data analytics, and you like the idea of working on the delivery of an innovative service for one of theretail sector major brands t ...


  • Houlihan Lokey London, United Kingdom

    Business Unit: · Information Technology · Industry: · No Industry · Overview · Houlihan Lokey (NYSE:HLI) is a global investment bank with expertise in mergers and acquisitions, capital markets, financial restructuring, and valuation. The firm serves corporations, institutions, an ...


  • Worley London, United Kingdom

    **Project Quality Lead** · **-** · **LON02XR** · **Company***: Worley · **Primary Location***: GBR-GL-London · **Other Locations***: GBR-SWE-Bristol, GBR-AC-Aberdeen, GBR-WY-Leeds, GBR-GC-Glasgow, GBR-NWE-Manchester, GBR-SOT-Stockton, GBR-LIN-Grimsby · **Job***: Quality Assurance ...


  • Jensen Hughes London, United Kingdom

    **Company Overview** · At Jensen Hughes, we lead with our Purpose + Principles and value our people. Across our global partnership of experts, clients, and communities, we are recognized worldwide for our leadership in fire protection engineering, a legacy of responsibility we ha ...


  • eFinancialCareers London, United Kingdom

    **About this role**: · Wells Fargo is seeking a Lead Project Manager · **In this role, you will**: · - Lead complex initiatives managing all activities in a project life-cycle such as initiation, planning, executing, controlling, and closing associated with projects that are long ...


  • EMR London, United Kingdom

    **Digital Project Lead** · Looking for a Digital Project Lead that can come on board and look after a new digital adtech supplier service innovation project and lead the commercial delivery for an award winning agency. · You would own the road map for the project and proactively ...


  • Board International London, United Kingdom

    At Board, we help enterprises plan smarter, drive outcomes and lead transformation with one single Intelligent Planning Platform. Trusted by thousands of leading organizations, over the last 28 years we have designed our Product with enterprise planning agility in mind and the pa ...

  • House of Lords

    Project Moves Lead

    4 days ago


    House of Lords London, United Kingdom

    **Details**: · **Reference number**: · **Salary**: · - £40,400 - £49,300**Job grade**: · - Other- HL7**Contract type**: · - Fixed Term**Length of employment**: · - This post is fixed term post until March 2025, with the possibility of extension.**Type of role**: · - Other**Workin ...


  • Mason Frank London, United Kingdom

    **Salesforce - Project Lead - Platinum Partner - Hybrid - London** · I'm currently working with a global cloud tech cosultancy who are one of the fastest growing consultancy in the ecosystem. This position would suit a Senior Consultant who wants to make the move to a Platinum Sa ...


  • Creative Personnel London, United Kingdom

    Location · London · - Sector: · Digital Marketing, Data Analytics, PPC, Programmatic · - Job type: · Contract · - Salary: · £ £65000 per annum · - Client: · Creative Personnel · - Contact: · Lanre Akanni · If you're an ambitious and experienced Project Manager or Project Lead wit ...


  • Medable London, United Kingdom

    Company Description · Medable's mission is to get effective therapies to patients faster. We provide an end-to-end, cloud-based platform with a flexible suite of tools that allows patients, healthcare providers, clinical research organizations and pharmaceutical sponsors to work ...