Data Engineer - Investment Technology (Python)

Software Guidance & Assistance, Inc. (SGA) is searching for a Senior Data Engineer - Investment Technology (Python) for a Direct Hire assignment with one of our premier Financial Services clients in Lower Manhattan, NYC . This is a hybrid role requiring onsite presence 4 days per week . Responsibilities

• Build and maintain production data pipelines ingesting data from internal systems, market data vendors, and operational databases into analytical and application-facing data stores.
• Design and manage PostgreSQL and analytical data models supporting front-office investment workflows and quantitative research.
• Develop production-quality Python and SQL code for ETL, data validation, enrichment, transformation, and data quality monitoring.
• Build and maintain lightweight internal applications, reporting interfaces, and browser-based tools using JavaScript where appropriate.
• Support research and analytics workflows involving large financial, transactional, market, and time-series datasets.
• Partner closely with quantitative developers, engineers, portfolio management, trading, research, and other investment users to improve data usability and transparency.
• Identify and resolve data quality and operational issues while improving the reliability and scalability of the overall data platform.
• Apply strong software engineering practices around testing, debugging, code quality, documentation, and production support.

• 4+ years of experience in Data Engineering, Analytics Engineering, or Software Engineering with a strong data engineering focus.
• Strong hands-on Python development experience in production environments.
• Strong SQL skills and experience working with relational databases.
• Hands-on experience designing, developing, and supporting production ETL/data pipelines .
• Experience designing and maintaining relational and/or analytical data models .
• Experience working with large and complex datasets.
• Strong software engineering fundamentals including testing, debugging, code quality, and documentation.
• Strong analytical and problem-solving skills.
• Ability to work closely with technical and business stakeholders in an investment-facing environment.

Preferred Skills

• Experience with PostgreSQL and/or Snowflake .
• Experience working with financial, investment, transactional, market, or time-series data .
• Investment Management, Asset Management, Fixed Income, Trading, Portfolio Management, or Quantitative Research experience.
• Experience with AWS and cloud-based data infrastructure.
• Experience with dbt, Docker, Kubernetes/EKS, Kafka, and/or Redis .
• JavaScript experience developing internal tools, dashboards, or data-grid-based interfaces.
• Experience supporting front-office investment or quantitative research applications.

By applying for a job with SGA, you agree to allow SGA to process your application for this and future opportunities in accordance with our Privacy Policy. Also, to ensure timely processing, you agree to be contacted by our AI recruiter via email, text, or phone. Message frequency varies and data rates may apply, but you can reply STOP to any SMS message to opt-out of texts and may contact SGA at to opt-out of AI communications. The choice not to engage with AI will not adversely impact your consideration for placement. AI is not used to make any hiring determinations.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let’s work better together, we mean it. You’ll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .