Computer Programmer Analyst (Remote eligible)

Requisition Id 14996

Annual Salary Range:$$115,000.00 -$$135,000.00

Work-Site Type: Remote

ORNL offers a flexible work environment that supports both the organization and the employee. In addition, this position is considered remote-eligible for ORNL in pre-approved locations. Remote-eligibility is not a continued guarantee and could be subject to change based on evolving organizational needs.

Note about pay range:

Please note that the pay range information is a general guideline only. Many factors are taken into consideration when setting starting pay. Salary for this position will be commensurate with the final candidate’s qualifications and experience, including skills, knowledge, relevant education, certifications, plus also aligned with the internal peer group. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Link to benefits. https://jobs.ornl.gov/content/Benefits/?locale=en_US

­­Overview:

We are seeking a Computer Programmer/Analyst who will focus on supporting Enterprise IT managed, custom-configured, off-the-shelf (COTS) applications, with a focus on data automation, reporting, and analytics. This position resides in the Software Engineering group in the Application Development, Information Technology Services Directorate, at Oak Ridge National Laboratory (ORNL).

You will take the lead in administering, maintaining, and supporting software that manages intellectual property information. Additionally, you will provide support for other commercial off-the-shelf (COTS) applications as required.

Major Duties/Responsibilities:

• Serve as the primary administrator for ORNL’s Intellectual Property Management system, ensuring system stability, reliability, and compliance with organizational standards.
• Administer, support, and maintain additional commercial off-the-shelf (COTS) applications as requested.
• Lead efforts in end-user support, application upgrades, bulk data imports/exports, report creation, and resolution of permissions or workflow issues.
• Collaborate with business customers and vendors to resolve application issues, gather feedback, and identify opportunities for continuous improvement of system processes and workflows.
• Diagnose and troubleshoot application issues using advanced debugging techniques; escalate to vendors when needed and validate system fixes to ensure successful resolution.
• Manage and analyze application data using Microsoft SQL Server; develop and run complex queries to detect trends, identify data quality issues, and ensure data accuracy and consistency.
• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from a variety of sources; optimize and troubleshoot SSIS packages for performance and scalability.
• Work closely with business users to design, develop, and deliver Business Intelligence (BI) reports and dashboards that provide meaningful and actionable insights.
• Participate in functional testing and implement application code changes based on evolving business needs; work with stakeholders to improve processes for testing in development environments prior to production rollout.
• Coordinate and implement software change requests and enhancements in collaboration with business customers and IT teams.
• Engage with end users to test new features and functions, ensuring high-quality, error-free deployments; create and maintain documentation, test plans, and user/system guides.
• Ensure all system and application documentation is accurate, up-to-date, and compliant with Software Quality Assurance (SQA) standards. Track and document configuration changes using the ServiceNow change management system.
• Collaborate with IT security staff, business customers, and vendors to proactively address and remediate application security vulnerabilities.
• Deliver ORNL’s mission by aligning behaviors, priorities, and interactions with our core values of Impact, Integrity, Teamwork, Safety, and Service. Promote equal opportunity by fostering a respectful workplace – in how we treat one another, work together, and measure success.

Basic Qualifications:

• A BS degree in computer science, computer engineering, information technology, information systems, science, engineering, business, or a related discipline and a minimum of six (6) to seven (7) years of aligned professional experience is required for consideration. An overall combination of equivalent education and experience may be considered.
  • Masters and PhD degree holders in the same fields of study are also encouraged to apply:
    • Masters’ holders should have a minimum of four (4) to five (5) years of relevant and aligned experience.
    • PhD holders should have up to three (3) years of relevant and aligned experience.
• Six (6) or more years’ experience in the following areas:
  • Experience supporting commercial off-the-shelf (COTS) application software in an enterprise IT environment.
  • Proficiency in managing application-based permissions, workflows, and client/server application architectures.
  • Ability to apply structured application development, data processing, and debugging methodologies.
  • Experience querying and updating complex relational databases.
  • Demonstrated ability to perform in-depth data analysis to identify trends, inconsistencies, and opportunities for data quality improvement; experience in data remediation.
  • Experience developing and delivering custom Business Intelligence (BI) reports.
  • Familiarity with functional business areas, workflow processes, and records management requirements for Tech Transfer, Patents, Inventions, etc.
  • Understanding of Software Quality Assurance (SQA) principles, with experience documenting and testing application changes to ensure accuracy and compliance.

