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