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) in Arlington, VA, on a hybrid contract for 12+ years of experience. Key skills include ETL development, AWS, Snowflake expertise, advanced SQL, and data governance.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
December 4, 2025
🕒 - Duration
Unknown
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Arlington, VA
-
🧠 - Skills detailed
#Clustering #Data Quality #Data Science #SQL (Structured Query Language) #Ab Initio #Complex Queries #Scala #Data Pipeline #Compliance #Data Management #Metadata #Leadership #Deployment #"ETL (Extract #Transform #Load)" #Snowflake #Documentation #S3 (Amazon Simple Storage Service) #Dimensional Modelling #Automation #IAM (Identity and Access Management) #Data Lineage #Data Integration #Lambda (AWS Lambda) #Cloud #AWS (Amazon Web Services) #Data Engineering
Role description
Role: Data Integration lead (ETL With Snowflake, AWS)
Location: Arlington VA - Hybrid (4 days/week)
Type: Contract
Experience: 12+ Years
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
Experience: 12+ Years
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
