Ambit GreenZone has a need for a Sr Data Engineer to work closely with a federal client on an exciting project that enables the development and implementation of innovative technologies and analytics to track insider threat matters. This position will focus on the strategy, design, development, and deployment of interactive Tableau Dashboards, along with the ability to be a part of the technical design team to propose future solutions and tools/technology recommendations. The Sr Data Engineer must have detailed knowledge of enterprise architecture and development of a data dictionary based on DHS/TSA policy. This position requires work to be performed at onsite and off-site facilities in both classified and unclassified environments within the Washington, DC, National Capital Region (NCR). This position offers an excellent opportunity to be part of a high-performing team responsible for supporting a high-velocity collaborative environment, along with tremendous growth potential. If you are interested in a challenge and a great working environment, apply today!

Responsibilities:

The specific duties include but are not necessarily limited to the following:

• Develop and elicit User Activity Monitoring (UAM) and User Behavior Analytics (UBA) Enterprise Solution technical requirements.
• Experience identifying databases that are located within other program offices and other interagency organizations.
• Prepare and present formal design documentation, including drawings, plans, spreadsheets, and specifications that address future needs and support the approved design objectives.
• Develop and maintain a common data dictionary format and data dictionary that contains type and variation of field format from defined data specification, type, and variation of valid values from data specification, and number of rows submitted by data element/layer/table/text file.
• Develop an architectural solution for a data repository utilizing National Archives and Records Administration (NARA) guidelines.
• Design and present a plan for an integrated data storage solution and an integrated enterprise disaster recovery/backup solution.
• Provide technical requirements on how to visualize data from UAM, UBA, and other data sets.
• Provide recommendations on discovering abnormalities and unknown threats using the various data sets contained in the data dictionary.
• Support the development of the Capabilities Analysis Report.
• Experience with data normalization strategies.
• Provide strategy, policy, and governance support focusing on long-term data collection, management, storage, and sharing of a growing inventory of data.
• Provide architecture and planning support to determine a suitable repository for program data and work with the Senior Architect to evaluate current architecture and recommend technical architecture and tools for the data warehouse, repository, workflow.
• Work closely with government stakeholders to gather requirements, design solutions, and maintain dashboards and visualization. Excellent communication and collaboration skills are a must.
• Be able to support data analysis and extraction of information not only from traditional IT data sources, but also from non-traditional sources such as door access logs
• Leverages industry-standard networking, storage, and visualization activities with a human-centered design (HCD) approach to collect, analyze, and correctly interpret data across the enterprise, and to translate that complex data into actionable recommendations and self-service resources.

Additional Duties May Include:

• Lead a team conducting analysis and development of customer-driven technical data architectures and solutions
• Design, plan, and integrate a data-intensive application framework using modern data-centric enabling technologies, cloud computing and virtualization architecture
• Provide specific, detailed information for technology implementations, application & data migration techniques and tools for the most efficient solution to meet mission needs, including present and future capacity requirements
• Expertise in determining the approaches for making heterogeneous data sources broadly available for discoverability and access to support a wide consumer-base, analytic needs, and use by diverse applications, services, and systems
• Develop a white paper with the identification and recommendations regarding which UAM solution could be the best fit for each component, if an enterprise solution would benefit the department, and possible cost savings for each approach
• Determine network route(s) from each component to ensure proper delivery of data sets
• Create network diagrams and facilitate associated white paper for each component that explains the movement of data
• Provide recommendations on design objectives for the Insider Threat Program (ITP) network architecture including reliability of business operations, data storage, increased protection against cyber security threats, increased accessibility, flexibility, and expansion
• Develop and deliver a transition plan for the program office from Technical Evaluation and Delivery to an Internal Verification and Validation (IV&V)
• Use technical expertise to evaluate and report on new cloud technologies and architectural approaches

Desired Skills and Experience:

• Experience working with other BI and Visualization tools, such as PowerBI or Qlik.
• Full SDLC and technical design and architecture experience.
• Experience as a consultant in a highly visible role.

Required Skills and Experience:

• Must be a U.S. Citizen
• Ability to obtain a Public Trust and have an Active TS/SCI is required
• BA/BS in a technical field such as Computer Science, Information Systems, IT, or related field. BA/BS in Communications, Information Technology, or a related field.
• Advanced degree is a plus.