Executive Director, Business Intelligence and Technology Solutions

Executive Director, Business Intelligence and Technology Solutions

The Executive Director of Business Intelligence and Technology Solutions is a seasoned senior hands-on professional who serves as the technology and analytics expert for Finance and Business Administration. The Executive Director receives general direction, priorities, identified control issues, business needs, and expected outcomes from the Senior Associate Vice President of Strategic Initiatives and Transformation.

The Executive Director independently designs, builds, implements, and maintains business intelligence, workflow-automation, internal-controls automation, and continuous controls monitoring solutions. The position develops dashboards, KPIs, scorecards, data models, automated reports, digital workflows, system validations, exception reports, alerts, low-code applications, and other technology solutions that improve efficiency, monitoring, internal controls, and decision-making.

The Executive Director works with functional owners to understand process details and business rules, and with Information Technology when enterprise integration, ERP configuration, cybersecurity review, or specialized development is required. The Executive Director drafts business and functional requirements, leads the functional evaluation and selection of software, develops acceptance criteria, and tests solutions before recommending acceptance. Functional leaders retain ownership of their operations, data, processes, controls, and corrective actions.

This is a working Executive Director position distinguished by its integration of business intelligence, technology solution development, business process automation, internal control automation, and continuous controls monitoring. The incumbent leverages extensive expertise to independently lead complex, cross-functional initiatives while personally designing, developing, implementing, and optimizing innovative solutions.

The position translates general business needs and identifies control issues into practical technology solutions and serves as the functional lead from requirements development through software evaluation, testing, and acceptance recommendation. The Executive Director may independently lead process-improvement initiatives when technology, automation, systems, data, or analytics are the primary enablers and support broader transformation initiatives by delivering the required technology component. The position does not replace the operational responsibilities of functional leaders, the enterprise technology responsibilities of Information Technology, the procurement and contracting responsibilities of authorized university offices, or the independent assurance responsibilities of Internal Audit.

Essential duties include developing and maintaining executive scorecards, leadership dashboards, operational dashboards, management reports, and analytical tools; developing cross-divisional KPIs and performance measures in partnership with executive leadership and functional owners; establishing and documenting KPI definitions, formulas, baselines, targets, thresholds, data sources, ownership, reporting frequency, and validation requirements; building dashboards, reports, scorecards, and data visualizations using Power BI or comparable business-intelligence tools;

developing and maintaining data models, calculations, queries, data transformations, and automated reporting processes; using SQL, DAX, Power Query, advanced Excel, or comparable tools to combine and analyze information from multiple systems; validating the accuracy, completeness, consistency, and timeliness of financial and operational data, reports, dashboards, and analytical products; reconciling dashboards and management reports to Banner, ERP data, the general ledger, payroll, procurement, budget, asset-management, and other authoritative source systems;

investigating conflicting results, duplicate or missing records, mapping issues, timing differences, unusual variances, and calculation errors; establishing data-quality controls, validation procedures, data dictionaries, source-to-report mappings, data lineage, and reporting standards; documenting data definitions, calculations, validation procedures, assumptions, limitations, and identified data-quality concerns; communicating material data quality or reporting concerns to the appropriate functional owners and leadership; eliciting, analyzing, drafting, validating, and maintaining business and functional requirements for assigned technology initiatives;

documenting current-state and future-state process flows, business rules, user needs, data requirements, reporting requirements, internal-control requirements, interfaces, security considerations, use cases, and acceptance criteria; preparing functional specifications, requirements documents, statements of work, procurement specifications, demonstration scripts, and vendor-evaluation criteria as assigned; conducting fit-gap and…