LanceSoft UK
Senior Consultant / Lead Engineer / Solution Architect
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Job Title: Senior Consultant / Lead Engineer / Solution Architect
Location: London, UK
Duration: 12 Months+ Extendable contract
Job Description
Lead Oracle Analytics, Python & Access Reporting Modernisation Architect
Role purpose: End-to-end migration of Microsoft Access + Oracle reporting into OAS, BI Publisher, and/or Python automation.
Primary Platforms: Oracle DB, OAS, BI Publisher, Python
Legacy Platform: Microsoft Access / VBA / Macros
Experience Profile
- 8+ years of Oracle database development and SQL performance tuning experience.
- 5+ years of OAS/OBIEE and BI Publisher development experience.
- 5+ years of Python development for data/reporting automation.
- 3+ years of Microsoft Access/VBA migration or legacy reporting modernisation experience.
- Experience working in financial services or another controlled enterprise environment is strongly preferred.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Required Skills
Microsoft Access
- Databases linked Oracle tables, pass-through queries, macros, VBA, forms, and reports to reverse engineer the existing application accurately.
Oracle Database
- Oracle SQL, PL/SQL, views, materialized views, performance tuning, execution plans to rebuild report logic close to the data and optimize large workloads.
OAS / OBIEE
- OAS dashboards, analyses, repository/subject area concepts, prompts, filters, security to deliver governed enterprise analytics and self-service reporting.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
BI Publisher
- Data models, RTF/Excel templates, bursting, scheduling, PDF/Excel/CSV outputs to replace scheduled Access reports and standardize enterprise output.
Python
- Python 3.x, pandas, oracledb/cx_Oracle, SQLAlchemy, openpyxl, XlsxWriter, logging frameworks to replace macros, automate extraction/transformation, and generate report packs.
DevOps & Release
- Git, Azure DevOps/GitHub, CI/CD concepts, deployment documentation, environment management to make the solution maintainable rather than desktop dependent.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Location