Data Architect Consultant

Development InfoStructure LLC.DEVIS)provides exceptional DevSecOps integration in our agile software development and embedded software solutions combined with comprehensive IT management and consulting services toour federal state and local governments. The outcomes of our research and development products and universe of services will support the international development community multiple civilian agencies and the nations defense and intelligence communities. Our focused research services and products include complex DevSecOps solutions to support refugee processing across multiple federal agencies research and development for Signal Intelligence (SIGINT) Command Control Communications Computers and Intelligence (C4I) Data Analytics and Intelligence Surveillance and Reconnaissance (ISR) development and sensor capabilities supporting both the aerospace/defense and intelligence communities as well as complex HHS comprehensive care coding requirements and integrated management systems for our countries civilian agencies (FAA FDIC HOR etc..

Our primary mission is to best serve the needs of our clients by solutioning with our stakeholder teams to ensure that the goals and objectives of our customers are proactively solutioned such that opportunities to invest our time in developing longterm solutions and assets are abundant and move our clients forward efficiently.

At DEVIS we are enthusiastic about our research our work and embracing an environment where all are supported in the mission while maintaining a healthy worklife balance.


Overview
This roleassess and evaluates current Department of State (DOS) Refugee Processing Center (RPC) endtoend data architecture including all systems servers and processes for data extraction from ServiceNow data storage and querying in the Data Lake data curation and transformation into custom Common Data Models (CDMs) preparing raw data for analysis through cleaning organizing and structuring data in the RPC Data Lake loading data and data reporting in Tableau. The Data Architect must identify inefficiencies in the RPC data architecture and recommend modern costeffective technological solutions for an improved architecture that provides nearrealtime data processing analysis and reporting with optimized technical resources. This position is a parttime opportunity lasting approximately 3 months. There is the potential for an extension based on performance and business needs.

Responsibilities

• Conduct a detailed analysis of the current RPC data architecture focusing on data extraction from ServiceNow review CDM processes recommend improvements and provide more efficient ways to achieve data delivery processes for SSRS and Tableau.
• Conduct an endtoend analysis of the data flow storage from extraction to transformation and report delivery.
• Review system design infrastructure and configuration of the current data architecture.
• Evaluate the suitability of current data and infrastructure tools for the desired nearrealtime data processing.
• Identify and document key pain points in the data pipeline such as data latency scalability limitations performance bottlenecks and processing times or integration between systems.
• Assess the performance of the current data systems with a particular focus on the efficiency and speed of data extraction transformation and delivery.
• Identify and benchmark areas where the system is underperforming and propose measurable performance metrics.
• Assess the feasibility of upgrading existing tools or implementing new technologies to improve performance.
• Provide recommendations for optimizing data flows to achieve nearrealtime processing.
• Recommend industry best practices for data architecture in similar environments.
• Provide a comprehensive report detailing the findings from the assessment of the current data architecture. Evaluate critical issues inefficiencies and potential risks within the existing system.
• Outline strategic and technical recommendations for rearchitecting the data pipeline to support nearrealtime processing analysis and reporting.
• Propose continued use or new data tools system upgrades or reconfigurations that meet organizational data and reporting needs taking into consideration DOS Bureau of Diplomatic Technology (DT) US Government and other Federal data requirements.
• Provide recommendations for handling risks and potential challenges to the proposed architecture.
• Provide charts diagrams and data showing a phased implementation roadmap detailing the steps required to transition to the proposed rearchitected system. Include timelines resource requirements key milestones and a breakdown of potential impacts during each phase.

Required Skills and Qualifications

• 10 to 15 years of demonstrated expertise in designing implementing and managing complex cloud data systems and architecture.
• Recognized as a subject matter expert in Federal data services with proven experience and references in advising on best practices and innovations.
• Evidence of providing strategic guidance and thought leadership on interagency data environments including participation in industry panels publications or leadership roles.
• Handson experience with ServiceNow and AWS GovCloud with a strong preference for consultants who can demonstrate practical application in Federal settings.
• Ability to communicate complex technical solutions effectively simplifying concepts for nontechnical stakeholders and tailoring communication styles to diverse audiences

Devis is an AA/EOE/M/F/Disabled/VET Employer committed to providing equal employment opportunity without regard to an individuals race color religion age gender sexual orientation veteran status national origin or disability.