"Alerted.org

Req #: 245987

Department: OFFICE OF RESEARCH INFORMATION SERVICES

Appointing Department Web Address: https://www.washington.edu/research/oris/

Job Location Detail: available for telework/hybrid/remote

Posting Date: 05/12/2025

Closing Info:

Open Until Filled

Salary: $10,000 - $11,000 per month

Shift: First Shift

Notes:

As a UW employee, you will enjoy generous benefits and work/life programs. For a complete description of our benefits for this position, please visit our website, click here. (https://hr.uw.edu/wp-content/uploads/sites/3/2018/02/benefits-professional-staff-librarians-academic-staff-20230119\_a11y.pdf)

As a UW employee, you have a unique opportunity to change lives on our campuses, in our state and around the world. UW employees offer their boundless energy, creative problem-solving skills, and dedication to build stronger minds and a healthier world.

UW faculty and staff also enjoy outstanding benefits, professional growth opportunities and unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits, and natural beauty.

The University of Washington is one of the world’s preeminent public universities in impact and funding. Since 1972, the UW has continued to receive more externally sponsored research funding than any other U.S. public university and is one of the few universities in the U.S. with total research funding nearing two billion. That funding drives crucial, ground-breaking research that transforms lives around the globe. In the Office of Research at UW, we take pride in creating an outstanding climate of support for UW researchers that helps them compete and succeed. However, the complexity of research administration and regulation grows each day. Our mission in ORIS (Office of Research Information Services) is to reduce that administrative burden by streamlining and automating information services so researchers can spend more time researching. The performance, reliability, availability, scalability, and security of UW Research Administration reporting solutions is important to continuing the UW mission.

Purpose:

The Office of Research Information Services (ORIS) Data Engineer for Data Warehousing/Business Intelligence (DW/BI) is critical for the continuing functionality and evolution of the technologies that enable important and necessary UW Research Administration reporting and analytics from infrastructure through reporting/dashboarding. This position is an essential, singular contributor who works with others to aggregate data from various business systems to provide timely, accurate, and critical business intelligence, visualizations, reports, and analytics to decision-makers and contributors at all levels of the University. These efforts provide the UW research community with an indispensable understanding of University research administration dynamics (proposals, submissions, funding, expenditures, compliance, etc.) in order to demonstrate scope of activities and improve operational effectiveness. Operations consist of supporting data solutions, some of which target 24/7/365 availability to meet University needs. In addition to building on and maintaining over a decade of reporting and analytics (Research Administration Data Warehouse), this position is also a pivotal team member in developing cloud-native reporting analytics, machine learning, and AI enhancement.

The Data Engineer (DW/BI) is a seasoned data professional with experience in advanced SQL, data design, modeling, and aggregation methods (such as data warehouse, lakehouse, and data lake), and modern software engineering tools and practices who works on teams with other engineers (such as data, cloud, and application engineers) and other disciplines (business analysts, report analysts, project managers, product owners, etc.). This position will also work across multiple University products both within the Office of Research and with partners across the University. This position will continue to mature our technology in both data warehousing and business intelligence including the use of machine learning and AI enhanced analytics.

Position Complexities:

At a technical level, the Data Engineer (DW/BI) is the primary contributor who supports business critical data pipelines, modeling, warehousing, and analytics that come from business systems within the Office of Research and across the University. The data sources that are aggregated include data about people, roles, activities, location, financial, employment, and more. These sources include sensitive data that must be kept secure from unauthorized access while maintaining high availability for authorized usage. The data is often operational in nature (sometimes from legacy systems) and requires thoughtful analysis and modeling to ensure accurate and timely reporting for compliance, operations, and University strategic decision making.

Further, because of the technical breadth of the position, the position must:

• Lead, plan, and advise on the strategic and tactical direction of all facets of data warehousing and business intelligence across multiple critical University needs (compliance, research administration operations, and responding to emerging, emergent needs), from meeting security requirements to ensuring stability, performance, and availability requirements are met

• Align essential data and database configuration, maintenance, and operations with overall ORIS IT operational goals and business objectives as outlined by ORIS program portfolio that supports UW’s $1.89 billion research enterprise.

• Collaborate and consult with multiple teams of diverse staff including junior and senior engineering staff as well as technical leads, product owners, and project managers across multiple products.

Position impact to the University:

This position advances the Office of Research’s mission to support the integration of electronic research information systems as a data engineer, ensuring the optimized and performance applications with the data pipelines, warehousing, and business intelligence. Without this position, the University would not be able to respond quickly to emergent and emerging reporting needs, would not be able to improve operational efficiencies, and would not be able to maintain critical reporting and analytics tools and repositories. The success of the Data Engineer (DW/BI) will reduce the administrative burden on researchers across the University by improving the amount of time researchers can spend on researching; improve University compliance; provide stakeholders with critical analytics and reporting, and ensure that the University can continue to be at the forefront of academic research.

Responsibilities:** **Data Warehouse and Business Intelligence Engineering and Support (65%)

• Design, Deploy, configure, maintain, and deprecate data warehouse, data pipelines, business intelligence solutions, and other persistent reporting structures and tools (including using machine learning and AI) that are key to the success of University administration and research community

• Ensure that data warehouse and business intelligence solutions are engineered and maintained in alignment with the ORIS technology strategy and engineering principles (such as performant, secure, scalable, sustainable, and reliable), in alignment with the ORIS integration approaches, and follow ORIS quality assurance standards and processes

• Using business requirements and working with others, provide dimensional modeling, data normalization/denormalization, metadata requirements, abstraction, data mapping, data cleansing, error handling, dashboarding and similar activities across ORIS products and services in order to meet essential University needs around reporting and descriptive, predictive, and prescriptive analytics

• Support analytics by creating model and other technical requirements; improve legacy software and models; defining source applications and data; refining reporting need; troubleshooting problems in data and data models; and mapping between source systems and reporting objects from systems across the University to ensure performance and accurate reports and analytics to meet critical University needs and requirements

• In collaboration with analysts, team members, and partners across the University, translate high-level and detailed business requirements into high quality data solutions that are useful beyond the initial business requirements

• Develop and assist with SQL query design for applications and reporting to meet organizational needs and ORIS commitments

• Recommend, design, implement, and maintain automation to reduce repetitive software development and maintenance tasks and increase application performance

• Analyze data manually and programmatically as needed to meet emergent University need

• Engage and participate in ORIS’ culture of review both as reviewer and reviewee to ensure shared knowledge of development practices and high-quality solutions

• Troubleshoot and resolve data warehouse and analytics incidents, issues, and problems

Technical Planning, Consultation, and Collaboration (25%)

• Collaborate and lead on aspects of project planning; technical infrastructure design and acquisition; and customer support to support end-to-end reporting and analytics capabilities both for the present products and services and roadmaps for the future

• Lead and collaborate in the growth of data governance and quality best practices with partners in the Office of Research and across the University to ensure the accuracy, timeliness, integrity, availability, consistency, and appropriate level of confidentiality of analytics across areas

• Maintain an awareness of industry, institutional, and organizational trends, best practices, and standard solutions, including machine learning assisted and AI-enhanced analytics

• Utilize industry best practices to gather and document requirements for all organizational BI needs

• Socialize key concepts, industry best practices, and organizational principles, strategies, and conventions related to data, data warehouses, and business intelligence to both technical and non-technical staff via mentoring, meetings, hands-on learning, and documentation

• Support analysts, team members, and other power users is designing, developing, and deploying business intelligence tools and reports to enable efficient and effective solutions for university needs

• Become familiar with research administration in an R1 university setting in order to to ensure solutions meet University needs

Administrative Duties – (10%)

• Attend recurring organization meetings and one-on-ones with a supervisor.

• Engage in unplanned communications

• Participate in recurring HR processes

Experience Required:

• Bachelor’s degree in Engineering, Computer Science, Math/Statistics, Business Administration, or equivalent experience

• 6+ Years of experience in data warehousing, business intelligence, and analytics to include at least the following minimum professional experience:

• 2+ years Data warehouse design and implementation

• 2+ years Dimensional modeling and data cube design (such as data normalization/denormalization, abstraction, dimensionality, etc.)

• 2+ years Data pipelines (ETL and others) design, testing, and production implementation and support; including tools (such as SQL Server Integration Services (SSIS), AWS Glue, AWS DMS, Informatica, or Alteryx)

• 2+ years SQL queries, stored procedure development, query optimization, and tuning (such as query profiling and optimization tools for both relational and non-relational databases)

• 2+ years Business Intelligence and visualization tools (such as Power BI, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Quicksight, and Tableau Server)

• 2+ years’ Experience with formal software engineering practices (such as source code version control, debugging, problem identification, troubleshooting, validation/deployment/maintaining applications)

• 2+ years ensuring data, report, and/or analytics (such as quality including data definitions, data governance, data assessments, and data readiness/risk assessments)

• Demonstrated expertise with machine learning based or AI enhanced analytics

• Demonstrated strong organizational and multitasking skills from experience in complex, ambiguous, and/or matrix environments with a proven attention to detail

• Demonstrated expertise with Cloud-based technologies (especially AWS)

• Demonstrated strong interpersonal skills with the ability to work both in groups with diverse personalities and independently

• Demonstrated enthusiasm to find and bring innovative solutions to build on past successes and opportunities

• Demonstrated ability to translate complexity into comprehensible concepts for both technical and non-technical audiences

• Demonstrated ease in technical and non-technical review as both reviewer and reviewee in order to facilitate collaborative group activities such as change control and pull request review

Experience Desired:

• Knowledge of Python or R for data processing and advanced analytics

• Experience in Statistical Analysis packages such as R, SAS and Matlab

• Information security and data privacy frameworks knowledge (NIST, COBIT, PCI-DSS, SOC2, etc.)

• Open-source database technologies: PostgreSQL, MySQL, MongoDB, Oracle, etc.

• Working in a Scrum-Agile environment

• Workday suite of applications/modules (including Workday data model, security, integrations and data load capabilities)

• REST API development and management platforms, such as MuleSoft or Boomi (Mulesoft preferred)

• Knowledge of Kimball DW/BI methodology

• Knowledge of higher education or research environments

• Knowledge of the University of Washington’s data systems and processes

Working Environmental Conditions:

This position:

• Contributes in a collaborative teamwork environment

• Collaborates across diverse backgrounds, personalities, and disciplines in a shared space working environment through scheduled and ad hoc meetings focused on problem solving

• May be required to work in a hybrid environment, using remote and on-site workplaces

• While normally has a Monday-Friday Business Administration, or equivalent experience shift, will occasionally have responsibilities or emergent situations where work outside of standard business hours is required to ensure software deployments go smoothly, to respond to incidents, and/or to meet critical deadlines

• May be required to be on call

• Is an essential position and is required to report to work when UW suspends operations when needed

**Application Process:** The application process may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select “Apply to this position”. Once you begin an assessment, it must be completed at that time; if you do not complete the assessment, you will be prompted to do so the next time you access your “My Jobs” page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.

University of Washington is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to, among other things, race, religion, color, national origin, sexual orientation, gender identity, sex, age, protected veteran or disabled status, or genetic information.