Smart IT Frame LLC
Data Integration Lead (ETL With Snowflake, AWS)
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Integration Lead (ETL with Snowflake, AWS) on a contract basis in Arlington, VA (hybrid, 4 days/week). Requires 10-12 years of experience in data engineering, ETL development, AWS, Snowflake, and advanced SQL expertise.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
November 14, 2025
🕒 - Duration
Unknown
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Arlington, VA
-
🧠 - Skills detailed
#S3 (Amazon Simple Storage Service) #Dimensional Modelling #Ab Initio #Data Quality #IAM (Identity and Access Management) #Snowflake #Data Lineage #Leadership #Metadata #Cloud #Deployment #SQL (Structured Query Language) #Data Science #Data Management #Clustering #Compliance #Data Engineering #Data Pipeline #Data Integration #Automation #"ETL (Extract #Transform #Load)" #Lambda (AWS Lambda) #Documentation #AWS (Amazon Web Services) #Complex Queries #Scala
Role description
Role: Data Integration lead (ETL With Snowflake, AWS)
Location: Arlington VA - Hybrid (4 days/week)
Type: Contract
At Smart IT Frame,
we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together.
Summary:
• Experienced Data Engineer with 10–12 years of hands-on expertise in designing and scaling enterprise-grade data solutions. Proven track record in building robust ETL pipelines, architecting cloud-native data platforms, and driving performance across large-scale systems. Adept at translating business needs into technical solutions, mentoring teams, and optimizing data workflows for analytics and operational excellence.
Responsibilities:
• ETL/ELT Development: Architect and maintain high-performance data pipelines using Ab Initio, handling complex transformations and large data volumes.
• Cloud Data Engineering: Build and optimize data platforms on AWS, leveraging services like S3, Lambda, Glue, and IAM for secure, scalable workflows.
• Snowflake Expertise: Design efficient schemas, implement clustering strategies, and tune performance for analytics workloads in Snowflake.
• Advanced SQL: Develop complex queries, stored procedures, and data validation logic to support reporting, analytics, and downstream systems.
• Data Modelling & Governance: Lead efforts in dimensional modelling, metadata management, and data lineage to ensure consistency and compliance.
• Performance & Quality: Conduct tuning across ETL jobs and cloud components; implement data quality frameworks to ensure reliability.
• Cross-Functional Collaboration: Partner with analysts, data scientists, and business stakeholders to deliver scalable, value-driven solutions.
• Mentorship & Leadership: Guide junior engineers, enforce best practices, and contribute to architectural decisions and roadmap planning.
• Innovation & Automation: Evaluate new tools, drive automation initiatives, and continuously improve pipeline efficiency and deployment velocity.
• Leverage industry best practices and methods.
• Define documentation to support the implementation of best practices.
• Good communication and stakeholders’ management.
📩 Apply today or share profiles at dhamodharan@smartitframe.com
Role: Data Integration lead (ETL With Snowflake, AWS)
Location: Arlington VA - Hybrid (4 days/week)
Type: Contract
At Smart IT Frame,
we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together.
Summary:
• Experienced Data Engineer with 10–12 years of hands-on expertise in designing and scaling enterprise-grade data solutions. Proven track record in building robust ETL pipelines, architecting cloud-native data platforms, and driving performance across large-scale systems. Adept at translating business needs into technical solutions, mentoring teams, and optimizing data workflows for analytics and operational excellence.
Responsibilities:
• ETL/ELT Development: Architect and maintain high-performance data pipelines using Ab Initio, handling complex transformations and large data volumes.
• Cloud Data Engineering: Build and optimize data platforms on AWS, leveraging services like S3, Lambda, Glue, and IAM for secure, scalable workflows.
• Snowflake Expertise: Design efficient schemas, implement clustering strategies, and tune performance for analytics workloads in Snowflake.
• Advanced SQL: Develop complex queries, stored procedures, and data validation logic to support reporting, analytics, and downstream systems.
• Data Modelling & Governance: Lead efforts in dimensional modelling, metadata management, and data lineage to ensure consistency and compliance.
• Performance & Quality: Conduct tuning across ETL jobs and cloud components; implement data quality frameworks to ensure reliability.
• Cross-Functional Collaboration: Partner with analysts, data scientists, and business stakeholders to deliver scalable, value-driven solutions.
• Mentorship & Leadership: Guide junior engineers, enforce best practices, and contribute to architectural decisions and roadmap planning.
• Innovation & Automation: Evaluate new tools, drive automation initiatives, and continuously improve pipeline efficiency and deployment velocity.
• Leverage industry best practices and methods.
• Define documentation to support the implementation of best practices.
• Good communication and stakeholders’ management.
📩 Apply today or share profiles at dhamodharan@smartitframe.com
