Senior Data Engineer

Insight Global; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Insight Global is looking for a Senior Data Engineer to design and operate data pipelines in a remote role with US team overlap. You will own ingestion, transformation and analytics pipelines using IDMC, Snowflake, Python, Airflow, and dbt, partnering with Product, Data Science, and Analytics teams.

Candidates should have strong SQL, data modeling, and experience with cloud platforms (AWS/GCP). Salesforce data models and APIs familiarity are a plus.

Qualifications

• Strong experience in data engineering, ETL and data architecture.
• Hands-on with Airflow DAGS, dbt, Python and SQL.
• Familiarity with Informatica IDMC, Snowflake and cloud platforms.

Responsibilities

• Build and maintain data pipelines for ingestion, transformation and egress.
• Monitor KPIs and data quality, troubleshoot pipelines and incidents.
• Collaborate with Product, Data Science and Analytics teams on data models.

Skills

Data engineering

ETL

Airflow

dbt

Python

SQL

Snowflake

IDMC

Salesforce data models

AWS/GCP

MuleSoft

Salesforce APIs

Job description

Job Title: Senior Data Engineer

Remote Job

Shift Time : 2:00 PM to 11:00 PM

Time Zone: must have overlap with US teams, work until 2AM IST.

Job Description

Must-Haves

• Strong experience in data engineering, ETL (preferably Informatica), and data architecture
• Experience working with Salesforce platforms and data models
• Hands-on experience with Airflow DAGS and MuleSoft
• Strong SQL skills with Snowflake and other relational databases
• Experience writing complex Python modules for custom ETL workflows
• Expertise in building batch and real-time data pipelines
• Experience with dbt for data transformation and modeling
• Familiarity with AWS/GCP and distributed/event-driven architectures
• Strong understanding of data modeling, data warehousing, and big data processing
• Experience with data quality, monitoring, and pipeline orchestration frameworks
• Ability to work closely with Product, Data Science, and Analytics teams
• Experience working on Salesforce Flows and Apex is a plus
• Main skillsets: Intelligent Data Management Cloud, IDMC (Informatica Cloud), strong SQL, DBT- Data Build Tool
• secondary: airflow dags, snowflake, working salesforce systems like understanding salesforce apis/ MuleSoft / architecture

Day-to-Day

The supplier will serve the Data Strategy and Operations function within UKS, establishing new data integration patterns into Data 360 from third-party vendors and managing ingestion from existing sources. Engineers will own pipeline monitoring, KPI tracking, and egress management to multiple downstream destinations.

Responsibilities

• Manage all new data ingestions for teams operational needs
• Build new data integrations for all new data sources and providers, including third-party data providers
• Manage new data egress patterns to send/share data outputs from Data 360 to multiple destinations
• Ingest new data via existing ingestion pipelines
• Monitor, maintain, and troubleshoot data pipelinesTrack and report statistics including data volume, number of data streams, and other ingestion KPIs

Near-Term Priorities (First 30 Days)

• Establish new data integration for data provider
• Ingest an additional dataset from Moody's (integration already established)
• Manage other third-party vendor data sources as assigned.