Senior Specialist - Data Engineering

LTM; West Virginia; On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Comprehensive Medical Plan Covering M,

Disability Coverage

401(k) Match

Life Insurance

Vacation/Sick Leave

Paid Holidays

Parental Leave

Job summary

LTIMindtree is seeking a skilled Snowflake Data Engineer to join an ITAR-regulated project team in the United States. You will design, build, validate, and maintain Snowflake data pipelines that meet ITAR compliance and security requirements, working across data modelling, SQL, and cloud-based ETL.

The role requires hands-on experience with Informatica IICS, Python, GitHub, and Redwood orchestration, along with performance tuning, data quality validation, and collaboration with offshore and

Qualifications

• 8–15 years of technology and business experience.
• Bachelors degree in CS/IT or related field.
• Proven Snowflake Data Engineer experience, preferably ITAR-regulated.
• Strong hands-on Snowflake, SQL, data modelling and IICS‑based ETL.
• Daily SQL tuning for efficient data operations; Python, GitHub, Control‑M, Redwood knowledge.
• Familiarity with ITAR compliance requirements; strong problem solving.

Responsibilities

• Design and implement Snowflake data models for ITAR workloads.
• Build, validate, and maintain Snowflake data pipelines.
• Develop ETL via IICS; ensure data quality, accuracy, and integrity.
• Coordinate with offshore/onshore teams; deliver on schedule.
• Tune SQL and processing workflows for performance and cost control.
• Create and maintain data model and pipeline documentation.

Skills

Snowflake

SQL

Data modelling

IICS ETL

Python

GitHub

Control-M

Redwood

ITAR compliance

Education

Bachelor's degree in Computer Science / IT

Tools

Informatica IICS

Job description

Role Description

Snowflake Data Engineer – ITAR Project Role Overview

We are seeking a skilled Snowflake Data Engineer to join an International Traffic in Arms Regulations (ITAR) project team. The role is responsible for designing, building, validating, and maintaining scalable Snowflake data pipelines and solutions that comply with ITAR requirements. The ideal candidate will bring strong hands‑on expertise in Snowflake, core SQL, cloud‑based ETL, Python, GitHub, Control‑M, Redwood orchestration, and secure data‑engineering practices.

Eligibility Requirements

• Must be a U.S. citizen and must not hold dual citizenship with another country.
• Must satisfy all applicable ITAR compliance requirements.

Key Responsibilities

Snowflake Data Modelling and Engineering

• Design and implement efficient Snowflake data models that support ITAR‑regulated workloads.
• Optimize schema designs for performance, scalability, and maintainability.
• Build, validate, and maintain reliable Snowflake data pipelines and solutions.

ETL Development and Orchestration

• Develop ETL processes using Informatica Intelligent Cloud Services (IICS) to extract, transform, and load data from multiple sources into Snowflake.
• Maintain data quality, accuracy, and integrity throughout ETL pipelines.
• Support workflow orchestration using Control‑M and Redwood.

Snowflake Configuration and Performance

• Configure and optimize Snowflake capabilities such as clustering, materialised views, automatic scaling, data retention, data sharing, zero‑copy cloning, and resource monitoring.
• Monitor pipeline and query performance, identify bottlenecks, and tune SQL and processing workflows for efficiency and cost control.
• Write and optimise complex SQL code as part of daily data‑operations activities.

Compliance, Security, and Validation

• Ensure that all data‑processing activities comply with ITAR regulations.
• Implement appropriate security controls and encryption mechanisms to protect sensitive data.
• Validate data rules developed by the engineering team and confirm that outputs meet defined quality standards.

Collaboration and Delivery

• Work with data scientists, analysts, IT professionals, and other cross‑functional stakeholders to understand requirements and deliver robust data solutions.
• Coordinate effectively with offshore and onsite teams across time zones.
• Deliver assigned work on schedule and respond flexibly to business‑critical ad hoc requests.

Documentation, Support, and Continuous Improvement

• Create and maintain documentation for data models, pipelines, ETL processes, operational procedures, and compliance controls.
• Investigate and resolve data‑related issues promptly, providing support to end users when required.
• Stay current with Snowflake capabilities and engineering best practices, and recommend improvements to the existing data platform.

Required Qualifications

• 8–15 years of relevant technology and business experience.
• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Snowflake Data Engineer, preferably in an ITAR‑regulated environment.
• Strong hands‑on expertise in Snowflake, SQL, data modelling, and IICS‑based ETL development.
• Daily experience writing, tuning, and optimizing SQL for efficient data operations.
• Working knowledge of Python, GitHub, Control‑M, and Redwood orchestration.
• Familiarity with ITAR regulations and compliance requirements.
• Strong problem‑solving skills, attention to detail, communication, and collaboration.
• Ability to work independently and effectively as part of a distributed team.

Preferred Credentials

• Relevant Snowflake certifications, such as SnowPro or SnowPro Advanced: Architect.

Other Details

Actual compensation within the range will be dependent upon the individual's skills, experience, performance and internal equity.

Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree (“LTIM”):

Benefits And Perks

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Short Term and Long‑Term Disability Coverage
• 401(k) Plan with Company match
• Life Insurance
• Vacation Time, Sick Leave, Paid Holidays
• Paid Paternity and Maternity Leave

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job‑related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance‑based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer: The compensation and benefits information provided herein is accurate as of the date of this posting.

LTIMindtree

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, colour, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family‑care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.