AWS Redshift Cloud Developer (Sr)

Electronic Consulting Services, Inc (ECS Federal)
Washington, DC
21 Feb 2025

Vacancy expired!

ECS is seeking an

AWS Redshift Cloud Developer (Sr) to work in our

Washington, D.C. office.

Job Description: Work hand-in-hand with our AWS Solutions Architect and AWS DBA to configure and implement existing on-prem data warehouse infrastructure to AWS GovCloud. Develop and create tables, views, materialized views, indexes, constraints, and PL/SQL-based ETL routines in support of the implementation. Implement changes to objects and code to keep pace with the yearly changes in the OLTP system and ensure the ETL runs as efficiently as possible. Work in a fast-paced Agile environment with fluid requirements and changing priorities.

Required Skills:

  • Active Top Secret Clearance

  • BS Degree
  • 6-10 years' experience planning, designing, developing, architecting, and implementing cloud database solutions with an emphasis on AWS Redshift
  • Strong notion of security best practices (IAM, KMS, etc)
  • Strong knowledge in PL/SQL code to perform ETL for both full loads and incremental loads from an OLTP system to a Dimensional Data Warehouse
  • Understanding of core AWS services, uses, and AWS architecture best practices
  • QA (testing and documentation) experience for PL/SQL development and peer reviews
  • Experience developing data pipelines for terabyte scale data warehouses
  • Hand-on experience in different domains such as database architecture and business intelligence
  • Expertise in collaborating with multi-disciplinary teams of business analysts, data scientists, subject matter experts, and developers
  • Develop, implement and maintain development and production environments
  • Experience configuring logging and auditing services (cloudwatch, cloudtrail, etc)
  • Expertise in IaC best practices using terraform or AWS CloudFormation
  • Experience working with Momentum ERP System
  • Experience with serverless architecture a plus
  • Excellent collaboration skills to work with multiple teams in the organization
  • Experience working within an Agile/SAFe teaming environment with multiple vendors and stakeholders
  • 100% on-site in Washington, D.C.

ECS is an equal opportunity employer and does not discriminate or allow discrimination on the basis of race, color, religion, gender, age, national origin, citizenship, disability, veteran status or any other classification protected by federal, state, or local law. ECS promotes affirmative action for minorities, women, disabled persons, and veterans. ECS is a leading mid-sized provider of technology services to the United States Federal Government. We are focused on people, values and purpose. Every day, our 3000+ employees focus on providing their technical talent to support the Federal Agencies and Departments of the US Government to serve, protect and defend the American People.