Manager / Lead Data Integration Engineer

Rstar Technologies; United States; Remote; USD 140,000 - 190,000; Full time

Job summary

rSTAR Technologies in the United States seeks aSenior Data / Integration Engineer with hands-on Snowflake, dbt, Fivetran, and SQL experience to design and build scalable data platforms and reliable pipelines. You will lead technical delivery and collaborate with architects, PMs, and cross-functional teams.

The role focuses on developing ETL/ELT processes, implementing incremental loading, and ensuring data quality across Bronze to Gold data layers.

Qualifications

• 8+ years of experience in data engineering.
• Hands-on with Snowflake, dbt, Fivetran, and SQL.
• Experience building Snowflake data platforms from scratch.
• Minimum 2 years of technical team handling or delivery leadership experience.
• Strong knowledge of ETL/ELT pipelines, incremental loading, data modeling, and data quality.
• Excellent verbal and written communication with US stakeholders.

Responsibilities

• Design and build scalable data platforms using Snowflake.
• Develop, maintain, and optimize dbt models, tests, and data transformations.
• Build and manage data ingestion pipelines using Fivetran and approved file/API integrations.
• Develop complex SQL queries and implement efficient ETL/ELT processes.
• Implement incremental data loading, data validation, reconciliation, and data quality checks.
• Troubleshoot pipeline failures, schema changes, and production data issues.
• Work with Bronze, Silver, and Gold data layers and dimensional data models.
• Manage Git workflows, CI/CD, code reviews, and production deployments.
• Coordinate with architects, project managers, and cross-functional teams.
• Handle task allocation, delivery tracking, dependencies, and technical team coordination.

Skills

Data engineering

Delivery leadership

ETL/ELT design

Complex SQL

Stakeholder management

Technical documentation

Team coordination

Tools

Snowflake

dbt

Fivetran

SQL

Git

CI/CD

Job description

Hiring: Senior Data / Integration Engineer Snowflake, dbt & Fivetran

Company: rSTAR Technologies
Experience: 8+ Years
Joining: Immediate Joiners Only (Maximum 7 Days Notice Period)

Job Description

We are looking for an experienced Senior Data / Integration Engineer with strong hands‑on expertise in Snowflake, dbt, Fivetran, and SQL. The ideal candidate should have experience building data platforms from scratch, developing reliable data pipelines, and leading technical delivery.

Key Responsibilities

• Design and build scalable data platforms using Snowflake.
• Develop, maintain, and optimize dbt models, tests, and data transformations.
• Build and manage data ingestion pipelines using Fivetran and approved file/API integrations.
• Develop complex SQL queries and implement efficient ETL/ELT processes.
• Implement incremental data loading, data validation, reconciliation, and data quality checks.
• Troubleshoot pipeline failures, schema changes, and production data issues.
• Work with Bronze, Silver, and Gold data layers and dimensional data models.
• Manage Git workflows, CI/CD, code reviews, and production deployments.
• Coordinate with architects, project managers, and cross-functional teams.
• Handle task allocation, delivery tracking, dependencies, and technical team coordination.

Mandatory Skills

• 8+ years of experience in Data Engineering.
• Strong hands‑on experience with Snowflake, dbt, Fivetran, and SQL.
• Experience building and implementing Snowflake data platforms from scratch.
• Minimum 2 years of technical team handling or delivery leadership experience.
• Strong knowledge of ETL/ELT pipelines, incremental loading, data modeling, and data quality.
• Experience delivering at least two production data platform implementations.
• Working knowledge of Git, CI/CD, and production troubleshooting.
• Excellent verbal and written communication skills are mandatory, with the ability to communicate effectively with US stakeholders, architects, project managers, and cross-functional teams.
• Strong stakeholder management, technical documentation, and team coordination skills.

Good to Have

• Experience with MDM, Profisee, data governance, and metadata management.
• Exposure to Power BI trusted datasets and financial/investment data.
• Experience working with distributed or offshore delivery teams.

Important Requirement

Only immediate joiners or candidates with a maximum notice period of 7 days will be considered. Candidates must have hands‑on technical expertise as well as team handling and delivery ownership experience.