Lenmar Consulting
Sr Data Engineer USC GC only Max 65hr on W2
Lenmar Consulting, Herndon, Virginia, United States, 22070
Job Description
Profile: Senior Data Engineer with strong data and native AWS skills.
Top 5 Key Skills
Advanced AWS Data Engineering (Redshift, S3, Lambda, DynamoDB, Glue, Athena, Step Functions, SNS/SQS)
Complex SQL Query Development & Optimization
Python for ETL and Automation
Serverless ETL Pipeline Design (especially AWS Lambda + Redshift integration)
BI Tools & Real-time Analytics (e.g., Quicksight, Tableau, Looker)
You have:
Ideally 6+ years of software development experience in a production environment
Expertise writing and optimizing complex SQL queries for data extraction, transformation, and reporting (e.g., SELECT, JOIN, GROUP BY, HAVING, WINDOW functions)
Expertise integrating Redshift Serverless with AWS services such as S3, Glue, Lambda, Athena, DynamoDB and Kinesis BI tools like Tableau, Quicksight, or Looker for real-time analytics and dashboards
Expertise building serverless ETL pipelines with Lambda to automate data ingestion and transformation into Redshift
Experience with Python required; React and Node.js nice to have
Experience building event-driven cloud-based serverless applications and deploying to AWS
Technical knowledge of Cloud Computing, DevOps, and Microservices
Excellent communication skills with the ability to present ideas in business-friendly and user-friendly language
Demonstrated ability to develop and maintain good customer working relationships
Exceptional analytical, conceptual, and problem-solving abilities
Proficient in designing, building, and deploying machine learning models using
Amazon SageMaker
Able to prioritize and execute tasks in a high-pressure environment
Qualifications: Additional Information
All your information will be kept confidential according to EEO guidelines.
Profile: Senior Data Engineer with strong data and native AWS skills.
Top 5 Key Skills
Advanced AWS Data Engineering (Redshift, S3, Lambda, DynamoDB, Glue, Athena, Step Functions, SNS/SQS)
Complex SQL Query Development & Optimization
Python for ETL and Automation
Serverless ETL Pipeline Design (especially AWS Lambda + Redshift integration)
BI Tools & Real-time Analytics (e.g., Quicksight, Tableau, Looker)
You have:
Ideally 6+ years of software development experience in a production environment
Expertise writing and optimizing complex SQL queries for data extraction, transformation, and reporting (e.g., SELECT, JOIN, GROUP BY, HAVING, WINDOW functions)
Expertise integrating Redshift Serverless with AWS services such as S3, Glue, Lambda, Athena, DynamoDB and Kinesis BI tools like Tableau, Quicksight, or Looker for real-time analytics and dashboards
Expertise building serverless ETL pipelines with Lambda to automate data ingestion and transformation into Redshift
Experience with Python required; React and Node.js nice to have
Experience building event-driven cloud-based serverless applications and deploying to AWS
Technical knowledge of Cloud Computing, DevOps, and Microservices
Excellent communication skills with the ability to present ideas in business-friendly and user-friendly language
Demonstrated ability to develop and maintain good customer working relationships
Exceptional analytical, conceptual, and problem-solving abilities
Proficient in designing, building, and deploying machine learning models using
Amazon SageMaker
Able to prioritize and execute tasks in a high-pressure environment
Qualifications: Additional Information
All your information will be kept confidential according to EEO guidelines.