Job Summary:
Partners Capital is a Global Investment Office founded in 2001, managing over $75B in assets for various clients. They are seeking a talented data engineer to join their Boston team, responsible for designing and building scalable data pipelines and collaborating with multiple teams to deliver innovative data solutions.
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
โข Responsible for ensuring all information security processes, policies and procedures are adhered to and any issues or concerns are raised with the Cyber Security team
โข Ensure full compliance with all local data protection regulations and privacy controls, and any related issues are raised via the appropriate channels
Qualifications:
Required:
โข 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.
Company:
Partners Capital provides services to investment professionals, foundations, and high net-worth families. Founded in 2001, the company is headquartered in San Francisco, USA, with a team of 201-500 employees. The company is currently Growth Stage.