RFQ Attachment 1_ADaPTS 2.0_SOW Appendix A - BPA LCAT Descriptions (12.04.2024).pdf

Labor Categories (LCATS) Minimum Years of Experience LCAT Definition

Administrative Specialist, Junior 3

Administrative Specialist, Mid 5

Administrative Specialist, Senior 7

Analyst, Junior 3

Analyst, Mid 5

Analyst, Senior 7

ADaPTS 2.0 Statement of Work Appendix A: Labor Category (LCAT) Descriptions

Understanding business requirements so that they may be accurately translated in system requirements. Understanding the design of simple information systems so that functional issues may be understood and business requirements can be properly defined for software development.

Conducting trade-off analysis on business and technical requirements. Assisting in the development of procedures, manuals and other documentation for complex information systems.

Understanding business requirements so that they may be accurately translated in system requirements. Understanding the design of moderately complex information systems so that functional issues may be understood and business requirements can be properly defined for software development. Helping to define how information systems may be upgraded or replaced.

Conducting trade-off analyses on business and technical requirements. The ability to quickly develop a working understanding of the applicable programming languages, operating systems and databases that will be used on the projects and programs. Developing procedures, manuals and other documentation for information systems. Overseeing work of Analysts on specific tasks.

Assists management in all business, cost containment and accounting activities. Assists management in office administration, contract administration and facility operation activities.

Responsible for providing cost control advice to other managers. Supervises subordinate administrative and office staff. Bachelor's degree. Equivalent experience or training may be substituted for a degree.

Application Security Analyst, Junior 3

Application Security Analyst, Mid 5

Application Security Analyst, Senior 7

Associate 2 Supports the project team across the entire SDLC lifecycle in performing requirements analysis, software design, development, installation, testing, and maintenance for application system components for software.

Associate, Senior 2+

Senior Associate will lead teams, own deliverable development, and communicate with project management to support overall delivery. The Senior Associate may perform requirements analysis, software design, development, installation, testing, or maintenance for large scale implementations or systems integration efforts.

Determines enterprise information assurance and security standards. Develops and implements information assurance/security standards and procedures. Coordinates, develops, and evaluates security programs for an organization. Recommends information assurance/security solutions to support customers’ requirements. Identifies, reports, and resolves security violations. Establishes and satisfies information assurance and security requirements based upon the analysis of user, policy, regulatory, and resource demands. Supports customers at the highest levels in the development and implementation of doctrine and policies. Applies know-how to government and commercial common user systems, as well as to dedicated special purpose systems requiring specialized security features and procedures. Determines enterprise information assurance and security standards. Develops and implements information assurance/security standards and procedures. Coordinates, develops, and evaluates security programs for an organization.

Recommends information assurance/security solutions to support customers’ requirements. Identifies, reports, and resolves security violations. Establishes and satisfies information assurance and security requirements based upon the analysis of user, policy, regulatory, and resource demands. Supports customers at the highest levels in the development and implementation of doctrine and policies. Applies know-how to government and commercial common user systems, as well as to dedicated special purpose systems requiring specialized security features and procedures.

Cloud Platform Engineer, Junior 5

Cloud Platform Engineer, Mid 7

Cloud Platform Engineer, Senior 10

Computer Forensics Specialist, Junior 3

Computer Forensics Specialist, Mid 6

Computer Forensics Specialist, Senior 15

Configuration Manager, Junior 2

Configuration Manager, Mid 4

Configuration Manager, Senior 6

Responsible for migration strategy to the public cloud, working with internal product teams to build and implement cloud solutions on an enterprise scale. Work closely with engineering teams to implement cloud-based solutions and data services. Design application cloud environments and demonstrate Technical Cloud Architectural knowledge. Document standards and processes of migration methodologies and techniques for large scale applications. Drive experiments to evaluate new technologies and methodologies to accelerate project delivery. Work with product architects and engineering teams to build new capabilities based on cloud-native technologies.

Bachelors of Science degree. Equivalent experience or training may be substituted for a degree.

