Sr Data Engineer USC & GC only (Max $65/hr on W2)
@ Lenmar Consulting Inc.

Reston, Virginia, United States
On Site
Contract
Posted 9 days ago

Your Application Journey

Personalized Resume
Apply
Email Hiring Manager
Interview

Email Hiring Manager

XXXXXXXXXX XXXXXXXXXXX XXXXXXXXXX*******@lenmarconsulting.com
Recommended after applying

Job Details

Company Description

Lenmar Consulting Inc.

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
  • Expertise integrating Redshift Serverless with AWS services
  • Experience building serverless ETL pipelines with Lambda
  • Experience with Python required; React and Node.js nice to have
  • Excellent communication skills with the ability to present ideas in business-friendly and user-friendly language
  • Exceptional analytical, conceptual, and problem-solving abilities
  • Able to prioritize and execute tasks in a high-pressure environment

How to Get Hired at Lenmar Consulting Inc.

🎯 Tips for Getting Hired

  • Customize your resume: Highlight AWS, SQL, and Python skills relevant to the job.
  • Leverage LinkedIn: Connect with current Lenmar employees to learn more.
  • Prepare for technical interviews: Focus on AWS problems and data engineering scenarios.
  • Demonstrate soft skills: Be ready to discuss communication and problem-solving experiences.

📝 Interview Preparation Advice

Technical Preparation

Deep dive into AWS service documentation.
Practice SQL query optimization scenarios.
Build a sample ETL pipeline with Python.
Explore serverless architecture examples using Lambda.

Behavioral Questions

Prepare to discuss previous team collaboration experiences.
Outline how you've solved complex data problems.
Share examples of high-pressure task management.
Discuss your approach to stakeholder communications.

Frequently Asked Questions