In this role, you will lead the assessment, design, build, and deployment of a replacement reporting framework for a legacy MS Access/VBA application. You will work across data layer engineering, OAS/BI Publisher builds, Python ETL/automation, and stakeholder engagement within a financial services / enterprise environment.
Key Responsibilities
Discovery & Assessment: Inventory legacy MS Access databases (.mdb/.accdb), linked tables, pass-through queries, macros, and VBA logic to define target-state architecture.
Oracle DB Engineering: Develop and tune complex Oracle SQL, PL/SQL, views, materialized views, and stored procedures. Analyze execution plans, AWR/ASH evidence, and TEMP/PGA usage for high-volume workloads.
OAS & BI Publisher: Build interactive OAS dashboards, analyses, and BI Publisher data models, layouts, bursting, and automated schedules.
Testing & Delivery: Conduct parallel runs, complete data reconciliation, establish rollback plans, and deliver production runbooks and team support handovers.
Required Experience & Skills
8+ years of Oracle DB development and SQL performance tuning.
5+ years in OAS / OBIEE and BI Publisher development.
5+ years in Python development for data extraction, transformation, and reporting automation.
3+ years migrating legacy Microsoft Access / VBA applications.
Strong experience in Financial Services or highly regulated enterprise environments preferred.
Experience with DevOps concepts, Git, CI/CD, and enterprise schedulers (e.g., Control-M, Autosys).
We use essential cookies to make this site work. With your permission we would also like to use the optional cookies below. Nothing optional is set until you choose, and you can change your mind at any time from "Cookie settings" at the bottom of every page. Cookie policy.
Essential — keep the site working and secure, and remember the choice you make here. Always on.