Data Warehouse Programming Specialist jobs in Knoxville, TN

We are looking for a talented Data Warehouse Developer to support UCOR’s mission!

Responsibilities -

Develop and support current data warehouse and application data exchange using existing ETL processes.

Analyze gaps in processes and devise intermediate and long-term solutions that support UCOR’s mission employing SSIS, SQL server, and Oracle.

Lead in planning, designing, and developing a new data warehouse and application integration platform to enhance loading of data from and into different source/target systems.

Communicate with IT project management and clients to understand their business goals and objectives at the direction of an application lead.

Provide quality assurance when interpreting/importing data from multiple sources and maintain data mapping documentation.

Basic Qualifications -

Due to requirements of federal government contracts, must be a U.S. citizen or permanent resident with the ability to remain and work in the U.S. without sponsorship.

Proven experience with SQL Server and Oracle PL/SQL database commands and syntax

Fundamental knowledge of data modeling techniques such as Star and Snowflake.

Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked.

The ability to review, analyze, modify, and create ETLs, utilizing SSIS, testing, debugging, integration and implementation processes.

Document technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.

Strong analytical and problem-solving skills. Ability to navigate multiple complex systems and priorities.

Collaborate with infrastructure team to carry out monitoring, tuning, and database performance analysis.

Ensure all data warehouse architecture codes are maintained in a version control system.

Experience with data security management practices including PII and encryption.

Experience with Business Services systems – Finance, Procurement, Human Resources

Possess an aptitude in assessing emerging technologies especially cloud and unstructured data.

Even better if you have one or more of the following:

· Experience with multiple data analytics tools such as PowerBI, Tableau, Python scripting.

· Experience with API development and management.

· Experience with analytics and business intelligence platform architecture for a hybrid, on-premise/cloud, including internal and third-party clients.

· Experience with Azure Data Factory and API Management.

· Experience with Engineering, Records Management, and/or Construction systems.

Education/Experience:

Bachelor’s degree in Information Technology or other relevant discipline and 12 years of experience in IT ;

or

Associate’s degree or technical diploma/degree in Information Technology and 16 years of relevant experience in IT;

or

20 years of Enterprise level IT experience in an administration, support and/or oversight capacity

Relocation: YES NO X

UCOR prohibits smoking in enclosed areas, including company vehicles.

NOTE 1: Candidates eligible for 3161 status must so indicate on their résumé or cover sheet and provide a copy of their 3161 Preference-In-Hiring Eligibility form with their résumé. Section 3161 of the National Defense Authorization Act requires UCOR to give preference-in-hiring to qualified 3161 eligible displaced Department of Energy (DOE) contractor employees before other external hiring on DOE-funded work is considered. To be 3161 eligible, you must have worked for a DOE contractor on or before September 27, 1991.

NOTE 2: Only web applications will be considered.

Relocation: ☒ YES ☐ NO

Assignment Ends:

UCOR prohibits smoking in enclosed areas, including company vehicles.

NOTE 1: Candidates eligible for 3161 status must so indicate on their résumé or cover sheet and provide a copy of their 3161 Preference-In-Hiring Eligibility form with their résumé. Section 3161 of the National Defense Authorization Act requires UCOR to give preference-in-hiring to qualified 3161 eligible displaced Department of Energy (DOE) contractor employees before other external hiring on DOE-funded work is considered. To be 3161 eligible, you must have worked for a DOE contractor on or before September 27, 1991.

NOTE 2: Only web applications will be considered.

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Employee discount
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Tuition reimbursement
• Vision insurance

Experience level:

• 10 years

Schedule:

• 10 hour shift
• Day shift

Ability to Relocate:

• Oak Ridge, TN 37830: Relocate before starting work (Required)

Work Location: In person