Solution Architect (30%) o Leading and guiding a BI Team in realizing the solution on the OBIA platform (OBIEE/ODI) o Provides expert guidance on Business Intelligence skills and technologies. o Develops security and authentication standards for the BI applications o Maintains accurate and complete technical architectural documents. o Defines BI standards, guidelines and best practices for business groups and technical teams o Recommend strategies to improve performance and capacity o Collaborate with BI Administrators, Developers and Analysts for successful development of BI reporting and analysis solutions. o Work with business groups and technical teams to develop and maintain data warehouse platform for BI reporting o Assist management in the development of design policies and procedures which improve the ability to meet system requirements o Ensures overall OBIA Warehouse Configuration, Build and Load (domain load plans, domain mapping customizations) o Oversee technical modifications for ODI and RPD o Possess a complete understanding of the OBIEE environment, from dimensional modeling to front-end report/dashboard design o Oversee design, development/customization, security, migration/merging of RPD o Provide technical oversight and direction for the OBIA architecture including physical data models, ETL (ELT), logical business models and subject areas o Strong understanding of database concepts including views, tables, indexing and backup strategies.
ELT/Data Modeling (20%) o Designs, develops, tests, and troubleshoots complex ELT processes in accordance with business requirements and service level agreements o Extends the data model to house additional structures as needed to meet functional requirements o Designs/customizes fact tables, aggregate tables, and dimensions. o Develops ELT audits and controls to ensure quality of data meets or exceeds defined standards and thresholds
DW Architecture (20%) o Have a strong understanding of the OBIA architecture including physical data models, ETL, logical business models and subject areas o Reviews requirements, architecture, and design components of projects
Front End Development (15%) o Possess a complete understanding of the OBIEE/OAS/OAC environment, from dimensional modeling to front-end report/dashboard design o Design, develop and customize RPD in a multi-user development environment o Create and administer MUDE o Configure and merge RPD's (three-way and/or multi-user patch-based merge process) o Migrate OBIEERPD and catalog objects o Establish and maintain OBIEE security o Create detail documentation of data models, RPD customizations and complex report design
General Technical Functions & Team Collaboration (10%) o Reviews requirements, architecture, and design components of projects o Provide mentoring and training services for both coworkers and business customers o Create detail technical documentation o Troubleshoots and diagnoses complex software problems o Provides for best practices and standards o Strong understanding of database concepts including views, tables, and indexing o Works with the technical business analyst to understand the design/mapping document. Provides feedback, as needed to add clarification o Works with technical business analysts to resolve any incidents o Works with application developers, business partners, management, and Data Warehouse team. o Communicates open items and issues to key stakeholders, including management, development teams, and business areas
Other Duties as assigned (5%)
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
12+ 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
12+ years OBIEE 11g/12c
12+ years setting-up and configuring OBIEE security – repository and RPD file security
12+ 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: 15272
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.