Applications Analyst II

Mission Support and Test Services, LLC; North Las Vegas (NV); On-site; USD 77,000 - 115,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Pension

401k

Paid time off

Paid holidays (96 hours)

Relocation assistance

Tuition assistance

Job summary

Mission Support and Test Services, LLC (MSTS) manages NNSS for the NNSA and seeks a data/software professional to design and document data solutions, write SQL code, and support data platforms from the Losee Road Facility in North Las Vegas, NV.

Candidates should have a Bachelor's in a computer-related field with 2+ years of experience, strong SQL/DBMS skills (SQL Server/Oracle), and familiarity with Power BI, Azure DevOps, and Denodo. The role requires US citizenship and a 4/10 work schedule.

Qualifications

• Bachelor's degree in a computer-related field with at least 2 years of relevant experience.
• Solid knowledge of software development, database administration, or data analytics principles.
• Ability to lead projects and manage multiple tasks across teams.
• Experience with NNSS tools and data platforms preferred.
• Strong SQL and database concepts; proficient communication skills.

Responsibilities

• Designs and documents data solutions with diagrams and specs.
• Writes SQL, prepares tests and validation against specs.
• Maintains data platforms, including deployments and access controls.
• Develops time/cost estimates for software tasks and projects.
• Collaborates with teams to define software requirements.

Skills

SQL

Data modeling

Software development

Analytical skills

Problem solving

Communication

Education

Bachelor's degree in computer science or related field

Tools

Power BI

Azure DevOps

Denodo

SQL Server

Oracle

Job description

Job Description

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.

Responsibilities

Key Responsibilities

• 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

Qualifications

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.’

MSTS is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability, veteran status or other characteristics protected by law. MSTS is a background screening, drug-free workplace.

Hourly range for this position is: $36.90 - $55.35.

Starting salary is determined based on the position market value, the individual candidate education and experience and internal equity.