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.



  • 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

    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 Platform Recruitment Full time

    Cambridge – Principal Embedded Software Engineer- Competitive salaryIf your skills, experience, and qualifications match those in this job overview, do not delay your application.My Client is a biotech company who is looking for a Principal Embedded Software engineer to join their growing teamMain Duties:Work within a multidisciplinary teamPlan, deliver...


  • Cambridge, Cambridgeshire, United Kingdom IC Resources Full time

    A new opportunity has arisen for a Principal Analog IC Design Engineer with experience in AMS Verification capabilities 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...


  • Cambridge, Cambridgeshire, United Kingdom Frontier Developments plc Full time

    WHAT'S THE ROLE? We're seeking a new Principal addition to our Build & DevOps team In this role you will support all the game teams at Frontier, using our CI/CD and other infrastructure systems. As a Principal you'll iterate on and upgrade the various systems and infrastructure that we have in place. You will help us improve our tech stack by integrating...


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

    The Faculty of Divinity is seeking an organised, efficient and accurate person with excellent interpersonal skills for the post of Principal Secretary to cover the role holder while she is on secondment from 1 July to 28 February 2025. Your varied duties will include running examinations, servicing committees, assisting with the administration for...


  • Cambridge, Cambridgeshire, United Kingdom Microsoft Games Full time

    For our Microsoft Research Cambridge, UK, location, we are seeking Principal Researcher (equivalent to Director level/(US) tenured associate professor) candidates in the area of Machine Learning for Gaming and AI. We encourage applications from all candidates who are excited to tackle challenges that arise in applications of machine learning approaches to...


  • Cambridge, Cambridgeshire, United Kingdom IC Resources Full time

    This is an opportunity for an ambitious Prinicpal Analog IC Designer to join a growing start up company based in the UK's technology hub of Cambridge. This position would suit a Principal Analog IC Design engineer with an excellent understanding of the IC Design process in CMOS technology and with a systematic and proactive approach to design.Industry degree...


  • Cambridge, Cambridgeshire, United Kingdom Frontier Developments plc Full time

    Frontier is an independent video game developer and publisher, crafting immersive gaming experiences with fun gameplay and unparalleled artistic quality. Renowned for its iconic creative management simulation games, Frontier captivates players worldwide with immersive and authentic game worlds. The modern studio is located in the vibrant technology hub of...


  • Cambridge, Cambridgeshire, United Kingdom Noble Legal Limited Full time

    A leading Cambridge firm is looking to hire a senior/principal construction associate, with a focus on non-contentious matters. The team has a market-leading reputation, working with high-level clients including central government departments, life science developers and educational institutions. Much of the work is high-profile, and you will benefit from...


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

    Fixed-term: The funds for this post are available for 4 years in the first instance.The University of Cambridge Open Zettascale Lab (COZL) is a new research group whose aim is to evolve and utilise the technologies that will make up the next generation of top-flight supercomputers. These state-of-the-art, post-exascale systems will help gain insights into...


  • Cambridge, Cambridgeshire, United Kingdom Pilgrim Pathways School Full time

    Post: Primary/ lower KS3 specialist teacher Salary: MPS 1-6 pro rata (dependent on experience)Location: Pilgrim Pathways school, principally across 2 sites: Ida Darwin, Fulbourn and Addenbrooke's Hospital, Cambridge Start Date: September2024Hours: 0.6 across either 3 or 4 days (to be discussed at interview)Contract: PermanentReports to: HeadteacherThis is...

  • Microscopy Specialist

    1 month ago


    Cambridge, Cambridgeshire, United Kingdom University of Cambridge Full time

    The CRUK Cambridge Institute's (CRUK CI) scientific Core Facilities perform a fundamental role at the heart of our research community. They are a repository for deep knowledge and expertise in scientific technologies and techniques and work in partnership with the Institute's research groups in answering biological questions related to cancer.The Light...


  • Cambridge, Cambridgeshire, United Kingdom ARM Full time

    We are looking for an experienced principal board design engineer to join Arm's Hardware Platform team. As part of the Solutions Engineering Group, the team is based in Cambridge, UK, working at the forefront of embedded design focusing on prototyping Arm's latest IP products. We develop physical hardware development platforms, based around Arm's custom...

  • Sales Specialist

    1 month ago


    Cambridge, Cambridgeshire, United Kingdom Green Recruitment Company Full time

    ​Job title: Sales SpecialistLocation: Cambridgeshire, England, United Kingdom (Hybrid)We have a new role for a Sales Specialist working with a UK Cleantech Market to create a sustainable future.The Green Recruitment Company are delighted to have exclusively partnered with a forward-thinking cleantech innovator on their journey to revolutionising global...


  • Cambridge, Cambridgeshire, United Kingdom Select Full time

    Are you passionate about shaping the future of urban and regional landscapes? Does the idea of playing a critical role in sustainable development and strategic planning in one of the UK's most dynamic areas excite you? If you're nodding in agreement, a unique opportunity awaits you with my client.My client is in search of a Planner/Specialist with a fervor...

  • IT Specialist

    1 month ago


    Cambridge, Cambridgeshire, United Kingdom University of Cambridge Full time

    Are you looking for an exciting IT role with an inspiring, world-leading organisation? Do you want to contribute to our mission to educate and develop scientific understanding of the Earth, our environment, and planetary systems?The Department of Earth Sciences is looking for an enthusiastic and experienced IT Specialist to join our IT team to help support...


  • Cambridge, UK, Cambridgeshire, United Kingdom Northreach Full time

    Northreach is a dynamic recruitment agency that connects businesses with top talent in the Advanced Therapies sector. Our mission is to provide a seamless and personalised recruitment experience for clients and candidates, and to create a positive work environment that encourages equality, innovation, and professional growth.About UsWe believe that ageing,...


  • Cambridge, Cambridgeshire, United Kingdom Frontier Developments plc Full time

    Frontier is an independent video game developer and publisher, crafting immersive gaming experiences with fun gameplay and unparalleled artistic quality. Renowned for its iconic creative management simulation games, Frontier captivates players worldwide with immersive and authentic game worlds. The modern studio is located in the vibrant technology hub of...


  • Cambridge, Cambridgeshire, United Kingdom Pertemps Education Network Full time

    Are you an experienced Learning Support Practitioner, 1:1 Support Specialist, or SEN Teaching Assistant? Are you an individual with a knowledge & interest in Autism & Complex Needs within an Educational setting?Pertemps Education are currently working in partnership with an outstanding specialist SEN school based just out of Haverhill. This school is a...