LanceSoft UK

Job Title: Senior Consultant / Lead Engineer / Solution Architect
Location: London, UK
Duration: 12 Months+ Extendable contract
Job Description
<ul>
<li>Lead Oracle Analytics, Python &amp; Access Reporting Modernisation Architect</li>
<li>Role purpose: end-to-end migration of Microsoft Access + Oracle reporting into OAS, BI Publisher and/or Python automation.</li>
<li>Primary Platforms Oracle DB, OAS, BI Publisher, Python Legacy Platform Microsoft Access / VBA / Macros</li>
</ul>
Experience Profile
<ul>
<li>8+ years of Oracle database development and SQL performance tuning experience.</li>
<li>5+ years of OAS/OBIEE and BI Publisher development experience.</li>
<li>5+ years of Python development for data/reporting automation.</li>
<li>3+ years of Microsoft Access/VBA migration or legacy reporting modernisation experience.</li>
<li>Experience working in financial services or another controlled enterprise environment is strongly preferred.</li>
</ul>
Required Skills
<ul>
<li>Microsoft Access databases linked Oracle tables, pass-through queries, macros, VBA, forms and reports to reverse engineer the existing application accurately.</li>
<li>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.</li>
<li>OAS / OBIEE OAS dashboards, analyses, repository/subject area concepts, prompts, filters, security to deliver governed enterprise analytics and self-service reporting.</li>
<li>BI Publisher Data models, RTF/Excel templates, bursting, scheduling, PDF/Excel/CSV outputs to replace scheduled Access reports and standardise enterprise output.</li>
<li>Python Python 3.x, pandas, oracledb/cx_Oracle, SQLAlchemy, openpyxl, XlsxWriter, logging frameworks to replace macros, automate extraction/transformation and generate report packs.</li>
<li>DevOps &amp; Release Git, Azure DevOps/GitHub, CI/CD concepts, deployment documentation, environment management To make the solution maintainable rather than desktop dependent.</li>
</ul>

Senior Consultant / Lead Engineer / Solution Architect

Senior Consultant / Lead Engineer / Solution Architect

This job is no longer available

Talents

Recruiters

About