Database Warehouse Analyst
Classification:Information Systems Professional 3A
Work type:Hybrid, On Campus, Staff Full-time
Administrative Unit:University of Alaska Statewide
School/Business unit:Vice President for Academic Affairs
Categories: Information Systems/Technology, Business/Accounting/Finance
The focus of this position is planning, implementing, and maintaining the University of Alaska
System data warehouse, in coordination with one additional data warehousing staff member.
Priorities for the warehouse function will be set in collaboration with the University of Alaska IR
Shared Services Council.
Coordinate with IR Shared Services Council and other Subject Matter Experts (SMEs) to understand data requirements and knowledge of University of Alaska operations across the four entities.
Defines, designs and maintains a well integrated enterprise data warehouse, including data models, databases, ETL processes, analytics tools and drives all associated access, metadata, data quality, data governance and other components that meet present and future needs of the University of Alaska system.Essential
2Documentation & Data Governance:
Ensure transparent processes are utilized with clear documentation for technical and non-technical users.
Create and implement standards to ensure data access and use aligns with data sharing agreements, BOR policy, university regulation, and state and federal laws for the University system.
Collaborate with IR Shared Services Council and other Subject Matter Experts (SMEs) to establish timely audits of UA information from all university administrative databases and external information, such as the State of Alaska budget information system.
Maintain the common, official, system wide reporting definition standards for use in internal and external reporting.Essential
Provide assistance and support for the development and publication of reports and dashboards.
Maintain knowledge of current methods and technologies that relate to Data
Warehousing, data preparation, data presentation practices and operations.
Performs other duties as assigned.Essential
To ensure consideration, please apply prior to the review date on July 18, 2022 at 11:55pm Alaska Standard Time.
- Experience with database design and loading and reconciling data in a SQL warehouse.
- Fluent SQL skills are required; must be able to read and interpret existing SQL, SAS and other code, to diagnose potential errors, to write corrective code, and collaborate with team members to develop options to address errors in a controlled and transparent way.
- Proficiency with analytics tools such as Excel, Power Pivot, PowerBI, Tableau.
- Experience documenting work efforts, collaborating on shared tasks, and responding to ticket items in time-management or task-management tools such as Jira, Microsoft Planner, Github.
- Familiarity with Master Data Management, data quality tools, and data integration tools. Experience in working with enterprise database warehouse environments using common software industry practices in a higher education setting.
- Team oriented, with strong communication and project management skills.
Minimum 3 years experience, or equivalent combination of training and experience.
REQUIRED EDUCATION OR TRAINING:
Bachelors degree in a relevant field (i.e. Information Technology).
This position is a full-time, Grade 80, (minimum $58,698/yr DOE), 12-month position complete with a competitive salary and UA employee benefits package. UA provides a generous compensation package that includes excellent benefits including retirement options, annual leave, 12 paid holidays per year, tuition waivers for employees and family members, and affordable medical, dental and vision care coverage.
*To be eligible for this position, applicants must be legally authorized to work in the United States without restriction. Applicants who now or may in the future require visa sponsorship to work in the United States are not eligible.
UAF COVID Requirements
Effective immediately, all new UAF hires, whose job function or work location results in the employee being subject to the UAF vaccine requirements guided by the Federal Contractor Employee vaccine mandate*, must be fully vaccinated with an FDA- or WHO- authorized or approved COVID-19 vaccine or have obtained a university-approved disability/medical or religious exemption no later than six weeks from the new hire's start date. Proof of vaccination does not need to be provided to apply. If offered the position, the successful applicant will be contacted for proof of vaccination.
*Employees based on UAF’s Troth Yeddha’ (Fairbanks) campus, regardless of university affiliation and remote work status; Employees based in UAF research units outside Fairbanks (including Seward Marine Center, Kodiak Seafood and Marine Science Center, HAARP, Poker Flat, Lena Point, and Toolik Field Station); and Employees, regardless of their work location, paid by or directly working on impacted UAF federal contract.
Reasonable Accommodation Statement:
The University of Alaska (UA) is responsible for providing reasonable accommodations to individuals with disabilities throughout the applicant screening process. If you need assistance in completing this application or during any phase of the interview process, please contact UA Human Resources by phone at 907-450-8200.
Affirmative Action Statement:
UA is an AA/EO employer and educational institution and prohibits illegal discrimination against any individual: www.alaska.edu/nondiscrimination
The successful applicant is required to complete a background check. Any offer of employment is contingent on the background check.
Pursuant to University Regulation 04.07.020, new employees of the University are employed in an at-will probationary status for the first six months of employment. During the probationary period, employment may be terminated for no reason or any reason. Promoted employees also serve a probationary period with limited rights of retreat.
Public Disclosure Statement:
Your application for employment with the University of Alaska is subject to public disclosure under the Alaska Public Records Act.
University of Alaska is a Drug-Free Workplace. University of Alaska campuses are Tobacco-Free.
It is the policy of the University of Alaska (UA) that all employees are required to complete training to meet the requirements of the positions they hold, and to complete the required training within a specified period to remain employed at the UA.
If you have any questions regarding this position, please contact University of Alaska HR at 907-450-8200.
Advertised: Alaskan Daylight Time
Back to search results Apply now Refer a friend