Principal Application Specialist

3 weeks ago


Cambridge, Cambridgeshire, United Kingdom University of Cambridge Full time

The University of Cambridge ranks consistently amongst the foremost Universities in the world, and we recognise it is our people who have built our reputation. We will only maintain our leading position in the academic world by continuing to attract, develop, support, and retain the highest calibre of talented people.

The Finance department at the University enhances their E-Business reports with IBM Cognos Analytics reports. The reporting is provided by the University Information Systems department. The report analyst role is to support this reporting function, along with some interfaces to other bespoke systems. The role entails building and supporting bespoke Oracle DataMarts. The design of the DataMarts uses dimensional modelling, largely using ETL. Oracle PL/SQL is the predominant tool in building the DataMarts, but there is some ODI use, primarily for scheduling builds.

What you will be doing:

  • Design, develop and unit test improvements to the Extract, Transform and Load (ETL) processes.
  • Check overnight ETL, investigate and fix any failures.
  • Monitor performance and other operational aspects of the ETL and work with DBAs to resolve any issues or suggest enhancements.
  • Collaborate with the relevant systems helpdesks, investigate any incidents that are reported, resolve and advise users where appropriate.
  • Work as part of a multi-disciplinary team to review requirements, develop specifications and design effective solutions.
  • Producing new DataMarts.
  • Testing (including regression, integration, performance)
  • Supporting existing DataMarts (enhancing, monitoring, tuning, debugging)
  • Support for IBM Cognos Analytics report writers.
  • Introducing new IBM Cognos Analytics features.
  • Supporting software upgrades.

What you will bring:

  • Experience of ODI version or above.
  • In-depth knowledge of Oracle PL/SQL. In particular, the ability to analyse and quickly correct DataMart build issues.
  • A good understanding of DataMart design.
  • Able to create and maintain IBM Cognos Framework Manager models/packages.

It would be great if you had:

  • Knowledge of the Oracle EBS Financials 12.2
  • Experience using APEX
  • Ability to learn new skills independently and proactively and are constantly striving to raise technical excellence.
  • Debug complex problems effectively, including in new unexplored applications.
  • Drive and commitment to see activities through to completion meeting deadlines matching pace to the urgency of the situation.
  • Ensure that business requirements and processes are fully understood and clearly documented.

Applications are welcome from internal candidates who would like to apply for the role on the basis of a secondment from their current role in the University.

We welcome applications from individuals who wish to be considered for part-time working or other flexible working arrangements.

We particularly welcome applications from women and /or candidates from a BME background for this vacancy as they are currently under-represented at this level in our department.

To apply online for this vacancy and to view further information about the role, please click on the apply button above.

Please quote reference VC41600 on your application and in any correspondence about this vacancy.

The University actively supports equality, diversity and inclusion and encourages applications from all sections of society.

The University has a responsibility to ensure that all employees are eligible to live and work in the UK.

