Design, develop, and maintain PostgreSQL databases, ensuring high performance, reliability, and data integrity
Implement and manage Change Data Capture (CDC) solutions to efficiently capture and process real-time data changes
Optimize Python, PostgreSQL code for efficiency, scalability, and readability, following best practices and industry standards
Gain an understanding of and contribute to the machine learning efforts of the firm
Understand financial research processes/objectives and utilize technology to support them
Implement robust testing methodologies to ensure program logic correctness and data integrity
Work in an agile, collaborative environment with data engineers, data scientists, and financial analysts
Minimum Qualifications
Bachelor's degree in Computer Science, Engineering, Mathematics or related field from an accredited college/university
3+ years of hands-on development experience with Python for data engineering
3+ years of experience with SQL, with a strong preference for PostgreSQL experience
Proven track record of optimizing Python and PostgreSQL code for efficiency, scalability, and readability
Experience with implementing robust testing methodologies to ensure program logic correctness and data integrity
Knowledge of database best practices, including security, architecture, data governance, and optimization
Understanding of Git and database version control
Preferred Qualifications
Strong track record of developing clean, performant, and maintainable code in Python and PostgreSQL
Deep knowledge of database best practices, including security, architecture, data governance, optimization, and seamless integration with Python codebases
Extensive experience designing and implementing scalable, fault-tolerant ETL pipelines using Python and PostgreSQL
Hands-on experience with Change Data Capture (CDC) solutions and their implementation in real-world scenarios
Proven capability to work independently, take ownership of projects, and drive initiatives from concept to completion
Ability to effectively communicate complex technical concepts to both technical and non-technical stakeholders
Experience working in the financial industry or with financial research processes is a plus
Passion for staying up-to-date with the latest trends and best practices in data engineering, machine learning, and related technologies, including proficiency with tools like dbt