Data Engineer

Job Description

• 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
20 days ago