ECS is seeking an AWS Redshift Cloud Developer to work in our Washington, DC office.
Interested in joining a dynamic team providing mission critical technical consulting and implementation support to our valuable DoJ partner? As a part of our highly skilled technical team supporting this Agile project you will:
Work hand-in-hand with our AWS Solutions Architect and Data Warehouse Engineer to configure and implement existing on-prem data warehouse infrastructure to AWS Redshift.
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.
Develop, implement, and maintain development and production environments.
Develop Lambda functions, python code and ETL SQL procedures to retrieve data from source systems to AWS Redshift.
Work in a fast-paced Agile environment with fluid requirements and changing priorities.
Four plus years of 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
Experience configuring logging and auditing services (CloudWatch, CloudTrail, etc.)
Expertise in IaC best practices using Terraform or AWS CloudFormation
Active Top-Secret clearance required
100% on-site in Washington, D.C.
Experience working with Momentum ERP System a plus
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
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 3800+ 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.