Data Engineer

Intelliswift - An LTTS Company

United States

Description

Job Title: Data Engineer (Streaming & Data Platform Migration)

Location: Remote (United States)

Duration: 6 Months, potential extensions

We are looking for a skilled Data Engineer to support a large-scale data platform migration initiative, transitioning business-critical systems from a SaaS CRM environment to an internally managed data platform.

This role will focus on designing and building scalable data pipelines, real-time data flows, and robust data models, ensuring high data quality, consistency, and reliability across systems. You’ll play a key role in modernizing how data is structured, processed, and consumed across the organization.

Responsibilities:

  • Design and build bidirectional data pipelines between CRM systems, data warehouses, and internal operational data stores
  • Develop real-time streaming pipelines using distributed event-streaming frameworks (e.g., Kafka, Kinesis, Pulsar)
  • Define and manage data schemas and entity models, including access controls and data lifecycle rules
  • Build and maintain data validation, reconciliation, and monitoring frameworks to ensure data accuracy during migration
  • Develop and maintain data documentation (schema definitions, transformations, mappings, data dictionaries)
  • Collaborate with engineering, business, and CRM stakeholders to define data contracts, SLAs, and migration strategies
  • Investigate and resolve data quality issues, pipeline failures, and inconsistencies
  • Leverage AI-assisted development tools to improve efficiency in SQL development, pipeline creation, and schema management.

Required Skills & Experience

  • Strong proficiency in SQL and data transformation logic
  • Hands-on experience building ETL/ELT pipelines in distributed data environments
  • Experience with data warehouses such as Snowflake, BigQuery, Databricks, Hive, Spark, or Trino
  • Experience with real-time streaming systems (Kafka, Pulsar, Kinesis, or similar)
  • Solid understanding of data modeling (entity modeling, dimensional modeling)
  • Experience with GraphQL and backend data access layers
  • Familiarity with ORM frameworks and relational databases (MySQL or similar)
  • Strong experience with data quality engineering (validation, monitoring, reconciliation)
  • Experience with data migration across heterogeneous systems
  • Ability to work independently and manage multiple priorities

Nice to Have

Experience working with CRM platforms (e.g., Salesforce)

Exposure to AI-assisted development tools (GitHub Copilot, Cursor, etc.)

Experience with event-driven architectures and subscription-based data systems

Basic Qualifications

Bachelor’s degree in Computer Science, Data Engineering, or related field

5+ years of data engineering experience