Cloud Data Engineer - Active Top Secret - Huntsville, AL/ Chantilly, VA/Washington, DC/ Quantico, VA - Piper Companies

Zachary Piper Solutions is seeking a Cloud Data Engineer to join a Data Warehouse and Business Intelligence team supporting our customers migrations from an on-premises Oracle Enterprise Edition data warehouse to Redshift data warehouse in AWS. This opportunity is in Washington, D.C. and will be done through 100% on-site work.

This opportunity requires a Top Secret clearance and the ability to maintain that level of clearance for the duration of employment.

***NO C2C OR 1099***

Responsibilities for the Cloud Data Engineer includes:

·      Work with our data warehouse engineer and AWS solutions architect to move the current on-premises TIBCO WebFOCUS application to the AWS cloud

·      Implement changes to objects and code to support cloud migration tasks

·      Create TIBCIO stored procedures, TIBCO Excel, HTML, and PDF reports

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

Qualifications of the Cloud Data Engineer includes:

·      5+ years of experience minimum

·      Must possess a minimum of a Top Secret clearance

·      Experience with writing PL/SQL code to carry out ETL form an OLTP system to a Dimensional Data Warehouse for both complete loads and incremental loads

·      Knowledge and a deep understanding of AWS services (like Redshift), applications, and best practices for AWS architecture

·      Hands on experience in different domains such as business analytics and database architecture

Compensation for the Cloud Data Engineer include:

·       Salary Range: Up to $170,000 **based on experience**

·       Benefits: Paid Holidays, Medical, Dental, Vision, 401K, etc.

