Zachary Piper Solutions is looking for a Data Warehouse Architect with an active Top-Secret Clearance to join a Data Warehouse and BI development team supporting our federal client. This position will be on-site in one of the Chantilly, VA. The Data Warehouse Architect will be supporting a federal program with the FBI as they migrate their platform to the cloud.

Responsibilities for the Data Warehouse Architect:
• Lead the development and deployment of new and/or enhanced data solutions throughout the business.
• Ensure that data development projects meet business requirements.
• Perform data evaluation, then identify potential problems areas.
• Review and analyze existing data solutions to improve data governance.

Required Qualifications for the Data Warehouse Architect:
• 4+ years of experience working with relational databases (Oracle, AWS, Redshift, and Postgres)
• Top Secret Clearance required.
• Strong knowledge of ETL Process, data modeling, data designs, and data migration
• Knowledge of financial data and Momentum system is a plus.

Compensation and Benefits:
• Salary Range: $125,000-$155,000
• Full Benefits: Cigna Medical, Dental, Vision, 401k, etc.

Data warehouse, architect, ETL, SQL, BI tools, data modeling, AWS, Azure, Snowflake, Big Query, Hadoop, Spark, Python, data governance, dimensional modeling, OLAP, performance tuning, data integration, data migration, metadata management, Chantilly, Virginia, Huntsville, Alabama, Quantico, Washington, DC, Oracle, Redshift, Postgres, Top-Secret, Clearance, momentum, system, finance, data analytics, federal, FBI.