Senior Software Engineer

AMERICAN SYSTEMS is an employee-owned federal government contractor supporting national priority programs through our strategic solutions in the areas of Information Technology, Test & Evaluation, Program Mission Support, Engineering & Analysis, and Training.

As a Software Development Engineer with AMERICAN SYSTEMS, you will have the opportunity to do the following:

Database Architecture and Development: Design, develop, and implement 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.
• Databricks Development and Integration: Leverage 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.
• Database Administration and Management: Implement, deploy, and maintain databases on various platforms, including MS Access, ensuring performance, security, availability, and data integrity. This includes tasks such as backup, recovery, migration, and upgrade.
• MS Access Development and Maintenance: Develop and maintain MS Access databases and applications, including VBA scripting and automation, to support specific business needs and integrate with other systems.
• Data Management and Governance: Implement and adhere to company data management practices and policies, ensuring data quality, security, and compliance across all database platforms.
• Secure Development Practices: Develop and maintain secure database solutions, adhering to best practices and security protocols to protect sensitive research and engineering (R&E) data.
• Collaboration and Cross-Functional Teamwork: 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.
• Code Development: 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.

• Must have a current and active Secret clearance required, must be Top Secret/SCI eligible.

• U.S. Citizenship Required for the purposes of obtaining/holding a U.S. security clearance.
• Bachelor's Degree or higher Degree required in a STEM field.
• Five years of experience in database architecture, design, and implementation is desired, 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. Experience with other languages like Java, Scala, PL/SQL, C++, C#, and HTML is a plus.
• 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.
• Experience with data governance, data quality, and data security best practices.
• Strong oral and written communication skills.
• Strong team orientation and ability to collaborate effectively in a multi-disciplinary environment.
• Ability to be on-site for classified work and meetings.
• Proactive, organized, and detail-oriented.