Senior Associate, Data Engineer

Partners Capital•Boston, MA

4d•$125,000 - $150,000•Hybrid

About The Position

Partners Capital is seeking a talented data engineer to join our Boston data engineering team where the impact will be immediate and tangible. As a fast-growing, 400+ person company, we seek 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 may be assessed and are subject to change from time to time based on the needs of the business. The individual may be required to work overtime as needed.

Requirements

Degree in Computer Science or similar technical subject, or equivalent experience
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
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

Nice To Haves

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

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

Benefits

Professional development and career progression opportunities
Competitive compensation
Exceptional benefits
Flexible “results-focused” working model
Medical, dental, and vision insurance
Short and long-term disability insurance
Life insurance
Flexible spending accounts
Commuter benefits
Paid time off
401(k) plan with employer matching
Global philanthropy via a charity program and volunteer day
Wellness and social events
Support for the pursuit of professional certifications such as the Chartered Financial Analyst (CFA), Chartered Alternative Investment Analyst (CAIA), etc.