Business Intel Architect
The UI Carver College of Medicine seeks a Business Intelligence Architect to join the CCOM IT Software Application Services team and transform data into actionable insights to support academic, administrative, healthcare, and research decision-making. This position will integrate into the existing Data Team, collaborating closely with the Data Lead, who oversees all data, databases, and data processes supporting CCOM application developers and foundational systems. The Business Intelligence Architect will engage stakeholders across CCOM’s mission areas to analyze institutional workflows, processes, and data, providing insights, reporting, and data-driven solutions that drive strategic decision-making and operational efficiency. This position is eligible for a hybrid work structure within Iowa with the majority of work taking place on the University of Iowa campus.
Percent Time: 100%
Primary duties to include:
Business Requirements and Analysis
Gather and analyze enterprise-wide user requirements for data models, architecture, and analytics.
Reporting and Visualization (front end)
Manage data integrity and quality strategy. Perform advanced data analysis techniques.
Work closely with the CCOM Office of Research to create, maintain, and advance reporting and visualization tools that quantify resources such as grants, space, and research core usage associated with the institution.
Work closely with CCOM Education groups to create, maintain, and advance reporting and visualization tools that quantify educational components such as curriculum elements, teaching effectiveness, learning objectives, and outcomes.
Work closely with CCOM Administration to create, maintain, and advance reporting and visualization tools that quantify data elements supporting Faculty
Focus on outcomes and data visualization.
Develop and support ETL processes.
Design and execute complex SQL queries, and deliver impactful reporting and visualization solutions.
Architecture (back end)
Architect, implement, maintain and support data tools, platforms and solutions.
Construct complex data pipelines to clean, transform, aggregate, and publish data.
Assess and recommend enterprise data platforms and tools.
Develop and implement external database integration strategies.
Statistical and Mathematical Modeling
Operationalize data analytics algorithms and infrastructure.
Perform data analytics based upon processes developed by others.
Leadership
Serve as technical lead/expert. Develop technology roadmaps.
Provide mentorship and coaching on data analytics and reporting to customers and organization.
May hire, develop, and manage the performance of staff; assure staff are compliant with UI policies and procedures.
May assist in budget development and provide projections and recommendations.
Assist in development, application and support of Institutional Data policies.
Assist in the management of the data governance (availability, usability, integrity and security of the data) used in the enterprise.
Strong collaboration and alignment with the existing team and Lead to ensure cohesive and effective data solutions.
EDUCATIONAL REQUIREMENTS:
Bachelor’s degree in Computer Science, Engineering, Information Science, or a related field, or an equivalent combination of education and relevant experience.
REQUIRED QUALIFICATIONS:
Proven expertise in relational database concepts and design, including data warehouse techniques.
Demonstrated experience developing and supporting:
- · Complex SQL queries.
- · ETL (Extract, Transform, Load) processes.
- · Data management and cleansing techniques.
Proficiency with business intelligence tools such as SQL Server Reporting Services (SSRS), Tableau, or Microsoft Power BI.
Strong familiarity and demonstrated experience working with research administration and grant data, including NIH grants.
Strong familiarity and demonstrated experience working with faculty data, especially research and publication data.
Experience visualizing data for academic, administrative, or healthcare use cases, with a focus on actionable insights.
Strong communication skills, with a demonstrated ability to explain complex technical concepts to various audiences.
Thorough understanding of institutional data policies and regulations, including FERPA and HIPAA, with proven experience ensuring compliance in data reporting and analytics.
DESIRABLE QUALIFICATIONS:
Hands-on experience in the technical development, support, and maintenance of data warehouses.
Proficiency with advanced Microsoft SQL Server tools, including:
- · SQL Server Integration Services (SSIS).
- · SQL Server Analysis Services (SSAS).
- · SQL Server Reporting Services (SSRS).
Advanced expertise in data visualization platforms.
Knowledge of statistical or mathematical modeling techniques for data analysis.
A track record of initiating and managing technology projects that improve organizational efficiency.
Experience in data governance, including ensuring the availability, usability, integrity, and security of enterprise data.
Demonstrate curiosity and a collaborative spirit, working with faculty and staff to provide innovative, data-centric solutions.
Position and Application details:
In order to be considered for an interview, applicants must upload the following documents and mark them as a “Relevant File” to the submission:
- Resume
- Cover Letter
Job openings are posted for a minimum of 14 calendar days and may be removed from posting and filled any time after the original posting period has ended.
Successful candidates will be required to self-disclose any conviction history and will be subject to a criminal background check and credential/education verification. Up to 5 professional references will be requested at a later step in the recruitment process.
For additional questions, please contact stacy-pruter@uiowa.edu
Hybrid within Iowa: This position is eligible for hybrid work within Iowa and will require a work arrangement form to be completed upon the start of your employment. Per policy, work arrangements will be reviewed annually, and must comply with the remote work program and related policies and employee travel policy when working at a remote location.
Equal opportunity/affirmative action employer
The University of Iowa is an equal opportunity/affirmative action employer. All qualified applicants are encouraged to apply and will receive consideration for employment free from discrimination on the basis of race, creed, color, religion, national origin, age, sex, pregnancy (including childbirth and related conditions), disability, genetic information, status as a U.S. veteran, service in the U.S. military, sexual orientation, gender identity, or associational preferences.
Persons with disabilities who need assistance or accommodations with the application or interview process may contact University Human Resources/Faculty and Staff Disability Services, (319) 335-2660 or fsds@uiowa.edu. For jobs in UI Health care, please contact UI Health care Leave & Disability Administration at 319-356-7543.