Preferred Qualifications:

• Proficiency in software and code analysis, performance optimization, security best practices, and advanced debugging techniques.
• Experience with unit testing and validating software code to ensure quality and reliability.
• Ability to translate complex business workflows into effective and maintainable application workflows.
• Experience creating end-user documentation, technical guides, and system-level documentation.
• Familiarity with Agile software development methodologies and collaborative team environments.
• Experience designing, developing, and maintaining ETL processes, including data extraction, transformation, and loading using tools such as SQL Server Integration Services (SSIS).
• Ability to excel in a fast-paced research environment, prioritize multiple tasks to meet deadlines, and adapt to evolving needs.
• A highly motivated self-starter who works effectively both independently and as part of a team in various roles.
• Strong customer focus with exceptional written and verbal communication skills.
• Highly organized, capable of managing complex tasks, and providing expert-level support.
• Eagerness to learn and adopt new technologies, especially on custom vendor application platforms.
• Additional desired expertise in:
  • Web services, including SOAP and REST.
  • Traditional web development technologies (e.g., HTML5, CSS, XML, and JavaScript).
  • Microsoft SQL Server (2016 or later).
  • Microsoft Windows Server platforms.

Special Requirements:

Visa sponsorship is not available for this position.

About ORNL:

As a U.S. Department of Energy (DOE) Office of Science national laboratory, ORNL has an impressive 80-year legacy of addressing the nation’s most pressing challenges. Our team is made up of over 7,000 dedicated and innovative individuals! Our goal is to create an environment where a variety of perspectives and backgrounds are valued, ensuring ORNL is known as a top choice for employment. These principles are essential for supporting our broader mission to drive scientific breakthroughs and translate them into solutions for energy, environmental, and security challenges facing the nation.

ORNL offers competitive pay and benefits programs to attract and retain individuals who demonstrate exceptional work behaviors. The laboratory provides a range of employee benefits, including medical and retirement plans and flexible work hours, to support the well-being of you and your family. Employee amenities such as on-site fitness, banking, and cafeteria facilities are also available for added convenience.

Other benefits include the following: Prescription Drug Plan, Dental Plan, Vision Plan, 401(k) Retirement Plan, Contributory Pension Plan, Life Insurance, Disability Benefits, Generous Vacation and Holidays, Parental Leave, Legal Insurance with Identity Theft Protection, Employee Assistance Plan, Flexible Spending Accounts, Health Savings Accounts, Wellness Programs, Educational Assistance, Relocation Assistance, and Employee Discounts.

If you have difficulty using the online application system or need an accommodation to apply due to a disability, please email: [email protected].

ORNL offers a flexible work environment that supports both the organization and the employee. In addition, this position is considered remote-eligible for ORNL in pre-approved locations. Remote eligibility is not a continued guarantee and could be subject to change based on evolving organizational needs.

Post salary range. $115,000 to $135,000

Please note that the pay range information is a general guideline only. Many factors are taken into consideration when setting starting pay. Salary for this position will be commensurate with the final candidate’s qualifications and experience, including skills, knowledge, relevant education, certifications, plus also aligned with the internal peer group. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Link to benefits. https://jobs.ornl.gov/content/Benefits/?locale=en_US

This position will remain open for a minimum of 5 days after which it will close when a qualified candidate is identified and/or hired.

We accept Word (.doc, .docx), Adobe (unsecured .pdf), Rich Text Format (.rtf), and HTML (.htm, .html) up to 5MB in size. Resumes from third party vendors will not be accepted; these resumes will be deleted and the candidates submitted will not be considered for employment.

If you have trouble applying for a position, please email [email protected].

ORNL is an equal opportunity employer. All qualified applicants, including individuals with disabilities and protected veterans, are encouraged to apply. UT-Battelle is an E-Verify employer.