Implements and documents IT network exploitation and defense techniques to include deterring, identifying and investigating computer and network intrusions; computer, surveillance/ monitoring, vulnerability assessments, penetration tests of information systems, disaster recovery analysis, secure network design, audits of information security infrastructure and policy;

computer exploitation and reconnaissance. Implements and documents custom tool development, modification and analysis; target mapping and profiling; and, network decoy and deception operations in support of computer intrusion operations. Implements and documents forensics services to include evidence seizure, computer forensic analysis and data recovery. Bachelor's degree. Equivalent experience or training may be substituted for a degree.

Without direct supervision, responsible for managing the configuration of but not limited to:

physical client and server hardware products and versions. Operating system software products and versions. Application development software products and versions. Technical architecture product sets and versions as they are defined and introduced. Live documentation. Networking products and versions. Live application products and versions. Definitions of packages of software releases. Definitions of hardware base configurations. Configuration item standards and definitions. The Configuration Manager shall help minimize the impact of changes; provide accurate information on CIs; improve security by controlling the versions of Configuration Items (CIs) in use; and project and program planning.

COTS Specialist, Junior 7

COTS Specialist, Mid 11

COTS Specialist, Senior 15

Database Administrator (Oracle and SQL), Junior 3

Database Administrator (Oracle and SQL), Mid 5

Database Administrator (Oracle and SQL), Senior 7

Database Architect, Junior 5

Database Architect, Mid 7

Database Architect, Senior 10

Establishes information requirements, using analytical methods, for enterprise-wide or large-scale IT systems. Designs architectures that include software, hardware, and communications solutions to support the total requirements, as well as provide for present and future cross- functional requirements and interfaces. Ensures architectures are in compliance with open systems standards as they apply to the client’s environment. Evaluates compatibility of information system development efforts with agency architectures and recommends adjustments, as appropriate.

Evaluates analytically and systematically problems of workflow, organization, and planning and develops appropriate corrective action. May provide consulting support on complex tasks and daily supervision and direction to staff. (May include technical knowledge of workflow processes, document management systems, document imaging software, network requirements, and imaging hardware.) May provide guidance and technical supervision to more junior architects. Bachelors of Science degree. Equivalent experience or training may be substituted for a degree.

Exhibits an exceptional degree of knowledge specific to the pertinent subject matter. Advises and/or applies highly advanced IT technologies, scientific principles, theories and concepts.

Viewed as expert within the field. Develops information which extends knowledge in a given field. Information may form the basis of newly developed concepts, theories, and products. Often acts independently to uncover and resolve issues associated with the development and implementation of operational programs. Work is checked only to the effectiveness of results obtained, typically requiring a long-term perspective. Virtually self-supervisory.

Providing technical expertise to create detailed database designs and documenting the results, including data models and flow diagrams. Evaluating, configuring and optimizing databases to meet user requirements. Determining data organization, indexing methods, and security designs for databases. Planning and coordinating the conversion or migration of existing (or legacy) databases to state of the art RDBMS. Defining and creating databases for applications.

Managing development and operational databases, as well as performing maintenance actions and patches to sustain their health.

Developer, Junior 3

Developer, Mid 7

Developer, Senior 10

