Data Engineer (Mapping and Transformation)



Data Science
Posted on Thursday, February 1, 2024
At IBM, work is more than a job – it’s a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you’ve never thought possible. Are you ready to lead in this new era of technology and solve some of the world’s most challenging problems? If so, lets talk.

Your Role and Responsibilities

Octo, an IBM company, is an industry-leading, award-winning provider of technical solutions for the federal government. At Octo, we specialize in providing agile software engineering, user experience design, cloud services, and digital strategy services that address government’s most pressing missions. Octo delivers intelligent solutions and rapid results, yielding lower costs and measurable outcomes.

Our team is what makes Octo great. At Octo you’ll work beside some of the smartest and most accomplished staff you’ll find in your career. Octo offers fantastic benefits and an amazing workplace culture where you will feel valued while you perform mission critical work for our government. Voted one of the region’s best places to work multiple times, Octo is an employer of choice!


As a Data Engineer (Mapping and Transformation), you will be joining the team that is deploying and delivering a cloud-based, multi-domain Common Data Fabric (CDF), which provides data sharing services to the entire DoD Intelligence Community (IC). The CDF connects all IC data providers and consumers. It uses fully automated policy-based access controls to create a machine-to-machine data brokerage service, which is enabling the transition away from legacy point-to-point solutions across the IC enterprise.


We were founded as a fresh alternative in the Government Consulting Community and are dedicated to the belief that results are a product of analytical thinking, agile design principles and that solutions are built in collaboration with, not for, our customers. This mantra drives us to succeed and act as true partners in advancing our client’s missions.

Program Mission…

The CDF program is an evolution for the way DoD programs, services, and combat support agencies access data by providing data consumers (e.g., systems, app developers, etc.) with a “one-stop shop” for obtaining ISR data. The CDF significantly increases the DI2E’s ability to meet the ISR needs of joint and combined task force commanders by providing enterprise data at scale. The CDF serves as the scalable, modular, open architecture that enables interoperability for the collection, processing, exploitation, dissemination, and archiving of all forms and formats of intelligence data. Through the CDF, programs can easily share data and access new sources using their existing architecture. The CDF is a network and end-user agnostic capability that enables enterprise intelligence data sharing from sensor tasking to product dissemination.


  • Understand and work with controlled vocabularies and term assignment, including IC Trusted Data Format (TDF) and Enterprise Data Header (EDH) as defined by the ODNI
  • Work with project teams and stakeholders to gather and analyze data mapping requirements, and develop data mapping and transformation crosswalk packages
  • Create and document data mapping and transformation crosswalk requirements packages, detailing source and destination fields, structure, data types, and transforms
  • Work closely with stakeholders to understand data requirements and ensure that data is accurately mapped and transformed to meet those requirements
  • Collaborate with developers, testers, and subject matter experts to ensure that data mapping and transformation requirements are properly implemented and tested
  • Develop and maintain data mapping and transformation documentation to ensure accuracy and consistency over time
  • Stay up to date with emerging trends and technologies in data mapping and transformation, and recommend improvements to the organization’s data integration practices

Years of Experience: 10+ years of experience performing data mapping and transformation activities in a complex, enterprise-level environment.

Education: Bachelor’s degree in Computer Science or a related field (preferred)

Location: Chantilly, VA

Clearance: Active TS/SCI w/ ability to obtain CI Poly

Required Technical and Professional Expertise

  • Strong understanding of data mapping and transformation principles and methodologies
  • Experience creating and documenting data mapping and transformation crosswalk requirements packages, detailing source and destination fields, structure, data types, and transforms
  • Ability to gather and analyze data mapping requirements, and develop and document data mapping and transformation rules and algorithms
  • Excellent communication and interpersonal skills, with the ability to work effectively with project teams and stakeholders at all levels
  • Strong analytical and problem-solving skills, with the ability to identify data mapping and transformation issues and develop effective solutions
  • Experience using data mapping and transformation software and tools
  • Clearance: Active TS/SCI w/ ability to obtain CI Poly

Preferred Technical and Professional Expertise

· Experience or expertise using, managing, and/or testing API Gateway tools and Rest APIs (desired)

· 2+ Experience in Python Development

· Experience or expertise configuring an LDAP client to connect to IPA (desired)

· Advanced organizational skills with the ability to handle multiple assignments

· Strong written and oral communication skills