Data Integration Engineer (Mid-level)

City Hive Inc.; New York (NY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

City Hive Inc. is looking for a Data Integration Engineer to join their team in New York City. This role involves integrating multiple POS, ERP, and CRM systems into their SaaS platform. Responsibilities include managing data integration pipelines, working with customers to access their data, and maintaining these pipelines as business needs change.

The ideal candidate will have 2+ years in Python-based ETL development, SQL expertise, and a willingness to learn Ruby. This position offers a hybrid work model, requiring 4 days in-office.

Qualifications

• 2+ years of work experience with data pipelines / ETL in Python.
• Good familiarity with data sources like APIs and raw files.
• Ability to analyze data for deliverables and inconsistencies.

Responsibilities

• End-to-end responsibility of data integration pipelines.
• Engage with customers to access and understand their POS data.
• Maintain data pipelines as business requirements change.

Skills

Data pipelines / ETL in Python

SQL knowledge

Ruby knowledge

Data analysis

Familiarity with IT tools

Job description

We are one of the fastest growing SaaS companies in the United States. We unite the Three-Tier system in a whole new way by connecting retailers to wholesalers, distributors and suppliers, using the City Hive platform.

Work Authorization: Candidates must be authorized to work in the United States. Visa sponsorship is not available for this position.

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’re not afraid to learn Ruby (because we also use that), or you already used it.
• 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.

To apply, please submit your resume and a cover letter detailing your relevant experience and how you meet the qualifications outlined above.

Seniority Level

Mid‑level

Employment Type

Full‑time

Department

R&D

Location

NYC

On Site Working

Hybrid (4 days in‑office)