Senior Business Systems Analyst

Knoxville Technology Council; Oak Ridge (TN); On-site; USD 110,000 - 140,000; Full time

Job summary

Oak Ridge National Laboratory is seeking a Senior Business Systems Analyst to support and enhance the ERP environment. You will analyze business needs, configure systems, and develop data integrations.

The role emphasizes dashboards, reporting, and Oracle APEX applications, with collaboration across divisions and engagement in Agile practices. Ideal candidates have strong SQL skills, ERP experience, and a proven ability to translate requirements into technical solutions.

Qualifications

• BS Degree in IT, Computer Science, Engineering, Business, or related field and 8+ years of experience.
• Hands-on experience with modern ERP systems, including implementation, configuration, and end-user support.
• Experience in ERP environments covering MRP, MPS, Planning, Scheduling, Inventory Management, BOMs, and Item Masters.
• Working knowledge of SQL with Oracle or SQL Server.
• Experience creating dashboards and reports using Power BI.
• Programming or scripting for automation or customization.
• Experience with Oracle APEX or similar platforms.
• Familiarity with Agile or iterative software development.

Responsibilities

• Provide analytical and technical support for ERP and custom systems, including reports and configuration.
• Translate business needs into system requirements and technical specs.
• Develop and optimize SQL queries and data integrations across Oracle/SQL Server.
• Build dashboards and data models to support analytics and operations.
• Develop and support Oracle APEX applications, workflows, and dashboards.
• Assist with automation and system enhancements through scripting.
• Participate in Agile software development, sprint planning, and documentation.
• Collaborate with cross-functional units to identify process improvements and system enhancements.

Skills

SQL proficiency

Analytical thinking

Communication skills

Problem solving

Stakeholder collaboration

Education

Bachelor's degree in IT/CS/Engineering/Business or related field

Tools

Oracle

SQL Server

Power BI

Oracle APEX

GitLab

Job description

Overview

The Enrichment Science and Engineering Division (ESED), within Oak Ridge National Laboratory’s Isotope Science and Engineering Directorate, is seeking a Senior Business Systems Analyst position in the Systems Administration Group under the Systems & Process Assurance (SPA) Section. ESED is one of four Divisions of the Isotope Science and Engineering Directorate (ISED) at Oak Ridge National Laboratory (ORNL).

Requisition Id 17121

Overview

The Enrichment Science and Engineering Division (ESED), within Oak Ridge National Laboratory’s Isotope Science and Engineering Directorate, is seeking a Senior Business Systems Analyst position in the Systems Administration Group under the Systems & Process Assurance (SPA) Section. ESED is one of four Divisions of the Isotope Science and Engineering Directorate (ISED) at Oak Ridge National Laboratory (ORNL).

ESED serves the nation in two critical areas: advancing enrichment technologies and exploring enriched stable isotope production and applications. The division leverages an elite staff of scientists and engineers with the world-leading capabilities of Oak Ridge National Laboratory to deliver groundbreaking advancements with a variety of applications, from national security to life‑saving medical treatments.

The Business Systems Analyst position will support and enhance ESED’s Enterprise Resource Planning (ERP) environment. The successful candidate will provide analytical, technical, and development support for key business systems, focusing on ERP configuration and implementation, data integrations, reporting tools, and application development frameworks. This role partners closely with stakeholders across the division to ensure business systems are optimized, reliable, and aligned with organizational requirements.

Major Duties/Responsibilities

• Provide analytical and technical support for the division’s business systems (ERP and custom solutions), including report development, system configuration, troubleshooting, and end‑user assistance.
• Translate organizational needs into system requirements, functional specifications, and technical solutions.
• Develop, optimize, and maintain SQL queries, stored procedures, and database integrations across Oracle or SQL-based platforms.
• Build and maintain dashboards, reports, and data models to support analytics and operational insights.
• Develop, maintain, and support Oracle APEX and other custom solutions, including applications, workflows, and dashboards.
• Utilize general programming or scripting skills to support automation, system enhancements, and integrations.
• Participate in and support Agile software development practices, including sprint planning, backlog refinement, iterative development, and documentation.
• Collaborate with cross‑functional business units to evaluate processes, identify improvement opportunities, and deliver system enhancements.
• Support data governance, data quality, and ERP data architecture initiatives.
• Assist with ERP upgrades, system testing, documentation, and user training.
• Manage and support integration between ERP and other systems.

Basic Qualifications

• BS Degree in IT, Computer Science, Engineering, Business, or related field and 8+ years of experience. An equivalent combination of education and experience may be considered.
• Hands‑on experience with modern ERP systems, including implementation, configuration, and end‑user support.
• Proven knowledge of engineering, manufacturing, supply chain, or business operations within an ERP environment (MRP, MPS, Planning, Scheduling, Inventory Management, BOM’s, Item Masters, etc.).
• Working knowledge of SQL, including writing queries in Oracle or SQL Server.
• Experience developing dashboards and reports using Power BI or comparable platforms.
• Demonstrated experience with general programming or scripting for automation or system customization.
• Experience developing applications or workflows using Oracle APEX or comparable platforms.
• Familiarity with Agile or iterative software development methodologies.
• Strong analytical, problem‑solving, communication, and documentation skills.
• Ability to work effectively with both technical and non‑technical stakeholders.

Preferred Qualifications

• Experience with ERP integrations, APIs, or middleware platforms.
• Experience with GitLab or similar platforms (e.g., GitHub, Bitbucket) for version control and development workflow management.
• Practical experience applying Agile methodologies to software development, system enhancements, and cross‑functional collaboration.
• Familiarity with data warehousing, ETL (Extract, Transform, Load), or data pipeline concepts.
• Experience in government, scientific, engineering or other highly technical environments.
• Familiar with DOE Software Quality Assurance (SQA) requirements.

Special Requirements

• This position requires the ability to obtain and maintain a clearance from the Department of Energy. As such, this position is a Workplace Substance Abuse Program (WSAP) testing‑designated position. WSAP positions require passing a pre‑placement drug test and participation in an ongoing random drug testing program.
• Visa sponsorship is not available for this role.

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.

• medical and retirement plans
• flexible work hours
• on‑site fitness
• banking
• cafeteria facilities

• 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
• Employee Discounts

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.

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.