DATA WAREHOUSE DEVELOPER I

Provides routine data warehouse support functions and fundamental tasks including analysis, design, development, and implementation to achieve various functional components of the Enterprise Data Warehouse (EDW) including ETL (Extract, Transform, and Load) tools to extract data from source systems, perform data integrity and cleansing, load automations, and business intelligence reporting. Description of Duties

• Assists with developing, testing, configuring, optimizing, documenting, and deploying database components needed for ETL application layers of the data warehouse while adhering to the Software Development Lifecycle standards.
• Installs, configures, troubleshoots, and maintains data warehouse systems.
• Assists with maintenance of the mapping logic to ETL data sets from a variety of sources systems to the data warehouse dimensional model (star schemas).
• Assists with the management of the data models and data maps for data warehouse system.
• Assists with managing the Data Warehouse processes to ensure interoperability and security of data warehouse systems.
• Plans and coordinates database roll-outs with extended team members.
• Provides support, maintenance, monitoring, troubleshooting, and resolution for data warehouse and database processes.
• Provides support and technical expertise to end-users who create complex queries and reports.
• Works closely with other team members and product owners to understand, document, and design database and ETL processes.
• Develops and supports customer facing reporting, data visualizations, and analytics.
• Assists with analyzing business/data requirements, writing metadata definitions, and writing data mapping specifications.
• Assists with executing judgment/decisions that pertain to the scope of the assignment or project and supports the software development lifecycle.
• Assists with technical research to keep job knowledge up to date to ensure the most feasible technical solution is proposed.
• Researches and evaluates software, system upgrades and enhancements, and provides technical recommendations.
• Contributes ideas and suggestions during team and/or functional meetings.
• Documents solutions using an industry standard technical document format.
• Maintains documentation and performs routine systems administration maintenance activities.
• Researches and incorporates the use of new software tools and languages as necessary to fulfill department needs and objectives.
• Collaboratively works with the Data Warehouse (DW) team members including the DW architect and DW analyst.
• Performs other duties as assigned.

Supervision Received Special supervision from assigned supervisor. Supervision Given Direct supervision of assigned staff. Required Education

Bachelor's degree in Computer Science, Computer Information Systems, or a Computer related major from an accredited university. Preferred Education N/A Licenses/Certifications ITIL Foundation Certification or obtain within one year of hire. Required Experience Two (2) years of experience in the various aspects of software development in one or more software languages in a structured environment using common software industry practices, which include the phases of analysis, design, development, testing and/or implementation. Experienced in relational databases including data warehousing, analytics and reporting. Preferred Experience N/A Equipment Use of standard office equipment. Working Conditions Needs to be able to successfully perform all required duties. Office Environment; some travel and weekend work is required. Exerting up to 20 pounds of force frequently, and/or a negligible amount of force constantly to move objects. UTRGV is a distributed institution, which requires presence at multiple locations throughout the Rio Grande Valley. Work is performed primarily in a general office environment across the Rio Grande Valley. Other Possess resourcefulness and creative thinking skills for problem resolution. Possess analytical skills to effectively and accurately identify problem code. Good written and verbal communication skills. Possess technical research skills (technical manuals and resources). Work effectively as an individual and as a team. Possess technical writing skills for documentation., To the extent this position requires the holder to research, work on, or have access to critical infrastructure as defined in Section 117.001(2) of the Texas Business and Commerce Code, the ability to maintain the security or integrity of the critical infrastructure is a minimum qualification to be hired and to continue to be employed in the position., + 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

4. • Please provide the field of study for your education: (Open Ended Question)
5. • Please indicate the number of years of 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

6. • Do you meet the minimum requirements for this position?

It 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 its education programs and activities, including employment. We encourage women, minorities and differently abled persons to apply for employment positions of interest. Special Instructions to Applicants Dear 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 Social Security Number 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., 2. Curriculum Vitae

3. Unofficial Transcripts
4. Reference Letter 1
5. Reference Letter 2
6. Reference Letter 3
7. Certifications and Licenses
8. Training Certificates
9. Other Document
10. List of 3 References
11. Unofficial Transcripts 2
12. Unofficial Transcripts 3
13. Letter of Interest
14. Unofficial Graduate Transcripts
15. Additional Document

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 VP of HR & Talent Development . Quick Link https://careers.utrgv.edu/postings/52048 Posting Supplemental Questions Required fields are indicated with an asterisk (*). 1. * Are you a current UTRGV employee? + Yes + No 2. * 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 3. * Please select your highest level of completed education. + 6th grade education