company logo

Sr Data Engineer USC & GC only (Max $65/hr on W2)

Lenmar Consulting Inc.

Office

Herndon, VA, United States

Full Time

Company Description

Education

Job Description

Profile: Senior Data Engineer with strong data and native AWS skills.

Top 5 Key Skills

  1. Advanced AWS Data Engineering (Redshift, S3, Lambda, DynamoDB, Glue, Athena, Step Functions, SNS/SQS)
  2. Complex SQL Query Development & Optimization
  3. Python for ETL and Automation
  4. Serverless ETL Pipeline Design (especially AWS Lambda + Redshift integration)
  5. 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

Additional Information

All your information will be kept confidential according to EEO guidelines.

Sr Data Engineer USC & GC only (Max $65/hr on W2)

Office

Herndon, VA, United States

Full Time

August 13, 2025

company logo

Lenmar Consulting Inc.