Data Engineer

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