Software / Database Developer

Overview Systems Planning and Analysis, Inc. (SPA) delivers high-impact, technical solutions to complex national security issues. With over 50 years of business expertise and consistent growth, we are known for continuous innovation for our government customers, in both the US and abroad. Our exceptionally talented team is highly collaborative in spirit and practice, producing Results that Matter. Come work with the best! We offer opportunity, unique challenges, and clear-sighted commitment to the mission. SPA : Objective. Responsive. Trusted. The Joint, Office of the Secretary of Defense, Interagency Division provides expert support services to a range of customers spanning across the Department of Defense, Federal Civilian, and international markets. JOID provides a diverse portfolio of analytical and programmatic capabilities to help our customers make informed decisions on their most challenging issues. The Industry and Security Analysis Group (ISAG) within JOID provides analytical, technical, and program support to promote, grow, and protect the U.S. industrial base. ISAG's support spans the Department of Defense (DOD), Department of Commerce, and other agencies to deliver critical decision support to national security leaders. Our team informs policy decisions, enables execution of comprehensive strategies and monitors and reports on the effectiveness of implementation. This enables senior leaders to execute strategies for developing and sustaining a robust industrial base that meets our nation's strategic resource objectives. From policy to practice, we are a team of economic and national security professionals providing innovative solutions for our Nation's most pressing security challenges. This role supports the Office of the Under Secretary of Defense for Research and Engineering's (OUSD(R&E's)) Maintaining Technology Advantage (MTA) Directorate that leads Department of Defense (DoD) protection of critical and emerging technologies and maintaining the U.S. DoD's technological superiority over strategic competitors. SPA has an immediate need for a Software / Database Developer to provide onsite support at the Mark Center in Alexandria, VA with some telework as authorized by the Task Lead. The position may occasionally require work at alternative sites across the National Capital Region. Responsibilities The candidate will serve as a Software / Database Developer for MTA, which falls under the purview of OUSD(R&E's) Science and Technology Program Protection Office and will be responsible for designing, developing, and implementing robust database architectures, incorporating advanced analytics and data processing to meet organizational requirements for data storage, retrieval, and analysis. This includes schema design, performance optimization, and ensuring scalability across various platforms, including MS Access. Leveraging Databricks to build and deploy data pipelines, perform complex data transformations, and develop data-driven applications. This includes working with Databricks notebooks, clusters, and related infrastructure. Implement, deploy, and maintain databases on various platforms, including MS Access, ensuring performance, security, availability, and data integrity. Complete tasks such as backup, recovery, migration, and upgrades. Develop and maintain MS Access databases and applications, including VBA scripting and automation, to support specific business needs and integrate with other systems. Implement and adhere to company data management practices and policies, ensuring data quality, security, and compliance across all database platforms. Develop and maintain secure database solutions, adhering to best practices and security protocols to protect sensitive R&E data. Collaborate with multiple interagency teams to contribute to protecting the nation's R&E technology ecosystem. This includes cross walking adversary technology status with our nation's current research cadence and progress. Write code to interact with databases, develop database applications, integrate with Databricks, and potentially develop scripts and automation for MS Access using VBA and other relevant languages. Qualifications Required : Bachelor's degree or higher in a STEM field. Active TS / SCI clearance. 10+ years of experience in database architecture, design, and implementation, including two years utilizing Databricks and demonstrated proficiency in MS Access development and maintenance, specifically VBA scripting. Proficiency in programming languages such as R, Python, and SQL; experience with VBA for MS Access automation is essential. Strong understanding of database design principles, including data modeling, schema design, and database normalization. Experience with database management systems (e.g., PostgreSQL, MySQL, SQL Server, MS Access). Experience with cloud-based databases and data warehousing solutions, including Amazon RDS, Google Cloud SQL, Microsoft Azure Database Services, and ideally cloud-based data lakes. Hands-on experience with Databricks, including cluster management, notebook development, and data pipeline creation. Understanding of DoD database and cloud infrastructure, guidance, and policy. Experience with data governance, data quality, and data security best practices. Exceptional oral and written communication skills; strong team orientation and ability to collaborate effectively in a multi-disciplinary environment. Ability to be onsite for classified work and meetings; proactive, organized, and detail-oriented. Proficiency in SharePoint Framework (SPFx) : SPFx allows for the creation of responsive, web-based solutions within SharePoint. Experience with SharePoint REST API : This enables direct interaction with SharePoint data using HTTP requests. Knowledge of Power Platform : Power Automate and Power Apps are essential for automation and low-code development within SharePoint. Familiarity with SharePoint administration : Important for security, user management, and site settings. Technical skills : Proficiency in languages like C#, JavaScript, and SQL Server, along with knowledge of web development technologies. Desired : Experience with other languages like Java, Scala, PL / SQL, C++, and HTML.

Qualifications

Required : Bachelor's degree or higher in a STEM field. Active TS / SCI clearance. 10+ years of experience in database architecture, design, and implementation, including two years utilizing Databricks and demonstrated proficiency in MS Access development and maintenance, specifically VBA scripting. Proficiency in programming languages such as R, Python, and SQL; experience with VBA for MS Access automation is essential. Strong understanding of database design principles, including data modeling, schema design, and database normalization. Experience with database management systems (e.g., PostgreSQL, MySQL, SQL Server, MS Access). Experience with cloud-based databases and data warehousing solutions, including Amazon RDS, Google Cloud SQL, Microsoft Azure Database Services, and ideally cloud-based data lakes. Hands-on experience with Databricks, including cluster management, notebook development, and data pipeline creation. Understanding of DoD database and cloud infrastructure, guidance, and policy. Experience with data governance, data quality, and data security best practices. Exceptional oral and written communication skills; strong team orientation and ability to collaborate effectively in a multi-disciplinary environment. Ability to be onsite for classified work and meetings; proactive, organized, and detail-oriented. Proficiency in SharePoint Framework (SPFx) : SPFx allows for the creation of responsive, web-based solutions within SharePoint. Experience with SharePoint REST API : This enables direct interaction with SharePoint data using HTTP requests. Knowledge of Power Platform : Power Automate and Power Apps are essential for automation and low-code development within SharePoint. Familiarity with SharePoint administration : Important for security, user management, and site settings. Technical skills : Proficiency in languages like C#, JavaScript, and SQL Server, along with knowledge of web development technologies. Desired : Experience with other languages like Java, Scala, PL / SQL, C++, and HTML.

Responsibilities

The candidate will serve as a Software / Database Developer for MTA, which falls under the purview of OUSD(R&E's) Science and Technology Program Protection Office and will be responsible for designing, developing, and implementing robust database architectures, incorporating advanced analytics and data processing to meet organizational requirements for data storage, retrieval, and analysis. This includes schema design, performance optimization, and ensuring scalability across various platforms, including MS Access. Leveraging Databricks to build and deploy data pipelines, perform complex data transformations, and develop data-driven applications. This includes working with Databricks notebooks, clusters, and related infrastructure. Implement, deploy, and maintain databases on various platforms, including MS Access, ensuring performance, security, availability, and data integrity. Complete tasks such as backup, recovery, migration, and upgrades. Develop and maintain MS Access databases and applications, including VBA scripting and automation, to support specific business needs and integrate with other systems. Implement and adhere to company data management practices and policies, ensuring data quality, security, and compliance across all database platforms. Develop and maintain secure database solutions, adhering to best practices and security protocols to protect sensitive R&E data. Collaborate with multiple interagency teams to contribute to protecting the nation's R&E technology ecosystem. This includes cross walking adversary technology status with our nation's current research cadence and progress. Write code to interact with databases, develop database applications, integrate with Databricks, and potentially develop scripts and automation for MS Access using VBA and other relevant languages.