Data Engineer

Our client, a mid-size global investment firm with $75 Billion AUM, is seeking a talented full-time Data Engineer to join their Boston data engineering team where the impact will be immediate and tangible. This will be a hybrid-focused position.

As a fast-growing, 400+ person company, they require someone who is motivated, a self-starter, adaptable and comfortable working on a small team in an extremely fast-paced, ever-changing entrepreneurial environment.

Key Responsibilities:

• Design and build scalable data pipelines integrating internal applications (e.g., OMS/PMS systems) and external data vendors such as Bloomberg and MSCI

• Analyze and manage complex data structures across both source and target systems

• Collaborate closely with Data Management, AI, and Software Engineering teams to deliver high-value, business-aligned solutions

• Work within an agile team of five data engineers led by the Principal Data Engineer, participating in all Scrum ceremonies

• Develop and maintain data sources using MySQL databases and Python applications

• Create and optimize data pipelines using Azure Data Factory (ADF)

• Transform and manage data within Snowflake environments

• Build AI agents and semantic views leveraging Snowflake Cortex AI

• Apply data engineering best practices to develop scalable, maintainable, and testable code

• Solve complex data engineering challenges across multiple technologies and systems

• Contribute to a greenfield Snowflake Cortex initiative built on top of an existing enterprise data lake with complex datasets and interconnected systems

• Support the delivery of innovative data solutions in a fast-paced, collaborative engineering environment

Qualifications / Attributes:

The ideal candidate will be a talented data engineer with a degree in Computer Science or similar technical subject, or equivalent experience. The candidate will be working independently and to be effective the candidate needs to be a self-starter, curious, practical, committed to high quality well-tested code, apply clear judgment and critical thinking, as well as collaborating closely with others in the firm.

In Order To Be Successful:

• Must have worked in building data warehouses with complex data structures

• Proficient in data modelling and star schema

• Approximately 5+ years of commercial experience as a data engineer

• Approximately 3+ years of working in Snowflake (including Snowflake Cortex AI and semantic views)

• Approximately 3+ years of working in python (Python 3+)

• Strong database querying skills preferably in MySQL

• Proficient in working with APIs

• Experience working in Agile setup

• Genuine passion for solving complex problems through programming

Preferred:

• Understanding common design patterns & data modelling for python application development

• Understanding of a visualization tool preferably Power BI

• Approximately 3+ years of working in ADF (Azure data factory)

• Exposure to AI tools e.g. Codex, Claude, agentic framework

• Experience working effectively with global, cross-functional teams