£45,585 to £57,696 per annum



  • Cambridge, Cambridgeshire, United Kingdom University of Cambridge Full time

    The University of Cambridge ranks consistently amongst the foremost Universities in the world, and we recognise it is our people who have built our reputation. We will only maintain our leading position in the academic world by continuing to attract, develop, support, and retain the highest calibre of talented people. The Finance department at the University...


  • Cambridge, Cambridgeshire, United Kingdom University of Cambridge Full time

    The University of Cambridge ranks consistently amongst the foremost Universities in the world, and we recognise it is our people who have built our reputation. We will only maintain our leading position in the academic world by continuing to attract, develop, support, and retain the highest calibre of talented people. The Finance department at the University...


  • Cambridge, Cambridgeshire, United Kingdom SMT Full time

    Application Specialist Duxford, CB22 4QX Full time Monday to Friday Are you a specialist on Microsoft Dynamics F&O and looking for the next step in your career? This is a new role in the business and as our SMT TEC Application Specialist, your focus will be on supporting our current implementation project of a global D365 F&O solution and being the go-to...

  • Principal Scientist

    7 days ago


    Cambridge, Cambridgeshire, United Kingdom TEC PARTNERS LIMITED Full time

    TEC partners are working with a rapidly growing company that provides instruments and specialist consumables for the global pharmaceutical and academic research community. Their novel single cell analysis systems can lead to a life-changing medicine.Based in Cambridge as Principal Scientist you will have the opportunity to develop technology that enables...


  • Cambridge, Cambridgeshire, United Kingdom Hays Specialist Recruitment Limited Full time

    Exciting Opportunity at a Cutting-Edge Engineering Consultancy Your New Company: This is a thrilling chance to join a forward-thinking engineering consultancy, specializing in mechanical, electrical, and sustainable building design. The team excels at working together, collaborating closely with clients in various sectors including education, commercial,...


  • Cambridge, Cambridgeshire, United Kingdom University of Cambridge Full time

    An exciting opportunity has arisen at the University for an experienced Senior Application Specialist to join the Student Systems team.Located within University Information Services (UIS), the Student Systems Technical team are responsible for the maintenance and development of the University's critical ERP systems for handling student data.Working on both...


  • Cambridge, Cambridgeshire, United Kingdom University of Cambridge Full time

    An exciting opportunity has arisen at the University for an experienced Senior Application Specialist to join the Student Systems team.Located within University Information Services (UIS), the Student Systems Technical team are responsible for the maintenance and development of the University's critical ERP systems for handling student data.Working on both...


  • Cambridge, Cambridgeshire, United Kingdom University of Cambridge Full time

    An exciting opportunity has arisen at the University for an experienced Senior Application Specialist to join the Student Systems team. Located within University Information Services (UIS), the Student Systems Technical team are responsible for the maintenance and development of the University's critical ERP systems for handling student data. Working on...


  • Cambridge, Cambridgeshire, United Kingdom IC Resources Full time

    A new opportunity has arisen for a Principal Analog IC Design Engineer to join an established global company working on world leading precision timing products at their new design centre in Cambridge. To further complement their growing Analog IC Design team, they are looking for a Principal Analog IC Designer with the skills and enthusiasm to significantly...


  • Cambridge, Cambridgeshire, United Kingdom Hays Specialist Recruitment Limited Full time

    Looking for a senior or principal mechanical design to be part of a dynamic teamYour new companyWith over 75 years of experience and around 16,000 experts, your new company operates in 35 countries and they are known for their deep local and insight experience and global knowledge. They are a multidisciplinary consultancy driven by sustainability...


  • Cambridge, Cambridgeshire, United Kingdom Hays Specialist Recruitment Limited Full time

    Principal Mechanical Design engineer with good consultancy background neededYour new companyYour new company is a highly experienced consultancy specialised in mechanical, electrical and sustainable areas of building design. They work close with education, commercial, conservation, hotels, sport and leisure, residential, healthcare, and communitysectors.They...


  • Cambridge, UK, Cambridgeshire, United Kingdom Cooper Lomaz Recruitment Full time

    Application SpecialistCambridgeshire£40,000 to £55,000Hybrid workingAre you an ambitious Application Specialist looking for the chance to join an established and highly respected Cambridge software company with an outstanding product and client portfolio? If yes, read on…. This is a new additional role, created due to the growth of the business across...


  • Cambridge, Cambridgeshire, United Kingdom Newton Colmore Consulting Full time

    Principal Mechanical Design Engineer - Medical Devices - Cambridge A growing Medical Devices team, based in Cambridge, is currently seeking an experienced Mechanical Design Engineer to lead the development of cutting-edge Medical Devices in the fields of Health Technology, Biotech, and Wearable Tech. The ideal candidate will have a proven track record...


  • Cambridge, Cambridgeshire, United Kingdom ENVEA Global Full time

    Application Specialist We are seeking a detail-oriented and technically proficient individual to join our team as an Application Specialist/Technical Officer. The successful candidate will play a key role in the sales process by providing accurate and timely technical quotations for our products and/or services. This position requires a strong...


  • Cambridge, Cambridgeshire, United Kingdom Singular Recruitment Full time

    As the selected Principal Hardware Engineer , you'll join a small, but expert team where you'll work on the design, development and validation of future communication products. Responsibilities for the role of Principal Hardware Engineer will include: Requirement specification and liaison with key stake holders throughout projects Design, development of...


  • Cambridge, Cambridgeshire, United Kingdom Newton Colmore Consulting Ltd Full time

    Principal Mechanical Design Engineer - Medical Devices - CambridgeA growing Medical Devices team, based in Cambridge, is currently looking for an experienced Mechanical Design Engineer to lead the development of new and industry advancing the Medical Devices, Health Technology, Biotech and Wearable Tech fields.We are looking for someone with a track record...


  • Cambridge, Cambridgeshire, United Kingdom VRS-UK Full time

    Exciting opportunity for an experienced Inorganic Chemist to join a world-leading environmental testing company.In this role, you will support the research and development of a variety of inorganic analytical techniques as required by the client and business. You will utilise a variety of instruments such as ICP-MS, ICP-OES & IC in a high-throughput,...


  • Cambridge, Cambridgeshire, United Kingdom Newton Colmore Consulting Ltd Full time

    Principal Mechanical Engineer - Biotech Robotics - Cambridge A spin-out Biotech company, based in Cambridge, is currently hiring several Principal Mechanical Engineers and Senior Mechanical Engineers to join them and help accelerate the proof of concept, design, development, building, and testing of a novel life-saving robotics biotech manufacturing device....


  • Cambridge, Cambridgeshire, United Kingdom Integrity Personnel Limited Full time £80,000 - £90,000

    Principal Analogue Power Electronics Engineer Demonstrable experience of leading and owning the design of electronic systems Solid electronics design experience in a development environment. Experience designing switching power supplies, buck, boost and flyback converters. Experience with microprocessor and microcontroller designs Experience in...


  • Cambridge, Cambridgeshire, United Kingdom Flagship Consulting Full time £50,000 - £65,000

    Principal/Associate Geotechnical Engineer Cambridge £50-65k DOE Our client has an excellent opportunity for an existing Principal Geotechnical Engineer looking for a new challenge with a successful ground investigation company, or for an experienced Senior Engineer looking for the next step and to move into a position of management in a growing company....