Data Warehouse/Data Management Analyst

Summary

Join Teracore, a Service Disabled Veteran Owned Small Business, as we support the Department of Homeland Security (DHS) in migrating financial data to a business intelligence tool. This role requires supporting data migration activities, including requirements gathering, data mapping, script development, testing, and validation. You will evaluate and recommend DBMS products, assist with data transformation and load testing, and ensure data accuracy throughout the migration process. The position demands strong technical skills in ETL, SQL, TOAD, and EBS, along with excellent communication and documentation abilities. A successful candidate will have 3-5 years of experience and a Master's degree. US Citizenship and a background investigation are required.

Requirements

• US Citizenship Required / Background Investigation required to attain favorable entry on duty (EOD)
• 3-5 years
• Masters Degree
• Ability to review and document data correctness or anomalies
• Experience with data conversions
• ETL, SQL, TOAD and EBS experience is required
• Excellent writing skills – ability to write professional quality data plans
• Must have excellent oral communications skills and the ability to make a positive contribution in meetings
• Able to develop working relationships with client
• Data Migration and Business Intelligence Reporting Planning

Responsibilities

• Support data migration activity timelines for mock conversions and production deployment, and implementation of a business intelligence reporting tool
• Map the data in the prescribed format and conversion templates
• Assist with data transformation and data load testing
• Assist with reconciling data conversion efforts during migration efforts
• Assist with verifying and validating data transformation
• Assist with pre- and post-validation data load testing
• Assist with validating data in mock conversions and the full migration
• Assist with unit and end-to-end integration testing to ensure the flow of data from the source applications to the target applications is accurate
• Assist with documenting the end-to-end data migration test results and a lesson learned report
• Assist in development of data storage for legacy/non-migrated data for reporting. Includes: Review and provide recommendations for new business intelligence technology / applications
• Review and provide recommendations on infrastructure required
• Review and provide recommendations on size required for storage of data
• Assist in the development of reports

Preferred Qualifications

Experience of performing data conversion tasks for full-lifecycle Federal financial system data migration project that is of comparable size and scope