The University of Iowa is seeking a Business Intelligence (BI) Architect with proven experience providing BI solutions as well as experience with data modeling, data mart and Data Warehouse (DW) architecture. This individual will have an immediate impact enhancing our campus operational and strategic data informed decision-making. Through this role, you have the opportunity to provide insights that impact policy, practice and outcomes at the University of Iowa working in a team environment to design, develop, and deliver enterprise business intelligence and analytic solutions. Ideal candidates will have excellent technical and interpersonal skills as well as a strong commitment to supporting our values that include team focus, creative problem solving, and technical curiosity. You will have the opportunity to grow technically and professionally while working on an energetic and collaborative team. We provide a challenging work environment at a premier higher education institution. We offer an exceptional benefits package and many other support resources to help employees balance their professional and personal lives.
Responsibilities and Duties: • Participate in the BI project planning process to establish business requirements, define deliverables, conduct data analysis, and establish timelines; • Manage BI solutions throughout the project lifecycle (analysis, design, implementation, operational support); • Collaborate with key functional stakeholders to better understand their business domain, processes and data; • Develop visually informative dashboards and customized reports based on business requirements; • Work with data providers to architect, build, test, and maintain BI data infrastructure; • Design and implement ETL processes to create data pipelines and aggregate data from multiple sources; • Research new technologies and industry trends, and determine applicability to our campus environment; • Provide guidance and mentoring for the campus BI Community. Education Requirement: Bachelors' degree in Data Analytics, Computer Science, or related field, or an equivalent combination of education and related work experience. Required Qualifications: • Typically requires 5-7 years of experience developing business intelligence solutions. • Extensive knowledge of data warehousing/business intelligence best practices, methodologies, standards and architectures. • Experience with relational databases such as Oracle, MS SQL Server, or Cloud DBs • Working proficiency with BI technologies such as MS BI stack including SSIS, SSAS, SSRS or MS Power BI. • Working experience with data warehouse and data mart lifecycle stages; data modeling, database schema development, and ETL processes. • Proven track record of delivering BI solutions through the full development lifecycle including requirements gathering, design, development, analytics, implementation, monitoring and support. • Experience with contemporary BI Tools (Microsoft, Tableau, and Qlik). • Project management, facilitation, time management and organizational skills. • Ability to communicate effectively, both orally and in writing, with technical and non-technical staff • Highly developed problem solving, troubleshooting and analytical abilities. Desired Qualifications: • Working knowledge of cloud (AWS, Azure, GCP). • Data modeling and database schema experience. • Knowledge of industry trends including data mining, visualization and predictive modeling. • Experience with BI development best practices such as agile methodologies, source code control, issue tracking, prototyping, and testing. • Experience with R or other statistical programming languages. • Higher education industry knowledge or experience. • Working knowledge of cloud (AWS, Azure, GCP). • Knowledge of industry trends including data mining, visualization and predictive modeling. • Experience with BI development best practices such as agile methodologies, source code control, issue tracking, prototyping, and testing.
Additional Information: Please attach a cover letter and resume in the relevant submission specific attachments for this position using the application process. Job openings are posted for a minimum of 14 calendar days. This job may be removed from posting and filled any time after the minimum posting period has ended. Successful candidates will be subject to a criminal background check and credential verification. For questions or additional information, please contact Kim Kuebrich Yordi at email@example.com