Job Description
The architect designs and builds SQL Server data warehouses to store financial and budgetary data for enterprise use. Migrating data from Oracle databases using Microsoft tools ensures seamless transitions. Configuring databases on Windows 2022 and SQL Server environments addresses long-term data needs. Creating migration plans and executing transfers moves budget data from 2017 onward effectively. Supporting business intelligence dashboards involves data analysis and problem-solving for operational compliance.
ManTech provides advanced solutions in digital transformation, cybersecurity, IT, data analytics, and software development for government intelligence departments. With a focus on national security, the firm serves Department of Defense paths since 1968. Leading in mobile treatment centers and portable deployment models, ManTech delivers impactful services. The organization emphasizes innovation in Federal Civilian sectors.
Work entails configuring SQL Server databases, performing ETL processes, and developing data models. Interactions include collaborating with clients for data needs and supporting team members on reports. Structure requires on-site presence in Tampa Florida with possible travel. One challenge involves handling large datasets during migrations. Hourly availability off-hours demands quick responses to issues.
The role requires active Top Secret clearance and may need TS SCI. Physical demands include stationary positions for 50% of the time. Flexible shifts accommodate varying operational needs. No compensation details provided. Professional development focuses on certifications like CompTIA Security+. Accommodations available for disabled applicants.
Responsibilities
- Design build SQL Server data warehouse financial budgetary data
- Provide database design administration maintenance PPBE data
- Migrate data Oracle data warehouse SQL Server
- Create execute Data Migration Plan budget data 2017 current
- Provide support team members business intelligence dashboards reports
Requirements
- Bachelor's degree Computer Science Information Technology Software Engineering Data Science STEM related or 8 years experience
- 8 years data architecture roles with data modeling database design data integration
- Proficiency data modeling database design data warehousing ETL processes
- Experience developing maintaining data models data dictionaries
- Data quality checks implementation
- Demonstrated proficiency Microsoft SQL Server
- Proven data warehouse ETL experience design
- Experience SQL Server Migration Assistant Oracle SSMA
- Data migration SQL Server Integration Services SSIS
- CompTIA Security+ certification
- Top Secret clearance