Keywords: TIBCO, WebFocus, Redshift, AWS, PL/SQL, data warehouse, data warehousing, cloud engineer, Business Intelligence, soar, Splunk, python, soar engineer, bachelor degree, clearance, hybrid, system engineering, ground systems, C++, Python, MATLAB, Julia, satellites, secret, security clearance, flight, aviation, aerospace, Kent, Washington, On site, integration, testing, requirements, C, C#, C++, system engineer, test, testing, test & integration, integration, integrating, space, space & launch, space and launch, agile, risk management, command, command and control, regression, aerospace, ground system, ground segment, database, validation, network, system drawing, ts/sci, top secret, sci, sensitive compartmented information, security clearance, DOD, department of defense, aircraft, space, space system, aerospace engineering, system architecture, STEM, network interfaces, engineer, engineering, regression testing, Federal, satellite, launch, hardware, software, test technology, propulsion, security clearance, security+, AWS, cloud, spacecraft, full time, W2, California, ground system engineering, verification and validation, networks, networking, federal systems, software integration, design, build, polygraph, CI polygraph, counter intelligence, full scope, FSP, on-site, SCIF, data migration, cloud, network security, matlab, system, c++, python, Julia, conops, satellite payloads, system design, satellite software, test plans, satellite, systems engineering, software development, flight simulation, model based systems design, mbse, model engineering, guidance navigation and control, guidance navigation, gps, embedded systems engineering, embedded systems, ts/sci, ts, sci, clearance, security clearance, dod, kent Washington, Washington state, Kent Washington, GNC, C++, NetOps, NetworkOps, Net Ops, network operations, CASP, CISA, CISSP, CCNP, CCNA, transitioning veteran, veteran, IT, military, army, navy, national guard, data integrator, data scientist, terraform, AWS, Azure, Google Cloud, cloud, migration, consulting, engineer, CloudFormation, Solutions, infrastructure, functionality, SQL DBA, SQL, SQL database, MS SQL Server, MS SQL, Microsoft SQL, Tableau, Power BI, Crystal, Crystal Reports, SQL Server Report Builder, MS SSRS, SSRS, Database administrator, SQL, DBA, Windows, ACAS, STIG’s, STIGS, HBSS, server, server maintenance, Sec+, Security+, IAT, CompTIA, certification, Active Directory, PowerShell, scri[ting, windows deployment server, WDS, AD, PKI, Smart Card Login, Windows 2016, Windows 2010, desktop, DevOps, dev ops, fsp, full scope, full-scope, polygraph, poly, data bricks, AWS, YAML, python, java, EC2, S3, cloud formation, Nifi, Pentaho, Apache airflow, UI/UX, Lifecycle, Jenkins, Git, Puppet, DOD, Secret, Top Secret, SAS, R Studio, SPSS, Python, Power BI, Secret Cleared, Top Secret Cleared, TS/SCI Cleared, Laboratory, Data, Data gathering science, DHA, public health, health science, DoD, Department of Defense, Life Cycle Sustainment Plan, Acquisition Strategy, Simplified Acquisition Management Plan, Level of Repair Analysis, Source of Repair Analysis, Logistics Demonstration Planning and Execution, Product Support Package, Technical Manual Development and Finalization, Equipment Standardization, Memorandum of Agreements/Understanding, CDRL Reviews, Property Accountability of all GFE, APSR System updates, IUID Plan, biometrics, life cycle sustainment, life cycle, DoD, CPI, secret clearance, secret, SF, military, accounting, audit readiness, Finance, fund receipt, audit, auditor, financial, financial analyst, Disbursement, Military Pay, Civilian Pay, Travel Pay, Reimbursement Budget Authority and Execution, Contract Pay, Vendor Pay, Data Analysis, Machine Learning Engineer, Data Architect, Military Health, Data Operations Engineer, epidemiologist, disease control, COVID-19, Data Mining, Data Warehousing, Data Modeling, Data Visualization, DoD, CISA, security controls assessor, security control, security, CISSP, CISM, MCSE, CAP, FISMA regulation, FIPS standards, NIST 800 series, NIST Special Publications, Risk Management Framework, IT security, infrastructure, vulnerability assessment, reporting, firewalls, VPN, Data Loss Prevention, IDS/IPS, Web-Proxy, security audits, .Net, .net, SQL, server, framework, Kendo UI, query, data, integration, deduplication, interface, SAFe, agile, reconciliation, Jira, confluence, COTS, OS patching, VersionOne, NetApp, Linux, Linux, windows, Windows, Cloud, Commvault, active directory, Ansible, Jenkins, AccuRev, Gitlab Tetradic, PCoIP, scripting, remote display protocols, SharePoint, SharePoint, SharePoint, .NET, C#, developer, virtual machines, VMware VCenter hypervisor, Citrix XenDesktop, XenApp, Desktop Director, systems engineer, engineer, system, systems, systems engineering, Citrix, Citrix, secret, system admin, administrator, systems administrator, contracts, contract, contracts specialist, contract specialist, procurement, PD2, procurement desktop, technical writing, technical editor, editor, cybersecurity, cyber security, secret, TS, Top Secret, top secret, sci, clearance, government, DARPA, TS/SCI, DHS, federal, technical writer, business analyst, CONOPS, SOPs, standard operating procedures, sec+, security+, ITIL, ITILV4, adobe, Microsoft office, MS, .NET Framework, C#, AngularJS, Hyper Text Markup Language" OR "HTML" OR "AJAX" OR "ASP.NET" OR "XML" OR "JavaScript" OR "jQuery" OR "CSS" OR "Microsoft SharePoint Designer" OR "SharePoint Workflows" OR "Web Services" OR "REST" OR "Keyword Query Language" OR "KQL" OR "SharePoint Server" OR "Internet Information Server" OR "IISsuite, SCI, sensitive compartmented information, operation procedures, mission notes, editing, 508 compliance, documentation, cyber, APT, advanced persistent threat, incident management, incident response, concept of operations mitigation plan, incident response, PTO, Arlington, Virginia, on-site, onsite, on site, benefits, 401k, medical, homeland security, DOD, ci polygraph, counterintelligence, cyber intelligence, cyber investigation, cybersecurity investigation, PTO, technical writing, technical writer, business analyst, technical analyst, technology write, air force, digital forensics, project management, Jira, army, military, Patrick space force base, Patrick SFB, SFB, Lompoc, California, CA, cocoa beach, satellite beach, space, research, technology research, technical investigations, secret clearance, ts/sci, top secret, ts, secret clearance, dod, clearance, clearance, cloud project, aws, azure, veterans, retired veterans