What are the responsibilities and job description for the BI Application Developer with Security Clearance position at Prism, Inc.?
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