Applying expertise in software development to solving business issues with minimal supervision and assistance. Designing and developing documents and tests, as well as maintaining applications in a selected programming language or environments. Working with analysts and customers to derive requirements for use cases/scenarios, determining the feasibility of design within time and cost constraints, and consulting with hardware engineers and other engineering staff to evaluate the interface between hardware and software. Planning, designing and programming functionality to interface and use SQL Server or Oracle in coordination with the Database Administrator. Planning, designing and programming user interfaces. Facilitating meetings to determine the validity and priority of issues found within products both internally as well as those reproduced that are logged through Technical Support. Investigating, identifying and resolving code and/or complex issues logged internally by our QA team and externally by our Clients through Technical Support. Staying current with associated technology advances in the marketplace and growing skills. Troubleshooting and resolving application issues. Ability to clearly communicate technical concepts to both technical and non- technical users. Possessing good client-facing interpersonal skills (i.e., comfortable and effective acting as liaison between multiple technology groups and representing groups in large scale meetings). Having experience in all phases of the systems engineering life cycle (SELC) including initial design/analysis through deployment and Operations & Maintenance (O&M). Designing and developing documents and tests and maintaining applications in a selected programming language or environment. Planning, assigning work when acting in a lead role, determining designs, collecting metrics on all associated development tasks, coding, debugging, creating documentation, conducting tests and building applications on a predefined schedule. Producing and implementing design specifications, documenting design modifications and unit testing results. Identifying and working with strategic and technology partners to discover new product solutions. Designing, developing and maintaining automated deployment processes and best practices for SharePoint solution deployments to multiple environments (features, WSPs, etc.).

Maintaining current industry knowledge of development concepts, best practices and procedures as the technology base evolves. May have to supervise subordinate software programmers and assist in their creation of a quality product.

DevOps Engineer 3

DevOps Engineer 5

DevOps Engineer 7

Financial Analyst, Junior 3

Financial Analyst, Mid 7

Financial Analyst, Senior 10

Graphic Artist, Junior 3

Graphic Artist, Mid 5

Graphic Artist, Senior 7

Provide expertise in Financial Management, and share knowledge of Financial Management industry standards and best practices, while being able to adjust and tailor accordingly based on the Government’s methodology and requirements. Perform financial reporting. Prepare Memorandum of Agreements to include cost analysis. Manage financial burn on various activities such as Data Center, MOAs, and IAAs etc. Ensure funds are received, utilized, and allocated per Government requirements. Utilize tools as specified by the Government (i.e., reporting, management tools, etc.). Deliver defined reports per the agreed to schedule and, where applicable, ad-hoc reports. Provide ad hoc financial management support, as needed.

The DevOps Engineer has experience serving as the engineer of complex technology implementations in a product-centric environment. They are comfortable with bridging the gap between legacy development or operations teams and working toward a shared culture and vision.

They work tirelessly to arm developers with the best tools and ensuring system uptime and performance. Primarily responsible for but not limited to: Deploying and configuring services using infrastructure as a service providers (e.g., Amazon Web Services, Microsoft Azure, Google Compute Engine, RackSpace/OpenStack). Configuring and managing Linux-based servers to serve a dynamic website. Debugging cluster-based computing architectures. Using scripting or basic programming skills to solve problems. Installation and management of open source monitoring tools. Configuration management tools (e.g., Puppet, Chef, Ansible, Salt).

Architecture for continuous integration and deployment, and continuous monitoring.

Containerization technologies (e.g., LXC, Docker, Rocket). Perform the Operations Support and Maintenance on applications of various sizes and complexity

Creates visual graphics, illustrations, graphs and images for program illustrations, newspaper and magazine publications, or for any client need. Provides creativity, taste, and design for aesthetic interests (may be for hard copy, slides, web sites, etc.). Plans, lays out, and execute illustrations in black and white or color, and illustrates technical or scientific materials in one or more of the commonly-used art media, using applicable COTS computer tools to support client’s requirement.

Uses artistic ability to create and select attractive and effective graphics and color choice.

Bachelor's degree in a related field such as Computer Graphics, Desktop Publishing, and/or graphics-related hardware. Equivalent experience or training may be substituted for a degree.

Interaction Designer/User Researcher/Usability Tester, Junior 3

Interaction Designer/User Researcher/Usability Tester, Mid 5

Interaction Designer/User Researcher/Usability Tester, Senior 7

The Interaction Designer / User Researcher / Usability Tester is part of a highly collaborative, multi-disciplinary team focused on improving usability, user experience, and driving user adoption and engagement. They are responsible for conducting user research, analysis & synthesis, persona development, interaction design, and usability testing to create products that delight our customers. Primarily responsible for: Conduct stakeholder interviews, user requirements analysis, task analysis, conceptual modeling, information architecture, interaction design, and usability testing. Design and specify user interfaces and information architecture.

