What are the responsibilities and job description for the HBITS-07-14545-Database Architect-Senior position at Knowledge Builders Inc?
Job Description Project/Program: PRJ0251793 - DCS - MENA Legislation Project
Job Description
Data architect to assist the Reporting team with MENA enhancements and other reporting duties.
Day To Day
The consultant must work within a designated team and coordinate with multiple developers in a technical team setting and perform senior-level Business Intelligence Development Support tasks including:
Database Architect: Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Senior: 60 - 84 Months: Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.
Requested Qualifications
Job Description
Data architect to assist the Reporting team with MENA enhancements and other reporting duties.
Day To Day
The consultant must work within a designated team and coordinate with multiple developers in a technical team setting and perform senior-level Business Intelligence Development Support tasks including:
- Manage ODI SQL scripts for transferring, loading, and editing data between databases.
- Manage data warehouse to hold LATS and WFA (Work Force Analytics) data.
- Manage scripts for loading LATS and WFA data from extracts into Oracle tables using UNIX.
- Conversion of UNIX scripts into ODI.
- Conversion of Crystal Reports into OAS/OBIEE.
- Manage OBIEE reports and dashboard.
Database Architect: Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Senior: 60 - 84 Months: Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.
Requested Qualifications
- 60 months of experience with Oracle Business Intelligence Enterprise Edition (OBIEE) / Oracle Analytics Server (OAS)
- 60 months of experience with Oracle Data Integrator (ODI)
- 60 months of experience with UNIX
- 60 months of experience with SQL or PL/SQL