Posting Details
Posting Number S05268P Position Title Data Warehouse Systems Analyst Functional Title Data Warehouse Systems Analyst Department Office of Institutional Success and Decision Support Salary Range $90,000 DOQ Pay Basis Monthly Position Status Regular full-time Location Richardson Position End Date (if temporary) Posting Open Date 11/07/2023 Posting Close Date Open Until Filled Yes Desired Start Date 12/01/2023 Job Summary
Responsible for design, implementation, and support of the University Data Warehouse applications, ETL processes, web applications, and visualizations. The systems analyst develops reporting and software integration solutions for Oracle-based ERPs, enterprise system data sources, tools automation, web-based reporting archive portal, and MS Windows Services.ย
Reporting to the Director of Data Warehouse, the systems analyst works with stakeholders to develop, update, and maintain data queries, institutional reports, automated processes, participate in data governance initiatives, and investigate new architectures and technologies in support of the strategic mission of the university.
Minimum Education and Experience
Bachelor's degree in MIS, CS, Accounting, Business or a directly related field.
Minimum of eight (8) years of experience in IT, 3+ years experience specifically in data warehouse/decision support environment acting as either a business analyst or systems analyst or an equivalent combination of relevant education and experience.
Preferred Education and Experience
Preferred Education and Experience
Bachelor's degree in computer science or a related Field, 3 - 5 years of relevant programming experience preferred. Experience with Oracle databases (creating/maintaining packages, stored procedures, triggers); proficiency in SQL, DDL, MS Office products, VB.Net, PHP, Java, Grails, Angular, Apache, Tomcat, C#; functional knowledge of MS Windows and Linux or Unix servers.
Essential Duties and Responsibilities
- Manage Oracle/Web applications and scripts dedicated to the maintenance and enhancement of the University Data Warehouse in support of student success, administration, and business operations.
- Support database architecture, structures and techniques, and is responsible for adapting those to dynamic requirements from a variety of stakeholders.
- Develop database applications, understand and interpret technical terminology and participate in architecture planning.
- Investigate, analyze and Interpret data or information for accuracy and completeness so resulting reports may be used to make informed decisions, plans and schedules.
Physical Activities Working Conditions Additional Information
The ideal candidate will have experience working with stakeholders to build reports and data extracts and web-based applications. Ability to multitask, work effectively in team situations; strong written, oral, listening and interpersonal skills; responds effectively in a timely manner in a variety of situations; demonstrates integrity and ethical behavior in working with confidential information.
Applicant understands different work styles, conflict resolution techniques and demonstrated ability to deal with employees in a positive manner. Can learn new technologies quickly and apply this new knowledge to further the goals of the department.
This role is eligible for a hybrid work schedule, subject to manager approval. A UT Dallas Remote Work Agreement will be required within 14 days upon approval after hire. Remote work arrangements are subject to regular review and re-approval and may be canceled at any time. The Data Warehouse Systems Analyst must be located within the DFW Area.
What We Can Offer
UT Dallas is an Equal Opportunity Employer. We offer an employee-friendly work environment with a comprehensive benefit package including:
Competitive Salary
Tuition Benefits
Internal Training
Medical insurance - including 100% paid employee medical coverage for full-time employees
Dental Insurance
Vision Insurance
Long and short-term disability
Retirement Plan Options
Paid time off
Paid Holidays All UT Dallas employees have access to various professional development opportunities, including a membership to Academic Impressions, LinkedIn Learning, and UT Dallas Bright Leaders Program.
Visit https://hr.utdallas.edu/employees/benefits/ for more information.
About Us
UT Dallas is a top public research 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. Our student body is 31,000 strong, reflecting students from over 100 countries and a multiplicity of identities and experiences.
UT Dallas is committed to graduating well-rounded members of the global community whose education has prepared them for rewarding lives and productive careers in a constantly changing world. A diversity of people, ideas, and perspectives is crucial to our vision and mission. UT Dallas is a place where members of the community from all backgrounds are welcomed, treated fairly, and encouraged in their pursuit of excellence.
The University has a variety of programs and initiatives to support engagement and success for all members of the campus community. Employee benefits include a range of physical and mental wellness resources. "LilyPad" lactation facilities are located throughout the campus. There are several Employee Resource Groups (ERGs) comprised of individuals who share common interests to help build community among UT Dallas faculty and staff (e.g., Universal Access ERG, Military and Veteran ERG, UT Dallas Young Professionals).
Rich with visual and performing arts venues, museum districts, professional and semi-professional athletics teams, botanical gardens, accessible trails and so much more, the Dallas-Fort Worth (DFW) metroplex has something for everyone to explore. UT Dallas partners with regional higher education institutions and school districts and with the Richardson Innovation Quarter (Richardson IQ), a major hub for innovation, entrepreneurship, and educational activities.ย
Special Instructions Summary Important Message
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) The University of Texas at Dallas is committed to providing an educational, living, and working environment that is welcoming, respectful, and inclusive of all members of the university community. 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 services, programs, activities, employment, and education, including in admission and enrollment. EOE, including disability/veterans. The University is committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities. To request reasonable accommodation in the employment application and interview process, contact the ADA Coordinator. For inquiries regarding nondiscrimination policies, contact the Title IX Coordinator.