Lead participatory and iterative design activities, including observational studies, customer interviews, usability testing, and other forms of requirements discovery. Produce user requirements specifications & experience goals, personas, storyboards, scenarios, flowcharts, design prototypes, and design specifications. Effectively communicate research findings, conceptual ideas, detailed design, and design rationale and goals both verbally and visually. Plan and facilitate collaborative critiques and analysis & synthesis working sessions. Work closely with visual designers and development teams to ensure that customer goals are met and design specifications are delivered upon. Designs and develops primarily internet/web pages and applications. Develops proof-of-concepts and prototypes of easy-to-navigate user interfaces (UIs) that consists of web pages with graphics, icons, and color schemes that are visually appealing.

Research user needs as well as potential system enhancements. Has familiarity to, or may actually: code, test, debug documents, and implement web applications using a variety of platform. Planning, recruiting, and facilitating the usability testing of a system. Analyzing and synthesizing the results of usability testing in order to provide recommendations for change to a system. May create such artifacts as Usability Testing Plan, Testing Scripts, and Usability Testing Report.

IT Program Manager, Junior 5

IT Program Manager, Mid 7

IT Program Manager, Senior 10

Project Manager, Junior 3

Project Manager, Mid 5

Project Manager, Senior 7

Management and technical direction of projects. Project performance including cost, schedule, deliverables, and contractual compliance, and is accountable for the quality and timely delivery of all project deliverable items. Overall project/task performance. Enforcing work standards, task schedules, reviewing work discrepancies, supervising technical personnel, recommending project hires and terminations, and communicating policies, purposes, and goals of the organization to subordinate personnel. Assisting in the budgeting of required resources for successful project implementation and completion.

Manages long-term IT projects, performs design evaluations and works to complete projects within budget and scheduling restraints. Develops and implements long-term IT roadmaps and strategy, and monitors alignment of tactical activities. Provides higher-level view of activities occurring within the enterprise and the impacts on information sharing initiatives. Performs risk management, including identifying, prioritizing, and mitigating risks, and communicating and escalating risks and issues. Provide the ability to manage projects that may vary by project type (i.e., a new project, an existing project, a project being transitioned from another delivery provider, etc.), size, complexity, project life cycle phases, development methods (e.g., SCRUM, spiral, etc.). Support the development of briefings, agendas, and other general documentation support as directed, including training material and demonstration sessions for new and existing technologies to various DHS stakeholders. Support a continuous improvement process by providing recommendations on improving products, services, and processes. Develop Communication Plans for the program. Develop and manage project schedules, including integrated project schedules, and plans using the tools as defined by the Government (i.e., Microsoft Project, JIRA). Support Management of projects within schedule and budget and defined by the Government. Ensure the team delivers Agile development artifacts, which will include Project Sprint/Product/Release Backlogs, Burn-downs/ups, Team Velocity, RTM, etc.

Scrum Master, Junior 3

Scrum Master, Mid 5

Scrum Master, Senior 7

Security Engineer, Junior 3

Security Engineer, Mid 5

Security Engineer, Senior 7

Monitors each task, and keeps the Project Manager abreast of all problems and accomplishments.

Anticipates problems, and works to mitigate the anticipated problems. Provides technical direction for the complete systems development and maintenance effort. May serve as a technical authority for a design area. Resolves unique and unyielding systems problems using new technology. Can complete tasks within estimated time frames and budget constraints. Schedules and assigns duties to subordinates. Interacts with government management personnel. Reports in writing and orally to Contractor management and government representatives, including the government contracting officer. Bachelor's degree. Equivalent experience or training may be substituted for a degree.

