At a Glance
- Tasks: Design and develop Oracle APEX applications while managing data pipelines.
- Company: Join Pearson, a leader in lifelong learning with a vibrant culture.
- Benefits: Enjoy 25 days annual leave, flexible working, and a generous pension scheme.
- Other info: Hybrid work model with excellent career growth opportunities.
- Why this job: Make a real impact on education through innovative tech solutions.
- Qualifications: Experience in Oracle development and strong SQL skills required.
The predicted salary is between 63000 - 77000 £ per year.
This role aligns with positions typically advertised in the external market as Oracle APEX Developer, Oracle Developer or Oracle PL/SQL Developer.
About Pearson: At Pearson we add life to a lifetime of learning so everyone can realise the life they imagine. We do this by creating vibrant and enriching learning experiences designed for real-life impact. Our Purpose is to add life to a lifetime of learning. Pearson was founded in 1844 and has been built on our ability to grow with and adapt to a constantly evolving market. Our 20,000+ employees are dedicated to creating high-quality, digital-first, accessible and sustainable resources for lifelong learning.
About the Job: We are looking for an Oracle Engineer to join the team delivering our TOpS programme. You will design, build and support Oracle database solutions and Oracle APEX applications, and own the data pipelines that ingest, transform and validate data from multiple internal and external sources. Data quality sits at the heart of this role: the information you manage underpins operational decisions and reporting, so accuracy, traceability and reliability matter. The role involves working closely with business SMEs, product owners, architects, QA engineers, and fellow developers, so excellent communication and analysis skills are essential. You will also be expected to explain technical designs and decisions clearly to non-technical colleagues.
Key Responsibilities:
- Design, develop and maintain Oracle APEX applications, from data model through to user interface, security and deployment.
- Write and optimise high-quality SQL and PL/SQL, including packages, procedures, functions and triggers that support business applications.
- Build, schedule and monitor data pipelines (ETL/ELT) that load, transform and reconcile data between Oracle and other systems.
- Implement data validation rules, reconciliation checks and exception handling so that data issues are caught early and resolved at source.
- Tune the performance of queries, pipelines and APEX pages, using execution plans, indexing and partitioning strategies.
- Contribute to code reviews, automated testing, CI/CD and technical documentation.
- Support live services by investigating and resolving incidents and data defects.
About You:
This role would suit someone with a solid background in Oracle development who has built and supported Oracle APEX applications in a commercial setting, and who has worked on data transformation or integration projects. You will be curious about data and its value, take pride in getting it right, and enjoy working on fast-moving, business-critical projects where you can contribute to design decisions.
Key Skills & Experience:
- Oracle Database, SQL and PL/SQL
- Strong hands-on experience with Oracle Database (19c or later).
- Expert SQL and PL/SQL, including packages, bulk processing (BULK COLLECT/FORALL), dynamic SQL, collections and robust exception handling.
- Relational data modelling and normalisation, with an understanding of dimensional/data warehouse design.
- Performance tuning using execution plans, indexing, partitioning, and Oracle diagnostic tools.
Oracle APEX:
- Commercial experience designing, building and supporting Oracle APEX applications on recent releases.
- Confident use of interactive reports and grids, forms, faceted search, dynamic actions, processes, validations and shared components.
- Implementing authentication and authorisation schemes, role-based access and APEX security good practice (e.g. session state protection, preventing SQL injection and XSS).
- Building and consuming REST services using Oracle REST Data Services (ORDS) and APEX REST Data Sources.
- JavaScript, HTML and CSS for customising the APEX user interface; experience with APEX plug-ins is an advantage.
- Managing the APEX application lifecycle: exports, supporting objects, promotion between environments and source control.
Data Pipelines and Transformation:
- Designing and building ETL/ELT pipelines, including staging, transformation, incremental loading and Change Data Capture (CDC) concepts.
- Scheduling and orchestration with DBMS SCHEDULER, and loading data using external tables, SQL Loader, Data Pump or DBMS_CLOUD.
- Integrating data from files (CSV, JSON, XML) and APIs from multiple internal and external sources.
- Implementing pipeline monitoring, logging, and alerting to identify and address issues proactively.
Data Quality:
- Designing and implementing data validation rules, constraints and reconciliation checks between source and target.
- Data profiling, cleansing and de-duplication, with clear handling and reporting of rejected or exception records (e.g. DML error logging).
- Understanding of data lineage, auditability and data protection obligations (UK GDPR) when handling personal or sensitive data.
Engineering Practice:
- Version control for database and APEX code using Git (Bitbucket).
- CI/CD for database change, using tools such as SQLcl, Liquibase or similar.
- Automated testing design and set-up, including PL/SQL unit testing (e.g. utPLSQL).
- Jira, Kanban boards and agile delivery methods.
- Excellent organisational, communication and planning skills; proactive and self-motivated.
Desirable Skills & Experience:
- Oracle integration and data quality tools such as Oracle Data Integrator (ODI), OCI Data Integration or Oracle Enterprise Data Quality.
- Oracle Cloud Infrastructure (OCI) or Autonomous Database, and/or Oracle on AWS (e.g. Amazon RDS for Oracle, AWS DMS, S3).
- Awareness of recent APEX capabilities, such as APEXlang file-based development, SQL Developer for VS Code and AI-assisted features.
- Relevant Oracle certification (e.g. Oracle APEX Cloud Developer Professional or Oracle Database SQL Certified Associate).
- Python or shell scripting for automation.
- Reporting and analytics tools such as Power BI or Oracle Analytics.
- Experience in education, assessment or another regulated, high-stakes delivery environment.
- Jira and Confluence, Microsoft Teams and other Microsoft Office applications.
Job Location and Hours:
The role is aligned to our Manchester, Rotherham, or London offices. Our Rotherham office is located at Junction 1 of the M18. All our roles are hybrid working; our current policy requires our team to visit their base office no more than once a week, and with the possibility of occasional business travel to other Pearson sites. Candidates must be a suitable commute from their base office as our office presence policy may change to require more frequent presence in the future. We work a 37.5-hour week, with all our team free to flex their day around our core hours, which are Monday to Friday, 10 to 4 GMT/BST. School runs, etc. can be accommodated. Other flexible working patterns can be considered, including part-time working and non-traditional hours.
Your benefits and rewards:
Here at Pearson we offer a range of benefits, which include:
- 25 days annual leave (increasing by 1 day with every year of continuous service up to 30 days)
- Private pension plan scheme where we pay in double what you contribute, up to 16% depending on your age
- Life, private medical and dental care insurance options, plus free eye tests
- Stock/share purchase options
- Maternity, paternity, and family care leave as well as flexible working policies
- An employee wellbeing assistance programme
- Cycle to work programme, volunteering days, gym membership concessions in selected office locations, along with retail and leisure discounts
Who we are:
At Pearson, our purpose is simple: to help people realise the life they imagine through learning. We believe that every learning opportunity is a chance for a personal breakthrough. We are the world's lifelong learning company. For us, learning isn't just what we do. It's who we are.
Software Engineer III in Manchester employer: Pearson
Pearson Edexcel is an excellent employer that values the expertise of its staff, offering a flexible ad-hoc role that allows for a balanced work-life dynamic. With a strong commitment to professional development, employees have access to resources and training that enhance their skills while contributing to the educational success of students in the North East. The supportive work culture fosters collaboration and innovation, making it a rewarding environment for those passionate about education.
StudySmarter Expert Advice🤫
We think this is how you could land Software Engineer III in Manchester
✨Join Local Tech Meetups
Get out there and mingle with fellow developers by joining local tech meetups. It’s a fantastic way to meet people who might be working at Pearson or know someone who does. Plus, you can pick up some trendy tech skills and trends while you're at it!
✨Contribute to Open Source Projects
Show off your coding chops by jumping into open-source projects. Not only does this give you practical experience, but it also gets you noticed in the dev community. You'll create a killer portfolio that speaks volumes about your skills to Pearson.
✨Tap into Online Developer Communities
Don’t underestimate the power of online developer communities like GitHub, Stack Overflow, and even Reddit. Participate in discussions, share your projects, and build your visibility. We can often find opportunities through these channels that can lead to a full-time gig at companies like Pearson.
✨Explore Job Boards Specifically for Tech Roles
Keep your eyes peeled on job boards that focus on tech roles. Sites like TechCareers or Stack Overflow Jobs can often have listings for companies like Pearson that might not show up on broader job sites. Make it a habit to check these regularly, and don’t hesitate to apply directly through our website!
We think you need these skills to ace Software Engineer III in Manchester
Some tips for your application 🫡
Show off your coding skills:When applying for a software engineering role, it's super important to showcase your coding skills. Make sure your CV includes your tech stack, any relevant programming languages you’re comfortable with, and examples of projects you've worked on. If you have a GitHub profile, link it up! We love to see code in action.
Tailor your portfolio:For a full-time role, we’d expect to see some solid examples of your work in your portfolio. Make sure to include at least two or three projects that highlight your problem-solving skills and your ability to work with different technologies. Focus on the projects that are most relevant to the position at Pearson.
Craft a killer cover letter:Your cover letter is your chance to stand out—make it personal! Explain why you want to work at Pearson and how your skills align with the role. Show us your passion for software development. We dig enthusiastic candidates who understand the value of collaboration and continuous learning!
Be clear and concise:When it comes to writing your CV and cover letter, clarity is key. Avoid jargon that could confuse us and stick to simple, direct language. Highlight your achievements with quantifiable results where possible, and keep everything easy to read. A well-organised application goes a long way!
How to prepare for a job interview at Pearson
✨Brush Up on Your Coding Skills
For a full-time software engineering role, it's crucial that we stay sharp with our coding abilities. Expect technical questions that might involve solving problems on the spot or discussing algorithms. Practise on platforms like LeetCode or HackerRank to get comfortable with the types of questions that often come up.
✨Know Your Tools and Frameworks
Make sure we’re well-acquainted with the tools and technologies listed in the job description. Familiarise ourselves with any specific frameworks or programming languages mentioned. If Pearson uses React or Node.js, for instance, be ready to discuss how we’ve used them in previous projects or coursework.
✨Showcase Your Projects
Bring along a portfolio that highlights our best work. This could be code samples, GitHub repositories, or any side projects we’ve built. Make sure we can talk through our thought process for each project, especially the challenges we faced and how we solved them—this shows our problem-solving skills in action.
✨Prepare for Behavioural Questions
While technical skills are key, full-time positions also require cultural fit. Be ready to discuss our previous experiences and how we handle teamwork, conflict, and deadlines. Brush up on the STAR method—Situation, Task, Action, Result—to clearly articulate our past experiences when discussing how we've contributed to a team.