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.
Solution Architect (30%)
Guide BI Team in deploying, configuring, and operationalizing the OBIA platform (OBIEE/ODI)
Provide expert guidance on Business Intelligence skills and technologies
Develop security and authentication standards for BI applications
Maintain accurate and complete technical documentation
Define BI standards, guidelines and best practices for business and technical teams
Collaborate with BI Administrators, Developers and Analysts for successful development of BI reporting and analysis solutions
Work with business groups and technical teams to develop and maintain data warehouse platform for BI reporting
Oversee design, development/customization, security, migration/merging of RPD
Oversee change management for supported solutions
ELT/Data Modeling (20%)
Provide technical oversight and direction for the OBIA architecture including physical data models, ETL (ELT), logical business models and subject areas
Design, develop, test, and troubleshoot complex ELT processes in accordance with business requirements and service level agreements
Extend the data model to house additional structures as needed to meet functional requirements
Develop ELT audits and controls to ensure quality of data meets or exceeds defined standards
DW Architecture (20%)
Have a strong understanding of the DW architecture including data models, ETL, logical business models and subject areas
Review requirements, architecture, and design components of projects
Front End Development (15%)
Design, develop and customize RPD in a multi-user development environment
Create detail documentation of data models, RPD customizations and complex report design
General Technical Functions & Team Collaboration (10%)
Review requirements, architecture, and design components of projects
Provide mentoring and training for coworkers and business customers
Create detailed technical documentation
Troubleshoot and diagnose complex software problems
Work with technical Business Analysts to resolve any incidents and communicate open issues to key stakeholders, management, and development teams
Other Duties as assigned (5%)
Minimum Qualifications:
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 Qualifications:
Ten plus years of experience creating and customizing repositories, custom reports and dashboards.
Experience with enterprise-scale projects in a technical leadership role
Experience with BI Implementations
Experience with customization and configuration of OBIA
Experience with Data Warehouse best practices
A strong customer-oriented focus and desire to achieve results
Excellent organization, teamwork, problem-solving, and communication skills
Good working knowledge of job scheduling and monitoring tools
Additional Information:
Position location will be discussed during the interview process. Location can be Fort Worth, TX or Richardson, TX.
Hybrid remote work environment available. A UT Dallas Remote Work Agreement is required upon employment. Must have the ability to be on Richardson campus with 48 hours of notice.
UT Dallas is a top public university located in one of the nation’s fastest-growing metropolitan regions. Our seven schools offer more than 140 undergraduate and graduate programs, plus professional certificates and fast-track programs. https://www.utdallas.edu/
The University of Texas System has served Texas for more than 140 years, improving the lives of Texans—and people all over the world—through education, health care and research at 13 academic and health institutions across the state. With an enrollment of more than 244,000 students and an operating budget of $25.2 billion, the UT System is one of the nation’s largest public university systems of higher education in the world. https://www.utsystem.edu/
The Office of Shared Information Services consolidates redundant IT and business services in the institutions we service with multiple, geographically distributed units. Shared Services is distinct from mere centralization or services in that it encompasses the concept of shared governance and permits greater flexibility and responsiveness. It creates incentives for participation and is overseen not just by UT System personnel, but also by representatives of the participating campuses. https://finance.utdallas.edu/shared-information-services/
The Oracle Applications & Technology Users Group (OATUG), formerly the Oracle Applications Users Group (OAUG), is the world’s largest education, networking and advocacy forum for Oracle Applications & Technology users.