Company Name: Lenmar Consulting Inc

Job Details: Be an Early Applicant Hiring Remotely in Herndon, VA In-Office or Remote 65-65 Senior level

Job Url: https://builtin.com/job/sr-data-engineer-usc-gc-only-max-65-hr-w2/6876775

Job Description: Company DescriptionEducationJob DescriptionProfile: Senior Data Engineer with strong data and native AWS skills.Top 5 Key SkillsAdvanced AWS Data Engineering (Redshift, S3, Lambda, DynamoDB, Glue, Athena, Step Functions, SNS/SQS)Complex SQL Query Development & OptimizationPython for ETL and AutomationServerless 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 environmentExpertise 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 dashboardsExpertise building serverless ETL pipelines with Lambda to automate data ingestion and transformation into RedshiftExperience with Python required; React and Node.js nice to haveExperience building event-driven cloud-based serverless applications and deploying to AWSTechnical knowledge of Cloud Computing, DevOps, and MicroservicesExcellent communication skills with the ability to present ideas in business-friendly and user-friendly languageDemonstrated ability to develop and maintain good customer working relationshipsExceptional analytical, conceptual, and problem-solving abilitiesProficient in designing, building, and deploying machine learning models using Amazon SageMakerAble to prioritize and execute tasks in a high-pressure environmentAdditional InformationAll your information will be kept confidential according to EEO guidelines.