LEAD DATA ARCHITECT AND REPORT DEVELOPER

LEAD DATA ARCHITECT AND REPORT DEVELOPER

Req #:220521
Department:UW BOTHELL
Job Location: Bothell Campus
Posting Date:04/26/2023
Closing Info: Open Until Filled
Salary:$8,332 - $8,795 per month
Other Compensation:
Shift:First Shift
Benefits: 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.


The UW-Bothell Institutional Research Office (IR) provides information services that support campus decision-making, planning, and policy formation. IR is responsible for enrollment and admissions projections, providing information for grant development and budget modeling, data management, data and process documentation, data governance, periodic student data reports, campus-wide survey development, and program evaluation/assessment. During the next two-to-three years, IR will focus a significant amount of our resources on research and reporting that informs UW-Bothell’s strategic enrollment plan and remediating existing reports and data models that support budget planning, owing to upcoming changes to our financial and HR data systems.

Reporting to the Director of IR, the Lead Data Architect and Report Developer will play a central role in moving our campus away from ad hoc reports and manual data manipulation towards standard data models and dashboards that address information needs across the Bothell campus. The person in this role will lead and manage projects that leverage existing data sources and aid the Director of IR in determining when new data models or reports need to be developed to meet stakeholder information needs. The person in this role will also be responsible for the delivery of other data solution artifacts, including: business process diagrams; conceptual and physical data models; ETL Documentation; Standard Operating Procedures; Lineage; Data Definitions; other relevant metadata. This position will have high impact on the University. It will be central to ensuring that accurate, usable data and reports will be available to support administrative staff and campus leadership in their planning efforts across the University. In addition, it will assist IR team members in their compliance with federal and state assessment requirements, as well as other services that IR supplies to a variety of both internal and external audiences.

DUTIES AND RESPONSIBILITIES

Design and deliver data models and reports that support UWB’s short and long-term information and reporting needs:

• Facilitate discussion sessions to identify data and reporting requirements with IR, campus stakeholders and other Subject Matter Experts (SME) from across the University that can provide insight and background on relevant data sources
  
• Provide recommendations and implement solutions to improve and automate Business Intelligence tools, ensure data quality, and model data for advanced econometric analyses.
  
• Development of Extract Transform and Load (ETL) jobs to transform data from multiple platforms utilizing automation and eliminating as much manual data manipulation as possible.
  
• Create and deliver artifacts including but not limited to: business work flow diagrams, concept and physical data models, Database Design/ETL Documentation, Standard Operating Procedures for keeping every OIR data source up-to-date, Column and Table Definitions, Lineage and Source to Target mappings
  
• Collaborate with IR and UW-Seattle's Data Architecture and Institutional Data and Analysis teams to validate and review their data solutions, refine their scripts, and provide helpful feedback to validate and optimize ETL processes and resulting data output.
  
• Oversee or manage projects for small cross-functional teams that automate BI Reports, dashboards/visualizations, data quality reports, and ad hoc requests that meet shorter-term needs of campus leadership.
  
• For recurring, periodic reports, this duty will also require replacing manual processes and reports with stored procedures, SSIS packages, SQL Server Agent Jobs and data dashboards.
  
• Work collaboratively with other SMEs across the University who develop and maintain metadata repositories in the Academic, HR, and finance data domains; identify opportunities for improvement and assess new technology and concepts that can add value to the University’s information resources.
  
• Serve as a resource to the EDW and Metadata Teams at UW-Seattle if/when IR’s data solutions get adopted and promoted to the enterprise level.
  
• Perform other duties as assigned.
  
  MINIMUM REQUIREMENTS
  
  
• Bachelor's Degree in management information systems, data analytics, or other information technology related field.
  
• Minimum of four years combined experience leading or managing the design, development, and implementation of data architecture or Business Intelligence (BI) solutions is required.
  
  Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.
  
  ADDITIONAL REQUIREMENTS
  
  
• Intermediate to advanced knowledge of project management best practices
  
• Advanced proficiency in SQL.
  
• Advanced knowledge of data structures and ability to effectively query and transform data.
  
• Demonstrated ability to conceptualize and design data models used for reporting, statistical modelling and ad hoc requests.
  
• Demonstrated ability to communicate data architecture or BI solutions to both stakeholders and IT partners, providing translation between them in both technical and non-technical language.
  
• Demonstrated ability to diagnose and correct data quality issues.
  
• Advanced problem-solving skills.
  
• Good oral and written communication skills.
  
• Proficiency in Microsoft Office, particularly Microsoft Excel.
  
  DESIRED QUALIFICATIONS
  
  
• Project Management experience or abilities.
  
• Visio/Erwin (or other visual tool for producing conceptual models and process flows).
  
• Proficiency with Data Visualization and Reporting Platforms, particularly Tableau and Microsoft SSRS.
  
• Proficiency with statistical programming, or machine learning platforms (R, Python, SAS, SPSS, STATA).
  
• Experience working in a Higher Education context.
  
• Knowledge of data governance and metadata management best practices.
  
  CONDITIONS OF EMPLOYMENT
  
  
• Office space is configured as an open-cubicle environment. Hybrid and fully remote options are also available in consultation with the IR Director and campus leadership.
  
• Responsibilities of the position may require the ability to work additional hours to accomplish assignments, to deliver materials in response to externally imposed deadlines, and to troubleshoot problems encountered by or otherwise confer with internal and external customers.
  
  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.
  
  Priority consideration will be given to applications received by 6/9/2023


Committed to attracting and retaining a diverse staff, the University of Washington will honor your experiences, perspectives and unique identity. Together, our community strives to create and maintain working and learning environments that are inclusive, equitable and welcoming.

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

To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or dso@uw.edu .

Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law .