Hybrid Data Architect for Analytics & Reporting

Utah; Salt Lake City, Northern (UT, KY); Hybrid; USD 80,000 - 130,000; Full time

Benefits offered by this job

Benefits package

Job summary

The University of Utah's University Analytics & Institutional Reporting (UAIR) office houses a transformational team of data professionals who turn complex university data into meaningful information trusted by leadership for strategic decisions.

We seek an experienced data architect to design, build, test, and maintain data transformation pipelines, data models, and reporting structures, with a hybrid work arrangement requiring residence in Utah and on-campus presence three days per week.

Qualifications

• Bachelor’s degree and 6 years of experience in institutional research, business analytics, data science or related field.
• Proficiency in querying, manipulating and analyzing complex datasets.
• Excellent interpersonal and communication skills and the ability to present complex data to both technical and non-technical audiences.
• Demonstrated experience with data visualization tools such as Tableau, Microsoft Power Bi, etc.
• Experience with data querying languages such as SQL
• Proficiency in python coding
• Experience working with API’s
• Demonstrated ability to manage multiple projects and work collaboratively across teams

Responsibilities

• Research source data structures, relationships, content and quality. Support requirements discovery.
• Design, build, implement, and maintain data transformation pipelines, processes and reporting structures formatted to support data science, strategic reporting, master data sources, enterprise integrations, point-in-time snapshots and more
• Help automate and manage data quality audits and correction processes
• Write complex SQL queries to support analytics needs
• Develop and maintain data and process documentation, including data flow diagrams, data concepts, keys, definitions, process steps, etc.
• Share your ideas and knowledge, be open to learning from others, and grow with the team as we explore new ideas, methods and tools in our journey of continuous forward progress
• Other duties as assigned

Skills

SQL

Python

Tableau

Power BI

Data Visualization

Data Analysis

Communication

APIs

Project Management

Education

Bachelor’s degree

Master’s degree

Tools

Tableau

Power BI

AWS Glue

Airflow

PeopleSoft

Job description

The University of Utah's University Analytics & Institutional Reporting (UAIR) office houses a transformational team of data professionals who turn complex university data into meaningful information trusted by leadership for strategic decisions.

We seek an experienced data architect to design, build, test, and maintain data transformation pipelines, data models, and reporting structures, with a hybrid work arrangement requiring residence in Utah and on-campus presence three days per week.