BI Cloud Engineer (Top Secret)

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 prem intelligence application to the AWS cloud.

Clearance: Active Top Secret Clearance

Location: Washington, D.C., Chantilly, VA, Quantico, VA, Huntsville, AL

Responsibilities 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

• Create connections using adapters

• Create TIBCO stored procedures

• Create TIBCO Excel, HTML, and PDF Reports

• Edit master files and access files

• Create jobs in Reportcaster

• Work with DB Visualizer to connect directly to AWS Redshift to analyze data stored outside of TIBCO WebFOCUS

• Develop design documentation to ensure the process and quality control and to preserve system knowledge

• Work in a fast-paced Agile environment with fluid requirements and changing priorities

Qualifications of the BI Cloud Engineer:

• Bachelors degree and 2+ years of related experience in data engineering and/or business intelligence development

• Minimum Top Secret clearance

• Minimum 2 years of experience working with TIBCO WebFOCUS (or similar Business Intelligence tool) Client Server

• Minimum 2 years of experience working with TIBCO WebFOCUS (or similar BI tool) Data Migrator

• Minimum 1 years of experience working with TIBCO WebFOCUS (or similar BI tool) Report Server

• Minimum 1 year of experience working with Aurora PostgreSQL (or a relational DB, such as Oracle)

• Minimum 1 year of experience working with AWS Redshift

• Minimum 1 year of experience working with DB Visualizer (or an equivalent DB Programming software)

• 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: $115,000 - $135,000 + based on years of experience

• Fully funded program - 3 years remaining

• Full Benefits: PTO, Paid Holidays, Cigna Medical, Dental, and Vision, 401k with ADP

Keywords: 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,