Senior Data Engineer

Ampcus, Inc; Reston (VA); On-site; USD 110,000 - 140,000; Full time

Job summary

A technology consulting firm in Reston, VA, seeks a Senior Data Engineer to design and implement cloud technologies in applications. You will support agile teams, optimize SQL queries, and mentor your colleagues. The ideal candidate will have over 6 years of experience, fluency in Python, and strong communication skills. This role offers opportunities to work with cutting-edge cloud technologies and contribute to high-quality software development in a collaborative environment.

Qualifications

• Ideally 6+ years of software development experience.
• Expertise in writing and optimizing complex SQL queries.
• Experience integrating AWS services for real-time analytics.

Responsibilities

• Design and implement cloud technologies in application development.
• Mentor team members and design training materials.
• Participate in agile ceremonies and contribute to team deliverables.

Skills

Software development experience in a production environment

SQL query writing and optimization

AWS service integration

Python programming

Event-driven serverless applications

Excellent communication skills

Analytical and problem-solving abilities

Tools

AWS

Redshift

Python

React

Node.js

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Senior Data Engineer

Location(s): Reston, VA

In this role, you will:

Design & Implementation (70%)

• Incorporate Cloud technologies on new application development to include microservices, SQL and AWS services such as Lambda, S3, SQS, SNS, DynamoDB, Quicksight, AWS Redshift and Opensearch
• Create and maintain automated functional and system tests to replicate complex real-world scenarios
• Develop code and our test automation suite to support security features and technical scoping, ensuring that features deliver the expected functionality with high quality
• Ensure that continuous integration is performed on the application source code and constantly seek to enhance the continuous integration methods of the development team to ensure extremely high quality of code
• Support and coordinate with other Engineers, Architects and teams such as User Experience and/or infrastructure teams
• Implement cloud-first architectural solutions and best practices
• Participate in agile scrum ceremonies (Sprint Planning, Grooming, Daily SCRUM, Demo) and contribute to team deliverables
• Participate in peer reviews of software engineering artifacts

Team Coordination (10%)

• Mentor team members by designing and developing training materials to communicate the current and future product architecture
• Mentor technical staff by providing feedback of code and other design artifacts

About You

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
• Able to prioritize and execute tasks in a high-pressure environment

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

Helping all candidates find great careers is our goal. The information you provide here is secure and confidential.

We are now directing you to the original job posting. Please apply directly for this job at the employer’s website.