DATA WAREHOUSE ARCHITECT
- Employer
- The University of Texas - Rio Grande Valley
- Location
- Edinburg, TX
View more
- Administrative Jobs
- Technology, Analysts & Programming
- Employment Type
- Full Time
- Institution Type
- Four-Year Institution
Job Details
Responsible for the technical and systems design expertise to support the Enterprise Data Warehouse (EDW) including traditional RDBMs, analytic appliances and data environments, extraction, transformation and loading (ETL), data quality evaluation and management, dimensional (star schema) data modeling, database architecture, warehousing principles, and a host of other activities essential to big data needs of operations and research at the enterprise level.
Description of Duties•Defines, designs and monitors construction of an enterprise data warehouse, including data models, databases, ETL processes, analytics tools and drives all associated access, metadata, data quality, data governance and other components.
•Takes a focused and value-added approach towards specific analytics needs and solutions, yet also conceives and guides the institution towards a big data architecture by taking a comprehensive perspective on UTRGV’s holistic analytics needs.
•Serves as a subject matter expert for all data contained within the data warehouse.
•Actively advocates for usage of data and analytics to allow the institution to make informed decisions around student success, improving business processes, research and medical education.
•Designs a well-integrated data architecture that meets present and future needs of the University.
•Work with data warehouse analysts and business analysts to anticipate and support research and data needs related to areas such as student success, business processes, academic research and medical education with a focus on self-service.
•Responsible for the ETL design and development efforts, making sure that the business rules are implemented correctly and clarifying issues as they arise.
•Develops and executes project estimates and timelines.
•Develops and manages relationships with users, vendors, consultants and other key stakeholders.
•Manages personnel assigned to analytics projects and operations.
•Ensures functional and technical analytics requirements are documented.
•Ensures that logical data warehouse database design fulfills functional and technical requirements by partnering with user groups and developing a clear understanding of the analytics insights that need to be delivered.
•Promotes and facilitates effective communication between the department and the University’s administrative community as well as advising IT management on technical and process issues.
•Creates, implements and enforces standard operating procedures, recommends policies and processes for existing and new services within the defined function/scope for enterprise data warehousing.
•Diligently identifies and pursues data anomalies to ensure the highest level of data integrity.
•Contributes to the ITSM process by executing any assigned roles, including but not limited to Change Manager for routine change requests, and other roles.
•Consults with management, project management and users to provide expert advice on enterprise data warehousing initiatives.
•Manages relationships with users, vendors, consultants and other key information systems stakeholders throughout the University and proactively identifies new projects to enhance the effectiveness of business processes.
•Oversees critical application production problems for resolution by providing expertise, guidance and facilitation for trouble shooting that often involves other IT departments.
•Manages Quality Assurance standards that include reviewing objects to be moved to production and oversees the procedures that include reviewing the changes provided by junior team members to ensure standards and documentation meet expectations as defined.
•Coordinates, schedules and facilitates system changes of the enterprise data warehouse with Business Analysts, Database Administrators, Application Administrators team, Access Administration team and IT Service Helpdesk.
•Maintains continual growth in professional skills and knowledge essential to the position.
•Supervises, manages, and mentors assigned staff
•Participates and recommends in the hiring, training, and evaluation of staff already mentioned in the duty above Ensures compliance with federal, State, and UT System rules and regulations including HIPAA, FERPA, UTS165, PCI.
•Performs special projects and other duties assigned.
General supervision from department director.
Supervision GivenDirect supervision of professional staff.
Required EducationBachelor’s degree from an accredited university with in computer information systems, computer science, or a related field.
Preferred EducationNA
Licenses/CertificationsITIL v3 Foundations Certification or obtain within one year of hire.
Preferred: Microsoft Certified Database Administrator (MCDBA) or Oracle database certified or related certification
Five (5) years of job related work as a data warehouse architect/manager, data modeler, building queries/reports, data marts, cubes, ETL developer and/or as a database administrator or related field, including two (2) years of supervisory experience.
Preferred ExperienceExperience in working with structured enterprise database warehouse environments using common software industry practices in a higher education setting. Team oriented, with strong communication skills.
EquipmentKnowledge of personal computers, office equipment and software, such as Microsoft Office, Adobe Acrobat, SharePoint, various web browsers, etc.
Working ConditionsNeeds to be able to successfully perform all required duties. Office Environment; some travel and night/weekend work is required. On Call responsibilities include being available for work during non-business hours may be required.
OtherAbility to multitask assignments, extremely flexibility on assignments types and the knowledge needs to be very extensive in the technical aspects of their duties. Possess resourcefulness and creative thinking skills for problem resolution. Strong analytical, written, and verbal communication skills. Work effectively as an individual and as a team. Excellent interpersonal and communication skills with experience in presenting other groups within the University.
Physical CapabilitiesNA
Employment CategoryFull-TimeMinimum SalaryCommensurate with ExperiencePosted SalaryCommensurate with ExperiencePosition Available Date10/07/2020Grant Funded PositionNoIf Yes, Provide Grant Expiration DateEEO StatementIt is the policy of The University of Texas Rio Grande Valley to promote and ensure equal employment opportunities for all individuals without regard to race, color, national origin, sex, age, religion, disability, sexual orientation, gender identity or expression, genetic information or protected veteran status. In accordance with the requirements of Title VII of the civil rights act of 1964, the title IX of the Education Amendments of 1972, Section 504 of the Rehabilitation Act of 1973, and the Americans with Disabilities Act of 1990, as amended, our University is committed to comply with all government requirements and ensures non discrimination in it’s education programs and activities, including employment.
Special Instructions to ApplicantsDear Applicant,
Human Resources will not be held responsible for redacting any confidential information from the documents you attach with your application. The confidential information includes the following:
*Date of Birth
*Gender
*Ethnicity/Race
Please make sure that you omit this information prior to submission. We are advising that Human Resources will be forwarding your application to the department as per your submission. The University of Texas Rio Grande Valley reserves the right to discontinue accepting applications prior to the stated close date of this position, after meeting the posting requirement of three (3) calendar days.
If you have any questions, please visit our Careers site at https://careers.utrgv.edu for detailed contact information.
Additional InformationUTRGV is a distributed location institution and working location is subject to change based on need.
All UTRGV employees are required to have a criminal background check (CBC). Incomplete applications will not be considered.
Substitutions to the above requirements must have prior approval from the Chief Human Resources Officer.
Quick Linkhttp://careers.utrgv.edu/postings/25966Posting Supplemental QuestionsRequired fields are indicated with an asterisk (*).
- * Are you a current UTRGV employee?
- Yes
- No
- * Are you now, or previously, employed by The University of Texas System or any of its institutions?
- Yes - I currently am employed by the UT System or its institutions
- Yes - I have previously been employed by the UT System or its institutions
- No - I have never been employed by the UT System or its institutions
- * Please select your highest level of completed education.
- 6th grade education
- 10th grade education
- High School Diploma or GED
- Associates Degree, Technical, or Trade School Degree/Certification or 60 Hours of College Hours
- Bachelors Degree from an accredited university
- Masters Degree from an accredited university
- Ph. D. or other terminal degree from an accredited university
- None of the above
- * Please provide the field of study for your education:
(Open Ended Question)
- * Please indicate the number of years of full time work experience you have directly related to the position in which you are applying for:
- Less than 1 year
- 1 year
- 2 years
- 3 years
- 4 years
- 5 years
- 6 years
- 7 years
- 8 years
- 9 years
- 10 years
- Over 10 years
- * Do you meet the minimum requirements for this position?
- Yes
- No
- Resume
- Cover Letter/Letter of Application
- Curriculum Vitae
- Unofficial Transcripts
- Reference Letter 1
- Reference Letter 2
- Reference Letter 3
- Certifications and Licenses
- Training Certificates
- Other Document
- List of 3 References
- Unofficial Transcripts 2
- Unofficial Transcripts 3
- Letter of Interest
- Unofficial Graduate Transcripts
- Additional Document
Organization
Working at The University of Texas - Rio Grande Valley
A New University with a Long History
The University of Texas Rio Grande Valley was created by the Texas Legislature in 2013 in a historic move that brings together the resources and assets of UT Brownsville and UT Pan American and, for the first time, makes it possible for residents of the Rio Grande Valley to benefit from the Permanent University Fund—a public endowment contributing support to the University of Texas System and the Texas A&M University System.
Our new university will also be home to a School of Medicine and will transform Texas and the nation by becoming a leader in student success, teaching, research, and health care. UTRGV will enroll its first class in the fall of 2015, and the School of Medicine will open in 2016.
UT Brownsville and UT Pan American
The shared history of The University of Texas Pan American and The University of Texas at Brownsville goes back to 1927, when Edinburg College was founded. In 1973, Pan American opened a second campus in Brownsville, which later became an independent institution of The University of Texas System in 1991. Over the years, the missions and the identities of these great institutions have continually evolved to serve the communities of the Rio Grande Valley.
Now, the evolution and connection between these two institutions is coming full circle as UT Brownsville and UT Pan American are being established as a single, new university and medical school, with a single, new identity—The University of Texas Rio Grande Valley.
Learn more about UTRGV here.
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert