The Oracle Business Intelligence Solution Architect will serve as the architect for the data warehouse and business intelligence projects. The Solution Architect will be responsible for providing the full solution cycle for Oracle BI implementations. This includes requirements gathering, functional specifications, data modeling, configuration, security, technical specifications, installation, development/customizations, testing, system administration, training, and support.
Bachelor's degree and 4 years of related experience or associate's degree and 6 years of related experience or high school diploma and 8 years of related experience.
Preferred Education and Experience:
Ten plus years of experience creating and customizing repositories, as well as creating custom reports and dashboards. Ten plus years of ETL (E-LT) experience in development, testing, and documentation. Completed multiple full solution cycle projects with HR Analytics and Financial Analytics or Student Analytics utilizing PeopleSoft as the source system.
BS in Business or Computer Science degree
Experience with 5+ projects as the Lead Solution Architect/Technical Lead
Experience with 8+ full solution cycle Oracle BI Implementations
5+ years Oracle Business Intelligence Applications – Version 126.96.36.199.2 or higher. Specific experience with HR Analytics and Financial Analytics versions 188.8.131.52.2 (Student Information Analytics experience a plus
Experience with customization and configuration of OBIA
Experience customizing ODI mappings
Knowledge of BIACM/FSM is required and essential
Experience of setting up and configuring Oracle BI Applications with PeopleSoft as the source is essential
Experience with Data Warehouse best practices, especially in the area of Extract, Load, and Transform (E-LT) methodologies
Strong experience with the pre-built Oracle BI Application
Very strong experience with Oracle Data Integrator ELT tool within the context of OBIA
10+ years ETL experience (5+ years Oracle Data Integrator – Version 184.108.40.206.0 or higher)
5+ years of experience with pre-built Oracle BI Application and data warehouses
10+ years OBIEE 11g/12c
10+ years setting-up and configuring OBIEE security – repository and RPD file security
10+ years Oracle 12c/19c databases
Experience with Higher Education
A strong customer-oriented focus and desire to achieve results
Demonstrated ability to analyze current processes and recommend process improvements
Excellent organization, teamwork, problem-solving, and communication (verbal and written) skills
Ability to work well with people at all levels of the organization and a handle of fast paced, dynamic environment where competing interests and working multiple priorities is the norm
Integration of OBIEE with PeopleSoft I-HUB (Portal) and enable SSO Authentication a plus
Good working knowledge of job scheduling and monitoring tools
Experience with OAS or OAC
1) All employees serve as a representative of the University and are expected to display respect, civility, professional courtesy, consideration of others and discretion in all interactions with members of the UT Dallas community and the general public.
2) UT Dallas does not discriminate on the basis of race, color, religion, sex (including pregnancy), sexual orientation, gender identity, gender expression, age, national origin, disability, genetic information, or veteran status in its programs and activities, including in admission and enrollment. For inquiries regarding non-discrimination policies, contact the Director of Institutional Equity at InstitutionalEquity@utdallas.edu or the Title IX Coordinator at TitleIXCoordinator@utdallas.edu, or call 972-883-5331.
Internal Number: 15956
About The University of Texas at Dallas
The University of Texas at Dallas is an innovative institution in the heart of North Texas on the path to achieving Tier One national research university status.UT Dallas has grown since its founding in 1969 to include 132 degree programs, with cutting-edge curricula serving a variety of undergraduate and graduate student interests.The University continues its original commitment to providing some of the state's most-lauded science and engineering programs and has also gained prominence for a breadth of educational paths, from criminology to biomedical engineering to arts and technology.The wealth of learning resources available to UT Dallas students is the result of a concentrated effort to attract the top minds on both ends of the classroom relationship. Joining the faculty's Nobel laureate and four National Academies members since 2005 are more than 200 tenure and tenure-track professors hailing from the world's best colleges, including Harvard, MIT, Cambridge and Columbia University. In addition, UT Dallas is home to more than 50 centers, labs and institutes that facilitate research and opportunities for hands-on learning. Students, meanwhile, arrive at UT Dallas well-prepared ...to succeed in higher education: In 2011, nearly 39 percent of freshmen ranked in the top 10 percent of their high school class, and 75 percent ranked in the top 25 percent.With an eye on building a future as bright as its beginnings, UT Dallas will continue its push to attain Tier One research university status and produce graduates who are well-equipped to succeed professionally.