Senior Data Analyst (Sr Applications Analyst)

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 Senior Data Analyst who will support the Enterprise Infrastructure Programs (EIP) generation of an Integrated Master Schedule, KPI 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. This role requires expertise in data mining, modeling, validation, analysis, and visualization to serve as the data liaison for EIP.

Key Responsibilities

• Serve as a single point of contact for EIP data.
• Take ownership of technical problems and see them through to resolution. 
• Develop an Integrated Master Schedule by integrating scheduling data from multiple different databases. 
• Consult and help develop data integration strategies. 
• Spearhead Business Intelligence initiatives and automate workflows. 
• Prepare time and cost estimates and schedules for software and dashboard development, maintenance, and modification tasks. 
• Review and analyze software and dashboards to determine the feasibility of design change requests, recommendations and refinements. 
• Write SQL queries to perform data mining, testing and validation utilizing PL/SQL and MySQL or equivalent.
• Analyze existing test methods to determine the feasibility of design change requests, recommendations and refinements. 
• Coordinate or develop and implement plans for data validation tests between multiple databases and PowerBI Dashboards.
• Analyze user requirements, devises solutions, and prepares external specification documentation. 
• Design and document systems software by preparing diagrams, logic charts and internal specification documentation. 
• Write program code from internal specifications documentation, prepare test plans and tests data. 
• Run tests, observe results and correct program code to resolve any differences with internal specifications. 
• Participate in the development of written reports, oral presentations of studies, and demonstrations concerning PowerBI Dashboards and database systems specifications and design. 
• Identify potential problems or requirements for expanded capabilities.
• Develop and propose solutions to problems. 
• May devise or modify procedures to solve complex problems. 
• May review specifications and write programs, including coding, testing, debugging and documentation. 
• May use CASE tools. 
• May provide technical assistance to the User Support Training organization. 
• May participate in the design, development and implementation of custom PowerBI visuals. 
• May instruct, direct and review the work of other personnel. 
• May prepare detailed plans to perform systems design. 
• May plan and coordinate data-related activities, including: 
  • Coordinating requests for access to data.
  • Developing, implementing, and reviewing 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 and reviewing strategic and functional plans for the evolution of data and information architecture, including establishment of a centralized information repository.
  • Resolving issues associated with data administration.

• Bachelo