Experience with working in a highly technical environment, be well versed in the current state of Information Security, and be able to interpret security requirements of relevant governing bodies (NIST, OMB, DHS, etc.) The SE will interface with federal employees and contractors to perform required support activities. Without direct supervision, responsibility includes but not limited to: Understanding of the DHS security engineering experience. Certifications and direct applicable experience in CEH, Amazon, Microsoft, Linux and Cloud. Direct DHS experience engineering and integrating secure solutions in cloud, data centers, networks, applications using Linux, windows, identity solutions, databases, firewalls, and networks appliances. Experience with Information Assurance Compliance tools (XACT, TAF, etc.). Knowledge of Federal Government Authorization processes (NIST 800-53, DHS 4300A, DIACAP).

Solution Architect, Junior 5

Solution Architect, Mid 7

Solution Architect, Senior 10

Subject Matter Expert, Junior 7 Subject Matter Expert, Mid 11 Subject Matter Expert, Senior 15

Technical Writer, Junior 2

Technical Writer, Mid 4

Technical Writer, Senior 6

Leads strategic planning initiatives in a select technical or functional area. Meets with management and the team members frequently to propose initiatives, help foster adoption of technologies and establish priorities.

Without direct supervision, responsibility includes but not limited to: Collecting, analyzing, composing, and translating technical information into clear, readable documents to be used by both technical and non- technical personnel. Obtaining data from technical staff by directly interacting with them and assisting in the creation of the technical documentation when needed.

Creating processes and procedures, user manuals, training materials, installation guides, and reports. Editing requirements functional descriptions, system specifications, user manuals, special reports, or any other customer deliverables and documents.

Responsible for driving multiple customer solution design projects in parallel. Conduct business and technical discovery with customers. Problem solve novel solutions, architectures and use cases to help customers meet their objectives. Provide robust recommendations for engagements while also identifying critical dependencies & gaps. Present proposals to senior government officials in a clear and compelling way. Continuously improve the team’s knowledge, methodologies and inventory of solution design blueprints for key customer segments and classes of use cases. Experience working in a top-tier technical consulting or software development.

Strong drive to solve customer problems and drive projects end to end from ideation to deployment. Balance of business and technology acumen, including ability to articulate high-level technical solutions to business problems and to tie your solutions to program success criteria. Capable of independently applying a wide set of engineering disciplines for planning, design, analysis, coding, testing, roll-out and support of information systems architectures. Responsible for, or assists in, the designing of interface standards, quality assurance standards, performance standards, and cost-benefit analysis of modem state-of-the art information systems. Analyzes available technologies and makes recommendations of technologies to use and how best to use them. Outstanding problem solving and analytical skills, including ability to create clear observations, analysis and conclusions based on customer interviews and data.

Outstanding communications skills both oral and written (e.g., PowerPoint). Team player who can collaborate with multiple stakeholders to arrive at the best solution. High degree of intellectual curiosity and ability to learn and apply new concepts and technologies in a wide variety of marketing disciplines

Tester, Junior 3

Tester, Mid 5

Tester, Senior 7

Web User Interface Developer, Junior 3

Web User Interface Developer, Mid 5

Web User Interface Developer, Senior 7

Consults with stakeholders to understand their goals and explaining research results. Analyzes user feedback and activity, and iterating to enhance the user experience. Creates wireframes, storyboards, personas and usage scenarios, content, sitemaps and screen flows. Develops product prototypes and conducts usability testing. . Uses qualitative and quantitative analysis techniques to inform design decisions and ensure that solutions have the intended impact. Bachelor's degree.

Equivalent experience or training may be substituted for a degree.

Work with business and technical teams to understand the system to be tested. Participate in application planning meetings. Develop and document application test plans based on software requirements and technical specifications. Develop test cases and prioritize testing activities.

Execute all test cases and report defects, define severity and priority for each defect Record and document results and compare to expected results. Detect software failures so that defects may be discovered and corrected. Generate historical analysis of test results. Document anomalies and issues. Maintain database or list of software defects. Examine code and execution of code in various environments. Verify specific action or function of code. Operate and maintain test networks. Create meaningful error handling procedures for application code. Carry out regression testing every time changes are made to the code to fix defects. Ensure data integrity standards. Perform reviews, walkthroughs, or inspections.

LCAT Descriptions