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.
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, materialised views, performance tuning, execution plans to rebuild report logic close to the data and optimise large workloads.
- OAS / OBIEE OAS dashboards, analyses, repository/subject area concepts, prompts, filters, security to deliver governed enterprise analytics and self-service reporting.
- BI Publisher Data models, RTF/Excel templates, bursting, scheduling, PDF/Excel/CSV outputs to replace scheduled Access reports and standardise 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.
#J-18808-Ljbffr
Senior Consultant / Lead Engineer / Solution Architect employer: LanceSoft UK
As an Event Producer at our London-based company, you will thrive in a dynamic and creative work environment that values innovation and collaboration. We offer a hybrid working model, allowing for flexibility while fostering strong partnerships with marketing and creative teams. With a commitment to employee growth, we provide opportunities for professional development and the chance to work on exciting projects that make a real impact in the events industry.
