Data Warehouse Administrator 16362
Data Warehouse Administrator 16362
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Location: Oak Ridge Tennessee
Job Title: Data Warehouse Administrator
Career Level From: Senior Associate
Career Level To: Senior Specialist
Organization: Business Applications
Job Specialty: System Development
What Youll Do
The Data Warehouse Administrator will help oversee our current Oraclebased 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 Oraclebased data warehouse environment ensuring optimal performance scalability and availability
Contribute to the evaluation selection and implementation of a purposebuilt 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 uptodate 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
- Topnotch dedicated colleagues
- Generous pay and benefits with a stable organization
- Career advancement and professional development programs
- Worklife balance fostered through flexible work options and wellness initiatives
Minimum Job Requirements
- Bachelors degree in engineering/science/information technology discipline and aminimum 2 years of relevant experience
- OR Masters 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
Handson experience with data warehouse technologies (e.g. Teradata Snowflake (onprem 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 problemsolving 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 Y12
Notes
CNS is a drugfree workplace. Candidates accepting a job offer will be required to pass a preplacement 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.
Required Experience:
Unclear Seniority
Employment Type
Part-Time
