Data Integration Engineer (Mid-level)

First, you’re probably a good fit if:

• You appreciate the difference between a CSV and a PSV file (because again and again, you had to parse a CSV file that didn’t conform to the “standard”). We’re not even mentioning TSV. 
• You enjoy opening files in a HEX editor and figuring out the data layout
• “API Docs? Who needs that?” – you, on a typical Tuesday afternoon
• You got excited when Python introduced data classes

Why are data engineers important?

As artificial intelligence evolves from simple automation to sophisticated agentic systems capable of independent decision-making and action, the data integration engineer has emerged as one of the most critical roles in any organization’s technical foundation. Agentic AI systems are only as intelligent as the data they can access and understand—and in most enterprises, that data exists in fragmented silos, speaking different languages, structured in incompatible formats, and scattered across dozens of platforms.

The data integration engineer bridges these divides, transforming disparate data streams into a unified, standardized foundation that AI agents can actually reason over and act upon. Without this foundational work of connecting, cleansing, and standardizing data flows, even the most advanced AI models remain blind to the full context they need to deliver real value. In this sense, data integration engineers aren’t just supporting AI—they’re unlocking its entire potential, turning disconnected information into the coherent intelligence layer that makes autonomous, context-aware systems possible.

The Role

As a Data Integration Engineer in City Hive, you will have the opportunity to crack one of the most significant technical challenges of the company, which is integrating 4000+ of POS, ERP, and CRM systems into our SaaS platform in a real-time manner.
We have developed our own cutting-edge ETL framework, which runs on top of AWS Lambda, SQS, and S3, allowing us to maintain near real-time data freshness (we’re talking seconds). Having our own solution allows us to have the ETL solution much more integrated with the rest of the system, as opposed to just keeping it as a boring unit that lives outside of it. Additionally, it allowed us to be much more efficient when it comes to cost and avoid the typical lambda cost when you reach a significant scale.

You’d find yourself communicating with entities outside the company regularly – IT personnel of big liquor store chains/distributors/brands, solution engineers and developers of POS companies (think Square, Toast, Netsuite, etc.).

Responsibilities

• End-to-end responsibility on data integration pipelines.
• Engage directly with customers to access their POS data and understand their data model.
• Maintain data pipelines as data and business requirements change.
• Understand City Hive product and the implications of the data on it.
• Maintain a high level of service with regard to data and integration questions and issues.

Qualifications

• 2+ years of hands-on development experience with data pipelines / ETL in Python.
• You wrote at least 5 decorators in Python in the last year 🙂
• You’re not afraid to learn Ruby (because we also use that), or you already used it An all-around player, with a start-up mentality, who doesn’t mind getting their hands dirty with whatever it takes to get things done.
• Advanced working SQL knowledge and experience working with relational databases, as well as working familiarity with a variety of other data sources (APIs, raw files, etc.).
• Ability to analyze data to identify deliverables, gaps, and inconsistencies.
• Good familiarity with IT tools.

Seniority Level
Mid-level

Employment Type
Full-time

Department
R&D

Location
NYC

On Site Working
Hybrid (4 days in-office)

Salary
$90K - $115K