Jobs and Careers
LE

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

Lenmar Consulting Inc.
United Statesfull_timeVerifiedPosted 13 Aug 2025
💰 $130,000/yr

About the role

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.

Apply for this role

Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.

Apply Now →Generate Application Kit

Free account required — sign up in 30s

Company

Lenmar Consulting Inc.

View company profile →