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 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
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.
