ECS is seeking an AWS Redshift Cloud Developer to work in our Washington, DC office.
Job Description:
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.
Salary Range: $175,000 - $200,000
General Description of Benefits
Required Skills:
- 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.
Desired Skills:
- 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. |
