What are the responsibilities and job description for the Data Warehouse Administrator position at Y12?
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
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 a minimum 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
- Experience supporting data migration projects
- Planning and executing strategies for transitioning from one database platform to another
- Experience with data governance and security best practices
- Familiarity with reporting tools like Tableau, Power BI, or similar
- 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.
