Data Engineer

Atlantic Group; Boston (MA); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Atlantic Group in Boston is seeking a full-time Data Engineer for a hybrid role. You will design scalable data pipelines, integrate OMS/PMS-like systems and external vendors, and collaborate with Data Management, AI, and Software Engineering to deliver high-value solutions.

The ideal candidate will have 5+ years in data engineering, strong Python and SQL skills, and extensive Snowflake Cortex AI experience, in a fast-paced, entrepreneurial environment.

Qualifications

• Degree in Computer Science or similar technical subject
• 5+ years of commercial data engineering experience
• 3+ years of Snowflake experience including Cortex AI
• 3+ years of Python experience (Python 3+)
• Strong MySQL querying skills and API experience
• Experience in Agile environments

Responsibilities

• Design and build scalable data pipelines integrating internal applications and external data vendors
• Analyze and manage complex data structures across source and target systems
• Collaborate with Data Management, AI, and Software Engineering teams to deliver high-value solutions
• Work in an agile team of data engineers led by the Principal Data Engineer
• Develop and maintain data sources using MySQL databases and Python applications
• Create and optimize data pipelines using Azure Data Factory and Snowflake
• 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
• Support the greenfield Snowflake Cortex initiative with complex datasets

Skills

Data pipelines

SQL

Python

Azure Data Factory

Snowflake

Snowflake Cortex AI

APIs

Agile

Power BI

Education

Bachelor's in Computer Science

Tools

MySQL

Azure Data Factory

Job description

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

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 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