(Top Secret) BI Cloud Engineer

Zachary Piper Solutions

  • Chantilly, VA
  • $120,000-155,000 per year
  • Permanent
  • Full-time
  • 17 days ago
Zachary Piper Solutions is seeking a BI Cloud Engineer to support the FBI's ongoing data modernization program in the following locations: Chantilly, VA, Washington D.C., Quantico, VA, and Huntsville, AL. We are seeking a cloud engineer who is proficient with business intelligence tools to assist with the transfer of the existing on premise intelligence application to the AWS cloud.Clearance: Active Top Secret ClearanceLocation: Washington, D.C., Chantilly, VA, Quantico, VA, Huntsville, ALResponsibilities of the BI Cloud Engineer:· Work alongside our AWS Solutions Architect and Data Warehouse Engineer to transfer existing on-prem TIBCO WebFOCUS application to the AWS Cloud environment· Implement changes to objects and code to support could migration tasks· Work with Business Intelligence Client Server, Report Server, and Data Migrator· Work with the AWS Solutions Architect, ETL and BI developers to configure and implement existing on-prem data warehouse infrastructure to AWS.
  • 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
Qualifications of the BI Cloud Engineer:
  • 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
Compensation of the BI Cloud Engineer:· Compensation: $120,000 - $155,000+ **based on years of experience**· Fully funded program - 3 years remaining· Full Benefits: PTO, Paid Holidays, Cigna Medical, Dental, and Vision, 401k with ADPKeywords: Webfocus, Web focus, business intelligence, business analytics, RedShift, Business Intelligence, Business analyst, Top secret, TS, FBI, business analysis, QLIK, Tableau, data warehousing, webfocus, Web focus, AWS, TIBCO, WEBFOCUS, Redshift, red shift, cloud engineer, cloud engineering, PL/SQL, SQL, Python, data warehouse, data warehousing, dashboards, administration, engineer, software developer, data visualization, visualizations, microstrategy, ADVANA, Lumira, air force, dashboards, air force, DOD, department of defense, Chantilly, D.C., Huntsville, PowerBI, data analyst, data analysis, Air force, PowerBI, analytics, analytical, data visualization, dashboard, Databricks, Tableau, implementation, DOD, department of defense, business case analysis, root cause analysis, project management, project manager, IT, information technology, SCRUM, Agile, task lead, business, business analyst, portfolio management, secret, secret clearance, security clearance, top secret, topsecret, direct placement, long term, data engineer, data SME, Marine, air force, portfolio, stakeholders, visualizations, Kanban, SCRUM, engineer, stakeholders, communication, Lumira, U.S., warfighter, AGILE, capability, Andrews, Washington, D.C., Logistics, analytics, analysis, SIPR, NIPR, army, BI, Kanban, dashboarding, business object, data access and management, bachelors, BA, Clearance, query, SAP, MS Power BI,

Zachary Piper Solutions