Senior Software Engineer, Reference Data Platform (Python/Oracle) - AVP

Role overview

Key responsibilities

• Develop Python backend services, ETL pipelines, and batch or real-time processing components.
• Design and optimize Oracle databases, SQL queries, PL/SQL packages, procedures, triggers, and views.
• Translate reference-data requirements into scalable technical implementations with partner teams.
• Tune software and database performance, including partitioning, indexing, and memory optimization.
• Follow engineering standards, TDD, automated testing, and code-review processes.
• Support CI/CD builds, deployments, and environment configuration.
• Troubleshoot production incidents and follow security, risk, and governance standards.
• Mentor junior developers and contribute to Agile/Scrum ceremonies and sprint planning.

Required qualifications

• 5–8 years of software engineering and application development experience delivering enterprise systems to production.
• Strong Python 3.x skills for application development, data manipulation, object-oriented design, and testing.
• Advanced Oracle, SQL, and PL/SQL skills, including schema design and database performance tuning.
• Knowledge of relational modeling, MDM, normalization, and large-scale data pipelines.
• Experience with Git, CI/CD, and automated testing frameworks such as pytest or unittest.
• Strong analytical, troubleshooting, problem-solving, and communication skills.
• Bachelor’s degree in a relevant field or equivalent relevant work experience.

Beneficial skills

• Financial-services experience with reference data, market data, instrument or counterparty data, or regulatory reporting is beneficial.
• Python web frameworks and API design, including FastAPI, Flask, or Django, are beneficial.
• Scheduling tools such as Autosys, Airflow, or Control-M and messaging systems such as Kafka or IBM MQ are beneficial.
• Containerization familiarity, including Docker, OpenShift, or Kubernetes, is beneficial.