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

#J-18808-Ljbffr

  • Application Specialist

    3 weeks ago

    Cambridge, Cambridgeshire, United Kingdom SMT GB 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...

  • Application Specialist

    1 day ago

    Cambridge, Cambridgeshire, United Kingdom SMT GB Full time

    Application SpecialistDuxford, CB22 4QXFull time Monday to FridayAre 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 person...

  • Application Specialist

    3 weeks ago

    Cambridge, Cambridgeshire, United Kingdom SMT GB 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 Applications Engineer

    4 weeks ago

    Cambridge, Cambridgeshire, United Kingdom PragmatIC Semiconductor Full time

    Overview As Principal Application Engineer, you will be responsible for ensuring both internal and external customer success as the key technical stakeholder, translating application needs and requirements into technical specifications. Collaborating with our Engineering, Product Management and Commercial teams you will be responsible for technical...

  • Principal Designer

    2 days ago

    Cambridge, Cambridgeshire, United Kingdom Bennett and Game Recruitment LTD Full time

    Our client a well-established and growing specialist and multi-disciplined surveying consultancy who are looking for a Principal Designer to join their growing team on a hybrid/remote basis in Cambridge. The Principal Designer will be operating as a key member of the team as they will be the main contact between clients, designers and contractors in...

  • Principal Designer

    2 days ago

    Cambridge, Cambridgeshire, United Kingdom Bennett and Game Recruitment LTD Full time

    Our client a well-established and growing specialist and multi-disciplined surveying consultancy who are looking for a Principal Designer to join their growing team on a hybrid/remote basis in Cambridge. The Principal Designer will be operating as a key member of the team as they will be the main contact between clients, designers and contractors in...

  • Principal Designer

    1 week ago

    Cambridge, Cambridgeshire, United Kingdom Bennett and Game Recruitment LTD Full time €40,000 - €60,000

    Our client a well-established and growing specialist and multi-disciplined surveying consultancy who are looking for a Principal Designer to join their growing team on a hybrid/remote basis in Cambridge. The Principal Designer will be operating as a key member of the team as they will be the main contact between clients, designers and contractors in regards...

  • Principal Designer

    1 week ago

    Cambridge, Cambridgeshire, United Kingdom Bennett and Game Recruitment LTD Full time €40,000 - €60,000

    Our client a well-established and growing specialist and multi-disciplined surveying consultancy who are looking for a Principal Designer to join their growing team on a hybrid/remote basis in Cambridge. The Principal Designer will be operating as a key member of the team as they will be the main contact between clients, designers and contractors in regards...

  • Principal Application Software Engineer

    5 days ago

    Cambridge, Cambridgeshire, United Kingdom Adecco Full time

    Principal Application Software Engineer - SDLC, Degree, Node.js, £depending on experience + benefits, Cambridge / Hybrid My client is a pioneering machine learning and artificial intelligence software house, they have developed some of the most advanced technologies, following this they are now highly regarded throughout the UK within the artificial...

  • Senior Application Specialist

    2 weeks ago

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

  • Application Specialist

    3 weeks ago

    Cambridge, United Kingdom SMT GB Full time

    Application SpecialistDuxford, CB22 4QXFull time Monday to FridayAre 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 person...

  • Application Specialist

    3 weeks ago

    Cambridge, United Kingdom SMT GB Full time

    Application SpecialistDuxford, CB22 4QXFull time Monday to FridayAre 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 person...

  • Application Specialist

    3 weeks ago

    Cambridge, United Kingdom SMT GB Full time

    Application SpecialistDuxford, CB22 4QXFull time Monday to FridayAre 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 person...

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

  • Principal Application Specialist

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

  • Application Specialist

    2 weeks ago

    Cambridge, 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 Analog IC Design Engineer

    1 month ago

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

  • Field Application Specialist

    1 day ago

    Cambridge, Cambridgeshire, United Kingdom Invenia Group Full time

    Invenia is working with a growing manufacturer of scientific instrumentation to hire multiple Field Application Specialists in Europe due to internal moves and promotions. Ensure you read the information regarding this opportunity thoroughly before making an application. The company manufactures a platform that helps advance cell-based research and...

  • Principal Applications Software engineer

    5 days ago

    Cambridge, Cambridgeshire, United Kingdom Adecco Full time

    Principal Application Software Engineer - SDLC, Degree, Node.js, £depending on experience + benefits, Cambridge / Hybrid My client is a pioneering machine learning and artificial intelligence software house, they have developed some of the most advanced technologies, following this they are now highly regarded throughout the UK within the artificial...

  • Principal / Senior Power Electronics Engineer

    2 weeks ago

    Cambridge, Cambridgeshire, United Kingdom Integrity Personnel Limited Full time

    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 in designing digital interfaces and buses USB2, SPI, I2C, GPIO etc Design for Manufacturing and Test Unique opportunity for a Principal Analogue...