Senior Data Engineer (Sr Applications Analyst)

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

Benefits offered by this job

Medical, dental, vision benefits

401(k) and pension

Job summary

Mission Support and Test Services, LLC seeks a Senior Applications Analyst to drive data analytics, data warehousing, and information architecture at the NNSS site in North Las Vegas. You will lead data requirements, design, integration, and reporting projects with cross-functional teams.

You will mentor staff, develop SQL and Denodo-based solutions, and advance centralized data repositories to support DOE/NNSA missions. A strong technical background and site readiness are essential.

Qualifications

• Bachelor’s degree in a computer-related field or equivalent experience with at least 5 years of relevant, progressively responsible experience.
• Advanced knowledge of data analytics and/or data warehousing principles, standards, and practices.
• Ability to coach or mentor less senior staff.
• Ability to multitask and manage complex projects with cross-functional teams.
• Strong problem solving and debugging skills with experience in data architecture.

Responsibilities

• Participates in defining data requirements and takes ownership of data design and implementation.
• Prepares time and cost estimates and schedules for data development tasks.
• Reviews data and test results to ensure modifications are tested and align with user specifications.
• Develops data integration diagrams, logic charts, and internal documentation.
• Mentors users of analytics tools such as SQL, Denodo, Power BI, and cloud data platforms.
• Collaborates with cross-functional teams to design and implement data-driven solutions.
• Directs data integration strategies and reviews changes to central data repositories and DBMS structures.

Skills

SQL

Oracle DBs

Data analytics

Mentoring

Multitasking

Project leadership

Data design

Education

Bachelor’s degree in computer-related field

Tools

Denodo

Power BI

Job description

Job Description

The Data Analytics team within the Information Technology directorate is seeking a Senior Applications Analyst.

Responsibilities

Key Responsibilities

• Participates in defining data requirements for development, maintenance, and improvements by responding to questions concerning data design and implementation. Takes ownership of technical problems and see them through to resolution.
• Prepares time and cost estimates and schedules for data development, maintenance, and modification tasks.
• Reviews and analyzes data and existing test methods to determine the feasibility of design change requests, recommendations and refinements.
• Reviews and analyzes data and test results to ensure modifications have been made and tested, including ensuring MSTS computer users’ specifications have been satisfied.
• Analyzes user requirements, devises solutions, and prepares external specification documentation.
• Designs and documents data integration by preparing diagrams, logic charts and internal specification documentation.
• May provide technical assistance to the User Support Training organization.
• 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.
• Providing advice and consultation regarding data requirements and/or report design.
• Developing or modifying SQL code.
• Serve as a mentor in data analytics tools and technologies, including but not limited to SQL, Denodo, Power BI, and cloud-based data platforms.
• Developing and reviewing strategic and functional plans for the evolution of data and information architecture, including establishment of a centralized information repository.
• Creating data visualizations and reports.
• Directing data integration strategies.
• Collaborating with cross-functional teams to design and implement data-driven solutions.
• Reviewing and approving changes to the central repository and the DBMS structure.
• Providing assistance with data architecture methods.
• May formulate or define programming scope and objectives.
• May devise or modify procedures to solve complex problems.
• May review specifications and write programs, including coding, testing, debugging and documentation.
• May instruct, direct and review the work of other personnel.
• May prepare detailed plans to perform systems design.
• Perform other duties as assigned.

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 computer related experience with at least 5 years of relevant, progressively responsible experience.
• Demonstrate advanced knowledge of technical principles, theories, standards, practices and procedures in data analytics and/or data warehousing.
• Ability to coach or mentor less senior staff.
• Ability to multitask.
• Ability to lead complex projects that may involve other IT sections, other departments, and consultants.
• Ability to support multiple increasingly complex software applications or database platforms.
• Must have experience in broad range of tools and technology used by NNSS.
• Ability to solve complex design problems.
• Strong analytical skills.
• Demonstrate good problem solving skills.
• Demonstrate good technical trouble shooting skills.
• Demonstrate good testing and debugging skills.
• Demonstrate strong skillset in 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).
• 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.

Annual salary range for this position is: $97,219.20 - $145,828.80.

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

About Us

Mission Support and Test Services, LLC (MSTS) manages and operates the Nevada National Security Sites (NNSS) for the U.S. National Nuclear Security Administration (NNSA), a semi-autonomous agency within the U.S. Department of Energy (DOE). The NNSS is an enterprise of special-purpose, multi-mission, high-hazard experimentation facilities delivering technical and service solutions in partnership with the National Laboratories. Our 3,000+ 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 Aerospace, Amentum, and HII Nuclear Inc.