(Top Secret) BI Cloud Engineer
Zachary Piper Solutions
- Chantilly, VA
- $120,000-155,000 per year
- Permanent
- Full-time
- Design and deploy AWS Redshift DW solution to support data integration, transformation, reporting and analytics around financial data.
- Build the infrastructure required for optimal ETL/ELT (extraction, transformation, and loading) of data from a wide variety of data sources using SQL and AWS services.
- Develop and maintain data management standards, and documentation of current data sources, raw data, data marts, transformations, and report specifications.
- Develop Lambda functions, python code and ETL SQL procedures to retrieve data from source systems to the AWS Redshift.
- Be able to work in a fast-paced Agile environment with fluid requirements and changing priorities
- Bachelors degree and 6+ years of related experience in data engineering and/or business intelligence development
- Minimum Top Secret clearance
- Minimum 5+ years of experience working with TIBCO WebFOCUS (or similar Business Intelligence tool) Client Server
- Minimum 5 years of experience working with TIBCO WebFOCUS (or similar BI tool) Data Migrator
- Minimum 5 years of experience working with Aurora PostgreSQL (or a relational DB, such as Oracle)
- Minimum 5 year of experience working with AWS Redshift
- Understanding of core AWS services, uses, and AWS architecture best practices
- Strong notion of security best practices (IAM, KMS, etc.)
- Strong understanding of Quality Assurance (QA) best practices
- Excellent collaboration skills and ability to work with multi-disciplinary teams of business analysts, data scientists, subject matter experts, and developers
- Experience working within an Agile/SAFe teaming environment with multiple vendors and stakeholders