Design, develop, and optimize complex SQL queries, stored procedures, and data models for Oracle-based systems
- Create and maintain efficient data pipelines for extract, transform, and load (ETL) processes
- Design and implement data quality controls and validation processes to ensure data integrity
- Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications
- Establish documentation standards and ensure comprehensive system documentation
- Lead troubleshooting efforts and resolve complex database performance issues
- Design and implement integrations between Oracle systems and cloud services, particularly AWS S3
- Lead code reviews and establish best practices for database development
- Design and implement data migration strategies from legacy systems to modern cloud-based solutions
- Work within an Agile framework, taking a leadership role in sprint planning and technical discussions
About you
Required Qualifications:
- 5-10 years of experience with Oracle databases, including advanced SQL and PL/SQL development
- Strong knowledge of data modelling principles and database design patterns
- Proficiency with Python for data processing and automation
- Extensive experience implementing and maintaining data quality controls
- Proven ability to reverse engineer existing database schemas and understand complex data relationships
- Strong experience with version control systems, preferably Git/GitHub
- Excellent written communication skills for technical documentation
- Demonstrated ability to work within and help guide Agile development methodologies
- Strong knowledge of investment management industry concepts, particularly security reference data, fund reference data, transactions, orders, holdings, and fund accounting
Additional Qualifications:
- Knowledge of SQL Server development
- Experience with ETL tools like Informatica and Control-M
- Unix shell scripting skills for data processing
- Experience with CI/CD pipelines for database code
- Familiarity with AWS services, particularly S3, Lambda, and Step Functions
- Knowledge of database security best practices
- Experience with data visualization tools (Tableau, Power BI)
- Experience mentoring junior developersRole & responsibilities