What are the responsibilities and job description for the Data Warehouse Administrator position at Pantex Plant?

Location: Oak Ridge, Tennessee
Job Title: Data Warehouse Administrator
Career Level From: Senior Associate
Career Level To: Senior Specialist
Organization: Business Applications (51426342)
Job Specialty: System Development

What You'll Do

The Data Warehouse Administrator will help oversee our current Oracle-based data warehouse while helping to plan and realize a migration to our new data warehouse solution designed to store our historical business data for years to come. This role involves optimizing data integration processes, ensuring data quality and security, and collaborating with stakeholders to deliver actionable insights. The successful candidate will be a key driver in implementing best practices and maintaining high performance within our data warehouse environment.

Responsibilities
* Manage and maintain the current Oracle-based data warehouse environment, ensuring optimal performance, scalability, and availability
* Contribute to the evaluation, selection, and implementation of a purpose-built data warehouse solution to store historical business data
* Design, develop, and optimize ETL/ELT processes for data integration, transformation, and loading
* Monitor data integrity, security, and quality across the data warehouse
* Collaborate with stakeholders, including business analysts and data scientists, to understand requirements and deliver actionable insights
* Plan and execute data migration strategies to transition from the current Oracle database to the new solution
* Develop and document best practices, workflows, and system configurations
* Troubleshoot and resolve data warehouse performance and reliability issues
* Stay up-to-date with industry trends and advancements in data warehousing technologies

What You Can Expect

Meaningful work and unique opportunities to support missions vital to national and global security
Top-notch, dedicated colleagues
Generous pay and benefits with a stable organization
Career advancement and professional development programs
Work-life balance fostered through flexible work options and wellness initiatives

Minimum Job Requirements

Bachelor's degree in engineering/science/information technology discipline and aminimum 2 years of relevant experience
OR Master's degree in engineering/science/information technology discipline

Preferred Job Requirements

Technical Expertise:
* Proven experience managing data warehouse, data lake, or business warehouse environments
* Proficiency with Oracle database management, including performance tuning and backup/recovery
* Hands-on experience with data warehouse technologies (e.g., Teradata, Snowflake (on-prem version), IBM Db2, SAP BW/4HANA)
* Strong knowledge of ETL/ELT tools and processes
* Familiarity with data modeling, schema design, and SQL query optimization
* Knowledge of scripting languages (e.g., Python, Shell scripting) for automation
Project and Migration Experience:
* Experience supporting data migration projects
* Planning and executing strategies for transitioning from one database platform to another
Data Governance and Reporting:
* Experience with data governance and security best practices
* Familiarity with reporting tools like Tableau, Power BI, or similar
Additional Skills and Certifications:
* Excellent problem-solving and analytical skills
* Strong communication skills and the ability to work collaboratively across teams
* Certifications in relevant database or data warehouse technologies is a plus

Why Y-12?

You get #morethanajob. We encourage employees to achieve a healthy personal balance among home, work and the community. One of the ways we embrace work-life balance is by offering flexible work arrangements that provide alternatives to the traditional workweek, while still meeting business needs. Top talent and personal commitment mean more to our success than any other factors, so we reward our people with the kinds of benefits that make a positive difference in the quality of their lives. Benefits such as: medical plan, prescription drug plan, vision plan, dental plan, employer matched 401(k) savings plan, disability coverage, education reimbursement and many more. Want to stay healthy and fit but hate the cost of a gym membership? Take advantage of one of our onsite workout facilities and eat healthy in our onsite cafeterias. Much more than a workplace, at Y-12, you can build a career that lasts a lifetime.

Notes

The minimum education and experience for the lowest career level in the job posting range are listed under Minimum Job Requirements. Successful candidates hired into a higher career level than the minimum in the range must meet the requirements listed in the job leveling charts for the career level into which they are being hired.

If a range of Career Levels is posted, i.e., Senior Associate to Senior Specialist, internal applicants already in one of the Career Levels would come across at their current Career Level. Internal applicants currently in a lower level Career Level would move to the lowest posted Career Level.

Requires a Q clearance; however all qualified candidates will be considered regardless of their current clearance status. The ability to obtain and maintain a Department of Energy Q clearance is required.

This position may require entry into the Material Access Areas (MAA) and participation in the Human Reliability Program (10 C.F.R. Part 712), which requires successful competition of a DOE counterintelligence evaluation and may include a counterintelligence-scope polygraph examination.

This position may be categorized as a "designated position" identified by 10 C.F.R. Part 709, requiring successful completion of a DOE counterintelligence evaluation that may include a counterintelligence-scope polygraph examination.

CNS is a drug-free workplace. Candidates accepting a job offer will be required to pass a pre-placement physical, drug screening and background investigation. As an employee, you may be required to receive and maintain a security clearance from the United States Department of Energy in order to meet eligibility requirements for access to sensitive information or matter. U.S. citizenship is a requirement for security clearance applicants. All employees are subject to being randomly selected for drug testing without advance notification.

CNS is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, gender, sexual orientation, gender identity, age, religion, national origin, ancestry, genetic information, disability or veteran status.

Apply for this job

Receive alerts for other Data Warehouse Administrator job openings

Data Warehouse Administrator

What are the responsibilities and job description for the Data Warehouse Administrator position at Pantex Plant?

What is the career path for a Data Warehouse Administrator?

Job openings at Pantex Plant

Not the job you're looking for? Here are some other Data Warehouse Administrator jobs in the Ridge, TN area that may be a better fit.

We don't have any other Data Warehouse Administrator jobs in the Ridge, TN area right now.

AI Assistant is available now!