About Sandia: Sandia National Laboratories is the nation's premier science and engineering lab for national security and technology innovation. We are a world-class team of scientists, engineers, technologists, post docs, and visiting researchers all focused on cutting-edge technology, ranging from homeland defense, global security, biotechnology, and environmental preservation to energy and combustion research, computer security, and nuclear defense. To learn more, visit http://www.sandia.gov. Department Description: The Science and Engineering Information Systems (SEIS) Organization is a highly integrated team of departments focused on delivering software and system solutions which impact Sandia's mission-critical programs. Our vision is to be Sandia's information sciences and engineering partner of choice for advancing informatics, cyber security, technology assessments and computer systems, and delivering information engineering products and services. Our key goals are: cost-effective and reliable solutions, customer agility and performance, broad impact across Sandia, and an agile organization. The Organization's work has been primarily focused within the Nuclear Weapons Mission Area and Nuclear Security Environment (NSE), with the National Security Technology and Systems SMU as a major avenue of new growth. Core competencies of the Organization include technology assessment of application and infrastructure security, software engineering, project management, software quality assurance, requirements engineering, enterprise architecture and data architecture. Emerging competencies include advanced informatics, embedded software development, predictive simulation capabilities, scientific, parallel and high-performance computing. To have broad impact across Sandia missions, we are purposely extending our core competencies and differentiation capabilities through partnerships with other organizations and through Laboratory Directed Research and Development (LDRD). The SEIS Organization employs a rigorous product development and deployment process and staff members are the key impetus for process improvements through adoption of new techniques and industry best practices. How to Apply: Click on the "Apply" button at the top or bottom of this screen, follow the instructions to upload a resume, and complete the submission process to indicate your interest in this position. Job Description: Software Systems Engi MM Job Summary: We have a need for a data warehouse designer/developer who will work with a tight-knit team. Candidate will develop Extract, Transform, Load (ETL) processes for data integration, create conceptual and physical data models using relational, dimensional, and other modeling techniques, write software to enable jobs to run in a complex computing environment, and participate in operations and support duties. Other responsibilities may include: -- Facilitate the design, build and operation of the data management function and strategy for the enterprise including data governance (including policy and operating protocols), Quality Management Framework standards and monitoring, master data management/definition and data management program development and monitoring. -- Develop stored procedures to support the needs of other application development teams. -- Work with data stewards, data attribute owners, and IT system owners to ensure data is entered, updated, stored, combined, shared and reported in an accurate manner. Investigates, designs, develops, tests, documents, and analyzes software systems and applications. Develops new programs and subprograms, as well as enhancements, modifications, and corrections to existing software. Prepares concepts and prototypes for information system software solutions or for specialized software domains and evaluates the cost-effectiveness of these concepts. Implements software solutions that may be commercial-off-the-shelf or internally developed. Evaluates interfaces between hardware and software, operational requirements, and characteristics of overall system. Applies software engineering principles, tools, and advanced techniques to develop and support applications, including software development methodologies, database design methodologies, programming languages, source code control for release management, and disaster recovery methodologies. Involved in planning of system and development deployment as well as responsible for meeting software compliance and quality standards. Primary Job Duties: Develops new programs and subprograms, as well as enhancements, modifications, and corrections to existing software. Develops requirements, workflow and systems analysis. Establishes standards for development and maintenance of new and existing products. Applies strategic thinking to deliver user-experience solutions with a focus on user needs and business goals. Uses judgment to suggest solutions that balance customer needs, business constraints, and technological realities. Creates and guides the design of user experiences and interface designs for software features and products. Participates in defining interfaces between software systems. Applies standard software engineering practices in the development of the software solutions. Participates in defining and may participate in performing software build, release, and installation procedures. Documents work and results. Develops test plans and performs testing. Collaborates effectively with designers, researchers, engineers, product managers, marketers, and other team members. May be responsible for developing or executing software development project plans, budgets, and schedules. Researches and evaluates new software technologies. Stays current with new technologies and industry trends and best practices. Knowledge, Skills, Abilities: Advanced knowledge of techniques and tools that support applications such as software development methodologies, user-centric design, database design methodologies, programming languages, source code control for release management, and disaster recovery methodologies. Knowledge of software engineering practices and software development methodologies. Ability to work with multiple hardware and operating systems, system architectures, and network infrastructures. Overall knowledge of software development concepts, but may specialize in a specific software development discipline such as software testing, user interface design, or web development. Knowledge and experience in testing methodologies, including the ability to troubleshoot and identify solutions for issues. Knowledge or experience with applying user-centered design processes. Ability to work collaboratively in a cross-functional team environment and interact with diverse customers understanding the business domain. Ability to develop innovative long-term solutions that are easy to use, integrate with other applications, and are straightforward to maintain. Demonstrated ability to organize, prioritize, and follow through to completion on multiple tasks, often under strict deadlines. Strong interpersonal and communication skills. Effective communicator, presenter, and negotiator. Required: -- Bachelor's degree in Computer Science or similar field with two or more years of relevant experience; or an Advanced degree in Computer Science or similar field. -- Database and/or Data Warehouse design experience. -- Database modeling skills. -- Ability to obtain and maintain a required DOE security clearance. Desired: -- Experience following a systematic software development process -- Experience with Oracle PL/SQL programming and Package Structure -- Experience with T-SQL. -- Programming experience with unix/linux/windows shell scripts and batch files. -- SSH Protocol Fundamentals -- HTTP, HTML, and XML Fundamentals -- An understanding of Enterprise Architecture -- Programming experience in languages such as C++, Java, Jython, `C', Python or Perl. -- Experience working on or with a data governance, data quality program, customer data management program or large-scale data remediation program that focused on quality output of master data. -- Large scale data issues. -- Active Department of Energy Q security clearance or ability to obtain one. -- Experience using the DataStage ETL tool. -- Experience with Oracle Data Integrator and Oracle Warehouse Builder. -- Experience using SQL Server Reporting Services and SQL Server Analysis Services. -- Experience with Control-M job scheduling system. -- SQL IDE (Preferably RapidSQL and/or DB Artisan) -- Configuration Management Software (preferably TeamForge/SVN) -- Java IDE (preferably Eclipse and/or Eclipse based) Security Clearance: Position requires a Department of Energy (DOE)-granted Q-level security clearance. Sandia is required by DOE directive to conduct a pre-employment background review that includes personal reference checks, law enforcement record and credit checks, and employment and education verifications. Applicants for employment must be able to obtain and maintain a DOE Q-level security clearance, which requires U.S. citizenship. Applicants offered employment with Sandia are subject to a federal background investigation to meet the requirements for access to classified information or matter if the duties of the position require a DOE security clearance. Substance abuse or illegal drug use, falsification of information, criminal activity, serious misconduct or other indicators of untrustworthiness can cause a clearance to be denied or terminated by the DOE, rendering the inability to perform the duties assigned and resulting in termination of employment. Benefits: At Sandia you will receive many benefits as a valued employee of a premier national multi-program engineering and science research laboratory. In our Total Rewards package you will enjoy competitive pay, great benefits, a stimulating, positive environment and learning opportunities that will help build your career. More information may be found on our Careers website. EEO Statement: Sandia National Laboratories is an Equal Opportunity Employer of qualified women, minorities, individuals with disabilities and protected veterans.
*CITY:* Albuquerque
*STATE:* NM
*FULL PART TIME:* F
*COUNTRY:* USA
*HRS SOURCE ID:* 1030
*FLSA STATUS:*
*REG TEMP:* R
*JOB FAMILY:* IT