Software Developer, Intermediate (Reporting)

Overview

Aveshka is currently seeking a Software Developer to serve as part of a team in support of a key Customs and Border Protection (CBP) system. “Cornerstone” is a CBP owned and managed data system, which facilitates the flow of information to and from a variety of customers and data sources associated with the background investigation and adjudication process. We need your information technology expertise and consulting background to support operations and maintenance of the Cornerstone system to develop and implement a broad range of reporting initiatives. Such services shall entail the development of reporting solutions and recommendations and the assistance in implementing the solutions and recommendations to meet the information needs of the client and its customers.

Responsibilities

• Develop software code to create, enhance, resolve, and/or maximize IT solutions to support reporting processes
• Assist with and/or support the deployment of system updates/enhancements/upgrades
• Troubleshoot and resolve issues related to the applications and systems
• Automate manual processes
• Implement data retention schedule for the applications
• Develop queries/reports
• Recommend alternative database structure to improve/enhance performance and to ensure the long-term sustainability of the project
• Troubleshoot/optimize the performance of associated databases and connections
• Migrate existing applications to (newer) identified environments
• Document historical, current, and future enhancement efforts
• Gather user requirements and develop automated specifications/requirements
• Build/enhance data dictionaries to include defining metadata management approaches and data governance processes
• Identify, design, and implement solutions for extraction and integration of data from legacy systems for reporting, decision support, and analysis

Qualifications

Required Experience:

• U.S. Citizenship
• Three to Five years of software development experience working with multiple programming languages, frameworks and platforms, Agile software development methodologies, planning and implementing system rollout
• Demonstrated experience working with Cognos Reporting
• Demonstrated experience working with SharePoint
• Demonstrated experience working with MS Access Database
• Demonstrated experience working with Visual Basic .NET
• Demonstrated experience working with MS Access VBA
• Experience using Jira and Confluence 

Required Clearance:

• Minimum of a CBP BI or Top Secret

Desired Qualifications:

• Active CBP BI
• Experience with CBP
• Bachelor's degree in engineering, computer science, information technology (IT), or a related discipline
• Analytical, design and problem-solving skills at multi-product/multi-environment level to troubleshoot system defects and mitigate the issues they cause.
• Skills in research and analysis, project planning and implementation. Understanding and awareness of business issues as they impact overall project plans.
• Excellent verbal and written communications skills, with an ability to express and document complex technical concepts in business terms. Person must be able to communicate effectively verbally and in writing with technical staff, non-technical staff, end-users for requirements gathering, testing, training, and outcome validation. Good English-language skills, both verbal and written.
• Excellent team-oriented interpersonal and communication skills and ability to work effectively in a cross-functional project team environment.
• Understanding of concepts of project planning and project management techniques to assist in small projects and/or group initiatives.
• Experience with Java Server Pages, jQuery, and JavaScript a plus
• Experience with Spring Boot a plus
• Experience with IBM MQ, Java Web Services, and SFTP a plus
• Experience with MySQL 8.0, Oracle 12g a plus
• Experience with Java 1.8, Apache Tomcat 9.0, Jasper Reports, Jenkins, Bitbucket, Wrappers, Eclipse, MySQL Workbench, Oracle SQL Developer, and Windows Server a plus 

About Aveshka:

Aveshka is a professional services firm focused on addressing our nation’s most complex threats and challenges. As a small business we’re committed to supporting our clients’ missions with services delivered by our diverse and experienced staff. With expertise in cybersecurity, emergency preparedness, and public health, our experience base spans federal, state, and local governments, as well as private sector entities.

Aveshka encourages collaborative communication and ongoing learning.  Some of our benefits include:

• Extensive training programs
• Gym membership reimbursement
• Education reimbursement
• Technology benefits
• Commuter benefits
• Generous paid time off and much more!

Aveshka is an Equal Opportunity Employer (EOE)