Your Role and Responsibilities
Primarily responsible for defining and executing a process to document and prioritize data mapping and transformation requirements for the DoD/IC enterprise. Develop detailed data mapping and transformation requirements packages to be used by CDF Master Data Management (MDM) engineers to implement within the MDM system. In this role, you will:
- Define and implement a process to backlog and execute data mapping, tagging and transformation needs
- Create and document data mapping and transformation crosswalk requirements packages, detailing source and destination fields, structure, data types and transforms
- Coordinate with Data Engineers to test and validate data mappings and transformations
- Support the development and implementation of a large-scale ingest / Data Transformation system to support interoperability with legacy systems
- Convert native data into community defined formats for consumption via legacy interfaces
- Document SOPs related to system transformation requirements package creation and execution
Required Technical and Professional Expertise
- Ability to perform data structure mapping (crosswalks), data tagging, and data governance
- Experience in requirements gathering, analysis, and documentation
- Understanding of foundational ETL concepts & COTS/FOSS ETL tools
- Experience organizing, documenting technical information to include schemas and data structures
- Possess a DoD 8570 IAT Level II Certification (e.g. Security+) or the ability to obtain the certification within 90 days
- Clearance : Active TS/SCI w/ ability to obtain CI Poly
Preferred Technical and Professional Expertise
- Familiarity with data modelling, particularly involving the use of semantic data and ontologies/taxonomies/business data
- Experience working with controlled vocabularies and term assignment to improve information retrieval.
- Experience in data catalog development