Data Warehouse Manager

£50000 - £60000 per annum
image

PLEASE CONTACT

CARYS WILKES

JOB TITLE Data Warehouse Manager

DEPARTMENT Business Services

LOCATION Liverpool

REPORTING TO Head of Data Services

JOB TYPE Permanent

McGregor Boyall are exclusively partnered with one of the largest UK’s household names who are at the forefront of the legal industry. Our client has been recognised as one of the best company’s in this sector for many years and have enhanced their offering year on year to stay current. They are an impressive brand, a great technology driven business and the leading insurance risk and commercial law specialist.

They're seeking an experienced and passionate Data Warehouse Manager to provide support to the Head of Data Services. You must possess strong end to end SQL Server skills, notably analysis services, to support the team in the deployment of data cubes from the data warehouse. In addition to the development of analysis services objects, an understanding of integration services and reporting services is also important.

As the Data Warehouse Manager, you will be required to control, manage and develop the Data Warehouse including responsibility for future development strategies As well as to support implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.

You'll obviously have strong experience in a similar role delivering multiple development projects and have strong problem-solving and leadership skills, it is also necessary to have experience with the following:

  • Knowledge and experience of MDX
  • Knowledge and experience of DAX
  • Knowledge and experience of ETL tools e.g. Integration Builder, Integration Services
  • Good understanding of BI Best Practices/Methodologies, relational structures, dimensional data modelling, structured query language (SQL) skills, data warehouse and reporting techniques
  • Good knowledge of SQL Server 2016

This is a great opportunity to become a part of one of the largest organisations in this sector. The position offers incredible benefits Pension, flexible working, private medical insurance, Gym membership, childcare vouchers, season tickets and many more amazing benefits. In a desirable location, commutable from Liverpool, Preston, Chester, Manchester and other surrounding areas.

McGregor Boyall is acting as an Employment Agency in relation to this vacancy.

 

To stay safe in your job search we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organisation working to combat job scams. Visit the SAFERjobs website for information on common scams and to get free, expert advice for a safer job search.

MORE JOBS LIKE THIS
MORE JOBS LIKE THIS
  • Charles River Application Support Analyst- Permanent- London
    £60000 - £80000 per annum

    I am currently looking for a Charles River Application Support Analyst to join a top financial organisation based in London. The role will be a permanent role and will be working on a new project within the business.

    Responsibilities

    Front Office application support for tier 1 business critical systems with escalation to software development, technology teams, end users or third parties as appropriate.

    Setup and training users on use of Front Office systems.

    Record and take ownership of issues using internal Jira system and following through to successful resolution.

    Monitor trades and booking issues – advise traders and desk assistants.

    FIX troubleshooting.

    Key Requirements

    Experienced Application Support Analyst

    Knowledge of the Charles River IMS system

    Experience supporting other Order Management (OMS) and Execution Management (EMS) systems (such as Thinkfolio, Portware, Fidessa, Trading Screen, etc) is also desirable

    Some basic knowledge of FIX protocols is essential

    Experience working with the Front Office – i.e. Traders and Portfolio managers – and understanding the urgency in resolving issues

    Understanding of Windows Operating Systems and Databases – Oracle & SQL Server

    Experience writing SQL queries for Oracle and Microsoft SQL databases.

    Permanent

    Location: London

    £60,000- £80,000 (plus benefits)

    If you feel like you are a strong match for my requirements, please send me over an updated copy of CV and I will get back in touch.

    Many thanks,

    Connor

    McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.

  • Production Support Lead (FIX/ UNIX)- Fixed Income- Permanent
    £80000 - £110000 per annum

    I am currently looking for an experienced Production Support Lead (FIX/ UNIX) to join a top financial organisation based in London. The role will be a permanent role and will be working on a new project within the business.

    The responsibilities of the role include:

    Provide 2nd line support services for client services and account management teams

    Support external users of the API (XML/FIX/SOAP) interfaces

    Provide networking and connectivity support

    Monitoring system servers and ensuring appropriate monitoring is in place

    Raise and track issues through the use of the helpdesk ticketing mechanism

    Answer hotline calls in a professional manner

    Participate in global support meetings as requested

    Candidates must have:

    Experienced Application Support Lead (hands on)

    Demonstrable experience in a combined managerial and technical capacity

    UNIX, SQL, XML, FIX and Scripting Language a must

    Strong knowledge around asset classes- Fixed Income/ FX/ Equities

    Managing staff (required), either in a direct or matrix management environment

    Proven thought leadership in process automation with demonstrable implementation skills

    ITIL knowledge desirable

    Good understanding of networking fundamentals. Understanding of LAN & WAN topologies &

    Permanent

    Location: London

    £80,000- £110,000

    If you feel like you are a strong match for my requirements, please send me over an updated copy of CV and I will get back in touch.

    Many thanks,

    Connor

    McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.

  • Infrastructure Recruitment Consultant
    £23000 - £35000 per annum + Commission

    Infrastructure Recruitment Consultant

    Overview of Role

    We are looking for a Recruitment Consultant to join our growing Technical SME team, specifically focussing on Infrastructure and to help strengthen our recruitment capability within Financial Services.

    The Technical SME team has a well established presence in the London Financial Services recruitment market therefore providing an existing client base to actively recruit for and to develop business with. When i say this is a Warm Desk I mean that we recieve a high volume of roles through from clients that we actively place with on a regular basis.

    As a Senior Recruitment Consultant you will take responsibility for delivery in to our existing accounts, managing the full recruitment life-cycle process and account management/development.

    Key Responsibilities

    To develop and build a dual (contract and perm) recruitment desk within Infrastructure

    • Managing and delivering full life cycle recruitment across your own roles
    • Focus on active account management across our Financial Services clients, ensuring we identify and meet with existing and new Hiring Managers and get heads up on roles being released
    • Assisting with the client management and candidate delivery on existing accounts
    • Other business development activities to include, generating and following up on leads, developing sponsors/coaches within accounts
    • Growing and establishing a candidate database
    • Delivering to set financial and performance targets

    Key experience/skills

    Previous experience of working in a 360 degree IT recruitment role

    • A background/knowledge of Financial Services is desirable
    • Excellent client and candidate management skills, along with the ability to build strong relationships
    • Recruitment delivery experience
    • Proven ability to meet and exceed financial sales targets

    McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.