Role Description 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. 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. Responsibilities - Power BI Architecture and Governance - 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. - Define and enforce governance policies around certified content, data source connections, gateway configuration, and dataset refresh schedules. - Manage and optimize Microsoft Fabric capacities, proactively monitoring utilization, workload distribution, and scaling requirements to support performance and growth. - Establish repeatable processes for app deployment, workspace lifecycle management, version control, and metadata publishing to support both central IT teams and decentralized report developers. - 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. - Enterprise Semantic Model Architecture - Design and implement robust, enterprise-grade semantic models using Power BI and Fabric, focusing on reusability, scalability, and alignment with business domains. - 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. - Proactively monitor semantic model usage, performance metrics, and user feedback to identify opportunities for optimization and simplification. - 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. - 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. - Performance, Security, and Compliance - Continuously monitor platform health and report performance; diagnose and resolve performance bottlenecks related to inefficient DAX, excessive query load, or capacity overuse. - Supports audits and data governance initiatives by maintaining accurate data lineage and metadata documentation. - Ensure semantic models align with institutional definitions and enterprise data standards. - 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. Qualifications - Bachelor's degree in Computer Science, MIS, or related discipline or an equivalent combination of education and relevant experience. - Typically, 5-7 years of experience in business intelligence, data architecture, or enterprise analytics roles. - Extensive hands-on experience with Power BI (desktop, service, semantic models, and DAX). - Strong knowledge of healthcare data, including clinical, financial, and operational domains. - Advanced SQL skills with the ability to write complex queries and optimize for performance. - Strong proficiency in SQL, DAX, Power Query (M), and building and tuning semantic models. - Excellent written and verbal communication skills. Desired Qualifications - Experience in managing or migrating large-scale BI ecosystems from Tableau or legacy reporting tools. - 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. - 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. - Experience leveraging Power BI REST APIs, PowerShell, and Python to automate administrative tasks, streamline deployments, and enhance data workflows within the Power BI ecosystem. Salary and Benefits - Pay Grade: 5B - Salary: $68,678 to commensurate - Generous benefits package, including 24 days paid vacation per year to start and paid sick leave. Application Process To be considered, applicants must upload a resume 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 7 calendar days. This job may be removed from posting and filled any time after the minimum 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. This position is not eligible for University sponsorship for employment authorization. Contact Information For additional questions contact Kristen Kordick at Kristen-Kordick@uiowa.edu

• Build and own package-level unit economics data models that surface margin contribution, breakage rates, cost dynamics, and profitability across markets, corridors, and packages • Develop the analytical scaffolding for structured pricing reviews: margin waterfalls, competitive positioning dashboards, demand signal reporting, and conversion sensitivity analysis • Integrate competitive pricing data (scraped and third-party) into structured, queryable models that power automated benchmarking and price distance analysis across priority markets • Build and codify the data inputs that power our pricing decision framework—elasticity indicators, corridor-level competitive intensity, segment performance—enabling structured trade-offs between growth, margin protection, and competitive response • Own the semantic layer and metrics definitions for pricing and commercial domains, ensuring consistency and trust across Lightdash, downstream tools, and self-service analytics • Write Python-based tooling that goes beyond transformation: simulation models, scenario analyses, pricing rule engines, and automated competitive monitoring scripts • Design measurement-ready datasets that support A/B testing, controlled pricing pilots, and experimentation infrastructure as we build our capabilities for predictive pricing • Collaborate with data engineers to scale ELT workflows and improve CDR digestion pipelines, ensuring freshness, reliability, and full coverage for pricing-critical reporting • Partner with the Commercial Pricing Lead, Networks, Finance, and Growth to translate pricing strategy into data products, and ensure cross-functional stakeholders can independently explore and act on the models you build • Implement robust testing, documentation, and monitoring—you’re the steward of data quality in a domain where bad data means bad pricing decisions at scale

