Data Analyst (Applications Analyst II)

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.

The Data Integration Group is looking for a Data Analyst (Applications Analyst) that will support the Work Management Centers (WMC) generation of metrics, dashboards and reports that will enable data-driven decisions and efficient work-flow management. Key responsibilities will include leading data improvement initiatives, design, and operation of metric suites in Power BI, and database integration. This role requires expertise in data mining, modeling, validation, analysis, and visualization to serve as the data liaison for the WMC.

Key Responsibilities

• Document entity relationship diagrams and design data models within PowerBI. 
• Write SQL queries to perform data mining and validation utilizing PL/SQL and MySQL. 
• Prepare user operating instructions for PowerBI Dashboards and scheduling update and monitoring tools. 
• Prepare time and cost estimates and schedules for Dashboard and metric suite development and maintenance or modification tasks. 
• Coordinate with IT personnel to identify data requirements. 
• Participate in software development and support personnel defining software requirements for development, maintenance or improvements. 
• Coordinate or develop and implement plans for data validation tests between multiple databases and PowerBI Dashboards. 
• Provide instruction on PowerBI dashboard end user operation, data lineage, and data mining practices. 
• Resolve PowerBI Dashboard issues that arise from operations and end user feedback. 
• May provide support to the User Support Training organization. 
• May design, code, test, debug, document and maintain programs / dashboards. 
• 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: 
• Coordinate requests for access to data
• Develop and implement data administration standards regarding validation, integrity, storage, and security of data; internal object naming conventions, and data access methods.
• Develop strategic and functional plans for the evolution of data and information architecture
• Resolve issues associated with data administration.
• Serve as a single point of contact for Work Management Center data, primarily focused on Maximo and Primavera P6 databases.

• 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 or database administration.
• Ability to lead projects.
• Ability to manage increasing number of tasks. 
• Ability to support multiple software applications or database platforms.
• Experience in tools and technology used by NNSS. 
• 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. Experience with IBM Maximo databases and Primavera P6 is preferred. 
• 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. <