<p>The University of Iowa Health Care Information Systems has a great opportunity to join our team as a Business Intelligence Analyst! The Business Intelligence (BI) Architect is responsible for designing and delivering analytics content that supports clinical, financial, operational, and administrative reporting needs. The BI Architect partners with data engineering, analytics, application owners, and business stakeholders to ensure the delivery of scalable, secure, and high-performing analytics solutions in Power BI that align with organizational goals and compliance requirements.</p> <p>This position is eligible for remote 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.</p> <p>Power BI Architecture and Governance:</p> <ul> <li>Architect and maintain the enterprise-wide Power BI environment, including scalable workspace structures, standardized naming conventions, and robust deployment pipelines to support agile report delivery and ongoing development. </li><li>Define and enforce governance policies around certified content, data source connections, gateway configuration, and dataset refresh schedules. </li><li>Manage and optimize Microsoft Fabric capacities, proactively monitoring utilization, workload distribution, and scaling requirements to support performance and growth. </li><li>Establish repeatable processes for app deployment, workspace lifecycle management, version control, and metadata publishing to support both central IT teams and decentralized report developers. </li><li>Drive adoption of modern Power BI and Fabric features by aligning architectural decisions with the enterprise analytics strategy and Microsoft's roadmap, including integration with Direct Lake, OneLake, and Real-Time Intelligence. </li></ul> <p>Enterprise Semantics Model Architecture:</p> <ul> <li>Design and implement robust, enterprise-grade semantic models using Power BI and Fabric, focusing on reusability, scalability, and alignment with business domains. </li><li>Define and uphold modeling standards related to naming conventions, folder organization, measure logic (DAX), and data categorization to ensure consistency and ease of use across development teams. </li><li>Proactively monitor semantic model usage, performance metrics, and user feedback to identify opportunities for optimization and simplification. </li><li>Collaborate with Data Engineering teams to ensure that dataflows, lakehouses, and data warehouse objects are structured and maintained in ways that support performant semantic modeling. </li><li>Establish enterprise-wide semantic modeling strategies that promote certified datasets, shared dimensions, and efficient connection types (e.g., Direct Lake, Import, Hybrid), based on business use case, performance needs, and data latency requirements. </li></ul> <p>Performance, Security, and Compliance:</p> <ul> <li>Continuously monitor platform health and report performance; diagnose and resolve performance bottlenecks related to inefficient DAX, excessive query load, or capacity overuse. </li><li>Supports audits and data governance initiatives by maintaining accurate data lineage and metadata documentation. </li><li>Ensure semantic models align with institutional definitions and enterprise data standards. </li><li>Contribute to the development and enforcement of row-level security, workspace access roles, and least-privilege access models to protect sensitive data while enabling appropriate self-service reporting. </li></ul> <p>Health Care Information Systems (HCIS) provides and supports information and communication systems and technology that facilitate quality patient care, progressive medical education, and innovative research.</p> <p>HCIS services University of Iowa Health Care by providing comprehensive, high-level support for patient care delivery, internal and external communication, technology innovation, medical education, and research. Creating and maintaining a positive, productive, and rewarding environment for information technology and communication staff</p> <ul> <li>Pay Grade: 5B - https://hr.uiowa.edu/pay/pay-plans/professional-and-scientific-pay-structure </li><li>Salary: $82,073.00 </li><li>University of Iowa offers a generous benefits package, including 24 days paid vacation per year to start and paid sick leave. Complete information regarding the full benefits package may be viewed at https://hr.uiowa.edu/benefits </li><li>Percent of Time: 100% </li><li>Location: Remote </li><li>Staff Type: Professional & Scientific </li><li>Type of Position: Regular </li></ul> <p>Education Required</p> <ul> <li>Bachelor's degree or equivalent amount of education and experience </li></ul> <p>Required Qualifications</p> <ul> <li>Typically, 5-7 years of experience in business intelligence, data architecture, or enterprise analytics roles </li><li>Extensive hands-on experience with Power BI (desktop, service, semantic models, and DAX) </li><li>Strong knowledge of healthcare data, including clinical, financial, and operational domains </li><li>Advanced SQL skills with the ability to write complex queries and optimize for performance. </li><li>Strong proficiency in SQL, DAX, Power Query (M), and building and tuning semantic models </li><li>Excellent written and verbal communication skills </li></ul> <p>Desirable Qualifications:</p> <ul> <li>Experience in managing or migrating large-scale BI ecosystems from Tableau or legacy reporting tools </li><li>Experience with Power BI DevOps practices, including the use of deployment pipelines, workspace lifecycle management, and version control to support scalable and maintainable BI solutions. </li><li>Hands-on experience with Power BI optimization tools such as DAX Studio and Measure Killer, with the ability to diagnose and resolve performance issues in complex semantic models. </li><li>Experience leveraging Power BI REST APIs, PowerShell, and Python to automate administrative tasks, streamline deployments, and enhance data workflows within the Power BI ecosystem. </li></ul> <p>To be considered, applicants must upload a resume (under submission relevant materials) that clearly addresses how they meet the listed required and desired qualifications of this position. A cover letter is desired as part of 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.</p> <p>Successful candidates will be required to self-disclose any conviction history and will be subject to a criminal background check and credential/education verification.</p> <p>This position is not eligible for University sponsorship for employment authorization.</p> <p>For additional questions contact Kirsten Kordick - kirsten-kordick@uiowa.edu</p> <p>Additional Information</p> <ul> <li>Classification Title: Business Intel Architect </li><li>Appointment Type: Professional and Scientific </li><li>Schedule: Full-time </li><li>Work Modality Options: Remote within Iowa </li></ul> <p>Compensation</p> <ul> <li>Pay Level: 5B </li><li>Starting Salary Minimum: 82,073.00 </li></ul> <p>Contact Information</p> <ul> <li>Organization: Healthcare </li><li>Contact Name: Kirsten Kordick </li><li>Contact Email: kirsten-kordick@uiowa.edu </li></ul>