Role Description We are looking for an experienced Snowflake Data Engineer with strong expertise in data warehousing, data pipelines, and cloud-based data platforms. The candidate should have hands-on experience in Snowflake, SQL, ETL/ELT development, and cloud environments such as AWS/Azure. The role involves designing scalable data pipelines, optimizing Snowflake workloads, and enabling analytics solutions. - Design, develop, and maintain data pipelines and ETL/ELT processes using Snowflake. - Build and optimize data models and data warehouses in Snowflake. - Develop efficient SQL queries, stored procedures, and transformations. - Implement data ingestion pipelines from multiple sources such as APIs, databases, and files. - Work with cloud platforms (AWS/Azure/GCP) for data integration and storage. - Optimize Snowflake performance, clustering, and query tuning. - Implement data security, role-based access control (RBAC), and governance in Snowflake. - Collaborate with data analysts, BI teams, and business stakeholders to support reporting and analytics. - Ensure data quality, monitoring, and pipeline reliability. - Follow best practices for data architecture, version control, and CI/CD. Qualifications - Strong experience in Snowflake Data Warehouse. - Expertise in SQL and query optimization. - Hands-on experience with ETL/ELT tools such as Informatica, DBT, Matillion, Talend, Azure Data Factory. - Experience in data modeling (Star Schema, Snowflake Schema, Dimensional Modeling). - Knowledge of data ingestion techniques (Batch & Streaming). - Experience with cloud platforms (AWS, Azure, or GCP). - Familiarity with Python or scripting for automation. - Experience with Git, CI/CD pipelines, and DevOps practices. Preferred Skills - Experience with Snowflake features: Snowpipe, Streams & Tasks, Time Travel, Data Sharing. - Knowledge of data lake architectures. - Experience with BI tools such as Power BI, Tableau, or Looker. - Understanding of data governance and data quality frameworks. Education - Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Engineering, or related field.

We are looking for an experienced Snowflake Architect to lead the design and evolution of scalable, secure, and business-aligned data platforms and architectures that enable data-driven decision-making across the organization. Responsibilities: - Develop and maintain the data & analytic architecture strategy, reference architecture, and roadmaps, aligning data architecture with the overall business strategy and objectives. Conduct data capability assessments and build maturity improvement roadmaps. - Ensure data architecture aligns with data governance policies, standards, and regulatory requirements, while implementing data security and secure access controls. - Own the Data Platform architecture, ensuring its scalability, security, and cost-effectiveness. - To build a data-driven organisation, ensure proper service model architecture to streamline demand fulfilment and incident management. - Design and implement efficient data pipelines, leveraging vital platform components, with industry standards and best practices. - Engage with and influence senior stakeholders to drive data-led operations, translating business needs into technical requirements. - Evaluate and recommend tools, technologies, and frameworks that enhance data architecture capabilities. - Work closely with cross-functional teams to define technical requirements and project scope that align with product goals and business objectives. - Implement automated code review mechanisms to enhance development efficiency and maintain high-quality standards. - Provide technical leadership and mentoring to data engineers, developers, and analysts while leading and developing architecture teams. Guide data teams, conduct knowledge-sharing sessions, and stay updated with emerging data technologies. - Leverage TOGAF’s four architecture domains (Business, Data, Application, and Technology) to design and optimize enterprise-wide data solutions. Requirements: - Proven track record in establishing modernise data platform from ground up. - Expertise in any of the cloud-based data platform SnowFlake, Azure, Power BI, and dev-ops. Clear understanding and implementation capability of Enterprise Architecture Framework like TOGAF or similar. - Hands-on experience in data modelling, data lakes, data warehousing, and ETL pipelines. Experience in performance management dashboards, complexity estimation frameworks, and optimization techniques. - Ability to effective communication with senior leadership (CXOs, Data Heads, Other business heads) and drive enterprise-wide data initiatives. TOGAF certification (preferred) or equivalent experience in enterprise architecture methodologies. What we offer: - Comfortable environment, challenging tasks and a long-term interesting project; - Working with top notch equipment; - Bookkeeping by a professional accountant; - Help and support from our caring HR-team;