Business Intel Architect
Business Intel Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 decisionmaking. 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 CCOMs mission areas to analyze institutional workflows processes and data providing insights reporting and datadriven solutions that drive strategic decisionmaking 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 enterprisewide 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:
Bachelors 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:
Handson 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 datacentric 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 of14calendar days and may be removed from posting and filled any time after the original posting period has ended.
Successful candidates will be required to selfdisclose any conviction history and will be subject to a criminal background check and credential/education to 5 professional references will be requested at a later step in the recruitment process.
For additional questions please contact
Hybrid within Iowa:This position is eligible forhybridwork 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 theremote work program and related policiesandemployee travel policy when working at a remote location.
Employment Type
Full Time
