BI Application Developer

AWS Cloud Developer
Washington, DC
We are seeking a Redshift Developer or Oracle Developer with AWS experience (Top Secret clearance required) to join a data warehouse and business intelligence (BI) development team supporting our federal client working to migrate an on-prem Oracle Enterprise Edition (EE) data warehouse to Redshift instance in AWS. This is a full-time position with on-site work performed at the client's office located in Washington, D.C.

Responsibilities:

• 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.

Requirements:

• On-site Washington, D.C.
• Top Secret clearance required.
• Four to six 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
• 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 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