SQL Server Data Warehouse Architect

General Information

Requisition # R63768 Locations USA-FL-Tampa Posting Date 10/17/2025 Security Clearance Required Top Secret Remote Type Onsite Time Type Full time

Description & Requirements

Elevate your career with MANTECH International Corporation! Join a dynamic team dedicated to national security through cutting-edge technology. Since 1968, MANTECH has led in delivering advanced solutions to government intelligence, the Department of Defense, and Federal Civilian sectors. Dive into innovation in Digital Transformation, Cybersecurity, IT, Data Analytics and Software Development. Your journey to impactful work and rapid growth starts now—be extraordinary at MANTECH!

***This is for a future opportunity***

MANTECH seeks a motivated, career and customer-oriented SQL Server Data Warehouse Architect to join our team. This is a remote role that may require occasional travel to Tampa, FL.

Responsibilities include but are not limited to:

• Design, architect, and build the required structure to store and maintain financial and budgetary data.
• Provide technical database design, administration, and maintenance functions necessary for the development of databases that will contain all Planning, Programming, Budgeting, and Execution (PPBE) data utilized by the enterprise.
• Migrate data from Oracle data warehouse to a SQL Server based data warehouse. The required solution utilizes physical servers operating Windows 2022 operating system and SQL server, and virtual machines operating on Windows 2022 server operating system.
• Configure and build the databases and data warehouses in Microsoft SQL Server. Data currently residing in an Oracle 12c relational database must be migrated to SQL Server.
• Create Data Migration Plan and execute the plan to migrate budget data from 2017 to current, from Oracle into the SQL Server data warehouse
• Provide support to other team members responsible for creating business intelligence dashboards and reports.
• Data analysis, problem solving, investigation and creative thinking with large amounts of data supporting a variety of scenarios and work closely with the client to assist in managing data needs and supporting collection of data needed for various operational needs.

Minimum Qualifications:

• Bachelor's degree in a relevant field such as Computer Science, Information Technology, Software Engineering, Data Science, or a related STEM discipline, or 8 years of related experience may be accepted in lieu of the degree.
• Proven experience developing and maintaining data models and data dictionaries
• Proven experience working with and implementing data quality checks to identify errors and address outdated business rules
• Demonstrated proficiency with Microsoft SQL Server
• Proven data warehouse and ETL experience, including data warehouse design
• Proven experience with SQL Server Migration Assistant for Oracle (SSMA) or similar tool
• Data migration experience with SQL Server Integration Services (SSIS)

• Comptia Security+ Certification

Preferred Qualifications:

• Oracle Database Experience

• Experience with TIBCO EBX master data management
• Experience converting OBIEE reports to Power BI.
• Experience implementing Federal financial management systems such as OneStream (highly preferred), Hyperion, or other Corporate Performance Management platforms
• Master's degree in business administration (MBA) or a related field.
• Advanced certifications, such as those related to SQL Server, data warehouses, business intelligence, and Agile methodologies

Clearance Requirements:

• Must have a current/active Top Secret security clearance and may be required to obtain a TS/SCI security clearance.

Physical Requirements:

• Must be able to remain in a stationary position 50%
• The person in this position frequently communicates with co-workers, management and customers, which may involve delivering presentations. Must be able to exchange accurate information in these situations
• Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine and computer printer.

MANTECH International Corporation considers all qualified applicants for employment without regard to disability or veteran status or any other status protected under any federal, state, or local law or regulation.

If you need a reasonable accommodation to apply for a position with MANTECH, please email us at careers@mantech.com and provide your name and contact information.