• Gather and analyze data from several databases and other sources to perform analyses and build reporting solutions to support our internal stakeholders • Code, build and maintain complex reporting solutions using MS SQL, Power BI, and other reporting tools • Collaborate directly with university stakeholders to gather business requirements, interpret metrics, and deliver iterative analyses in response to ad-hoc needs • Advise and assist partners in determining the appropriate analytical methodologies to address business questions/problems/objectives • Create and present executive-level visualizations and analyses to business partners, collaborating to interpret results and deliver clear, actionable recommendations that incorporate stakeholder feedback • Translate complex technical concepts for non-technical audiences • Design and assist with implementation of process improvement initiatives • Collaborate with other Analysts, Analytics Engineers and our Data Warehouse team, to ensure consistency of reporting, minimize duplication of effort, and identify/rectify limitations in data sources • Contribute to the evolving use and exploration of AI-enabled tools within our Analytics team • Actively participate in data governance initiatives

• Development and maintenance of dashboards in Power BI and performing deep analytics in Excel (OLAP cubes). • Writing advanced DAX measures. • Enhancing the analytical data warehouse (DWH). • Designing data models for BI needs, creating new business entities not present in source systems, and performing gradual refactoring of legacy structures. • Developing complex ETL processes in Python (API integrations, parsing, custom scripts). • Maintaining pipelines in Apache Airflow. • Analyzing, reverse-engineering, and optimizing existing data structures. • Writing complex SQL queries (PostgreSQL, MariaDB) and analyzing T-SQL to understand the structure of MS SQL–based systems. • Configuring and supporting automations in Power Automate (e.g., auto-refreshing Excel reports, Outlook email flows). • Ensuring data consistency, identifying metric discrepancies across CRM databases, and resolving anomalies. • Collaborating with stakeholders to translate business requirements into technical BI solutions.

• Advise clients on enterprise-wide Power BI architecture and governance frameworks • Define best practices for workspace structure, security, dataset management, and deployment pipelines • Design scalable BI operating models for large organizations • Drive initiatives demonstrating Copilot’s natural language query capabilities within Power BI environments • Identify use cases that highlight business value through AI-powered analytics • Architect and design enterprise semantic layers and reusable datasets • Implement best practices for data modeling, performance optimization, and DAX design • Leverage Microsoft Fabric capabilities to enable modern data and analytics solutions • Ensure solutions align with enterprise data strategy and governance standards • Lead stakeholder discussions and workshops • Translate business requirements into scalable BI solutions • Provide executive-level recommendations and technical roadmaps • Act as a trusted advisor for BI transformation initiatives

• You will own the full data lifecycle: from extraction and cleaning, through transformation and modeling, to compelling dashboards that surface the insights leaders actually act on. • You'll also layer in automation and AI where they make the data smarter, fresher, and less dependent on manual effort. • Your job is to take fragmented, messy data, spread across disconnected tools and systems, and turn it into a single source of operational truth. • You're embedded in multiple client engagements at a time, owning the data function end-to-end. • You'll identify what data matters, figure out how to get it, clean and structure it, and deliver dashboards and insights that give decision-makers a clear picture of what's happening in their business and what to do about it. • You're not just a report-builder; you're a strategic data partner who can take a business problem, trace it back to the data, and come back with something that changes how leadership operates.