Ascension LLC is seeking a Database Specialist / Data Systems Analyst to support mission-critical federal initiatives involving database design, PRISM data extraction, system migration, testing, and data integrity validation. This role is essential to ensuring that enterprise data environments are structured, reliable, and optimized to support program operations, reporting, and decision-making.

The ideal candidate is a technical expert in database architecture and data migration, with experience supporting federal systems, data extraction processes, and system transition efforts. This individual will play a critical role in ensuring data accuracy, system continuity, and seamless migration of legacy data into modernized environments, directly impacting program performance and compliance.

This position is well-suited for professionals with strong experience in data engineering, database administration, and systems integration, who thrive in environments requiring precision, problem-solving, and cross-functional collaboration.

Position Summary

The Database Specialist will support Task 4.3 – Database Development, Migration, Testing, and Data Extraction, focusing on designing database structures, extracting PRISM data, supporting system transitions, and validating data integrity.

This role requires a detail-oriented and analytical professional who can work independently in a fast-paced environment while coordinating with program, technical, and acquisition teams. The candidate will be expected to anticipate data challenges, design efficient solutions, and ensure high-quality data outputs that support reporting, compliance, and operational needs.

The Database Specialist will leverage tools such as SQL Server, Oracle, Power BI, ETL tools, and Microsoft Power Platform, and will apply best practices in data governance, data validation, and system integration.

Ascension brings deep experience in data architecture, analytics, and process automation across DHS, DOE, and FEMA, where we have successfully developed data systems, dashboards, and automated workflows to improve data accuracy and decision-making .

Key Responsibilities / Day-to-Day Activities

• Design and develop database structures to support program data requirements
• Extract data from PRISM and other federal systems for analysis and migration
• Support system transition activities, including legacy-to-modern data migration
• Validate data integrity through testing, cleansing, and reconciliation processes
• Develop and execute data migration plans, including mapping and transformation rules
• Perform database testing to ensure accuracy, completeness, and system functionality
• Collaborate with stakeholders to define data requirements and reporting needs
• Maintain data dictionaries, metadata, and documentation for database structures
• Identify data quality issues and implement corrective actions
• Develop scripts, queries, and automated processes for data extraction and validation
• Support reporting and analytics efforts through structured data outputs
• Ensure compliance with data governance, security, and federal data standards
• Troubleshoot database issues and provide technical support during system transitions
• Participate in system integration and testing activities across platforms