Senior Associate, Data Engineer

Role Overview A growing, globally oriented firm is looking for a skilled Data Engineer to join its Boston-based engineering group. This role offers the opportunity to make a meaningful contribution from day one within a collaborative, high-growth environment. The team values individuals who are proactive, adaptable, and comfortable operating in a fast-moving, evolving setting alongside a small, focused group of engineers. Core Responsibilities Develop and maintain robust, scalable data pipelines that connect both internal systems (such as portfolio and order management platforms) and third-party data providers (e.g., financial market data sources) Work with complex datasets across multiple platforms, ensuring accuracy, reliability, and efficient structure Partner with cross-functional teams-including data governance, AI, and application engineering-to deliver impactful, business-driven data solutions Contribute as an active member of a small agile engineering team, participating in sprint planning, stand-ups, and other iterative development processes Build and support data ingestion and transformation workflows using Python and relational databases such as MySQL Design and optimize ETL processes leveraging cloud-based integration tools (e.g., Azure Data Factory or similar) Implement and manage data models within cloud data warehouse environments such as Snowflake Support the development of AI-enabled data features, including semantic layers and automated insights capabilities Follow engineering best practices to produce clean, scalable, and well-tested code Troubleshoot and resolve challenging data integration and performance issues across systems Contribute to the evolution of a modern data platform built on top of an existing enterprise data ecosystem Help deliver innovative data capabilities in a collaborative and fast-paced engineering culture Additional Responsibilities Adhere to organizational security policies and promptly escalate any risks or concerns to the appropriate teams Ensure compliance with applicable data privacy regulations and internal data protection standards Be flexible in supporting changing business priorities, which may occasionally require additional working hours Candidate Profile The ideal candidate will have a strong technical background in data engineering or a related discipline (such as Computer Science), or equivalent practical experience. Success in this role requires independence, curiosity, attention to detail, and a commitment to writing high-quality, maintainable code. Strong collaboration skills and sound problem-solving judgment are also essential. Required Qualifications Demonstrated experience designing and building data warehouse solutions with complex schemas Strong understanding of data modeling techniques, including dimensional modeling (e.g., star schema) Approximately 5+ years of professional experience in data engineering roles Hands-on experience with Snowflake (roughly 3+ years), including advanced features such as AI capabilities or semantic modeling Proficiency in Python (3+ years or equivalent experience) Solid SQL and database skills, ideally with MySQL or similar systems Experience working with APIs and integrating external data sources Familiarity with agile development methodologies Strong interest in solving complex technical problems through programming Preferred Qualifications Knowledge of software design patterns and best practices for Python-based applications Experience with data visualization tools (e.g., Power BI or similar) Experience using cloud-based data orchestration tools such as Azure Data Factory Exposure to modern AI tools or frameworks (e.g., generative AI, agent-based systems) Experience collaborating across geographically distributed or cross-functional teams