Applications Analyst II

• Designs and documents data solutions by preparing diagrams, logic charts and internal specification documentation.
• Writes SQL code from internal specification documentation, prepares test plans and tests data. Runs tests, observes results and corrects program code to resolve any differences with internal specifications.
• Prepares software operating documentation and users operating instructions.
• Prepares time and cost estimates and schedules for computer systems software development and maintenance or modification tasks.
• Analyzes MSTS computer user requirements.
• Participates with software development and support personnel defining software requirements for development, maintenance or improvements.
• Administers data platforms, including code deployments, upgrades, and access.
• Provides instruction in the operation and use of computer hardware, data communications equipment, and vendor-supplied or MSTS-developed systems software.
• Resolves systems software problems referred by computer operations or software development and user support personnel.
• May provide support to the User Support Training organization.
• May design, code, test, debug, document and maintain programs.
• May use CASE tools.
• May provide guidance, training, and assistance to other IT personnel.
• May prepare specifications from which programs will be written.
• May plan and coordinate data-related activities, including:
• Coordinating requests for access to data
• Developing and implementing data administration standards regarding validation, integrity, storage, and security of data; internal object naming conventions, and data access methods
• Consulting on DBMS issues including installation and management of front-end tools
• Developing strategic and functional plans for the evolution of data and information architecture
• Resolving issues associated with data administration
• Acting as the single point of contact with the DBMS vendor
• Establishing DBMS backup, recover, and restart procedures
• Collaborating with cross-functional teams to design and implement data-driven solutions
• Creating data visualizations and reports

Due to the nature of our work, US Citizenship is required for all positions.

• Bachelor’s degree in a computer related field or equivalent training and experience with at least 2 years of relevant experience.
• Basic knowledge of technical principles, theories, standards, practices and procedures in software development, database administration, or data analytics.
• Ability to lead projects that may involve other IT sections, other departments, and consultants.
• Ability to manage increasing number of tasks.
• Ability to support multiple software applications or database platforms.
• Must have experience in tools and technology used by NNSS (i.e. Microsoft BI Stack (including Power BI), Azure DevOps, Denodo.
• Demonstrate good analytical skills.
• Ability to solve design problems.
• Demonstrate problem solving skills.
• Demonstrate technical trouble shooting skills.
• Demonstrate testing and debugging skills.
• Demonstrate knowledge of SQL Server and Oracle relational databases.
• Demonstrate excellent verbal and written communication and presentation skills.
• The primary work location will be at the Losee Road Facility in North Las Vegas, Nevada.
• Work schedule will be 4/10s Monday through Thursday (subject to change).
• Personnel may be requested by leadership to work in excess of 40 hours per week due to projects, activities, and emergences; critical operational demands may occasionally require off-shift work.
• Pre-placement physical examination, which includes a drug screen, is required. MSTS maintains a substance abuse policy that includes random drug testing.
• Must possess a valid driver’s license.

Ability to obtain a HSPD-12 Personal Identity Verification credential under the Department of Energy Order 206.2, ‘Identity, Credential, and Access Management,’ and Supplemental Directive NNSA SD 206.2, ‘Implementation of Personal Identity Verification for Uncleared Contractors.’

Mission Support and Test Services, LLC (MSTS) manages and operates the Nevada National Security Site (NNSS) for the U.S. National Nuclear Security Administration (NNSA). Our MISSION is to help ensure the security of the United States and its allies by providing high-hazard experimentation and incident response capabilities through operations, engineering, education, field, and integration services and by acting as environmental stewards to the Site’s Cold War legacy. Our VISION is to be the user site of choice for large-scale, high-hazard, national security experimentation, with premier facilities and capabilities below ground, on the ground, and in the air. (See NNSS.gov for our unique capabilities.) Our 2,750+ professional, craft, and support employees are called upon to innovate, collaborate, and deliver on some of the more difficult nuclear security challenges facing the world today.

• MSTS offers our full-time employees highly competitive salaries and benefits packages including medical, dental, and vision; both a pension and a 401k; paid time off and 96 hours of paid holidays; relocation (if located more than 75 miles from work location); tuition assistance and reimbursement; and more.
• MSTS is a limited liability company consisting of Honeywell International Inc. (Honeywell), Jacobs Engineering Group Inc. (Jacobs), and HII Nuclear Inc., Starting salary is determined based on the position market value, the individual candidate education and experience and internal equity.