IT Business Systems Analyst - Data & Reporting

Job Summary

Infrastructure and Resilience IT (I&R IT) invites applications for an IT Business Systems Analyst
! This department provides a broad range of services in support of department programs and Boulder campus‑wide infrastructure and facilities. The group is responsible for systems and applications ranging from traditional Enterprise Applications and Information Technology (IT), to Operational Technology (OT) and Industrial Control Systems (ICS) such as Building Automation Systems (BAS), Supervisory Control and Data Acquisition (SCADA), and associated server, virtualization, networking, cybersecurity, backup, and data storage environments.

I&R IT includes the following work units:
Enterprise Systems, System Administration, and Client Representatives.

The I&R Office is responsible for long‑range capital planning, architecture, design and construction, the operation and maintenance of all campus facilities and utilities, transportation services, workplace accident prevention, environmental health and safety, campus logistics, and sustainability and resiliency. The department is embarking on projects that are key to the strategic vision of the campus, including developing a comprehensive framework for campus master planning, improving sustainability and resiliency, and collaborating with community partners.

• Provide daily application support for enterprise systems (e.g., Asset Works AiM, Oracle Unifier, Meridian), including service requests, user access, issue resolution, and general system support.
• Solve system and data‑related issues, including data quality concerns, reporting discrepancies, and system‑data alignment.
• Support application updates, testing, validation, and implementation activities to ensure continuity of operations.
• Assist with access requests, security roles, and user provisioning in accordance with established processes and policies.
• Work within ticketing and request tracking systems to manage workload and ensure requests are documented, prioritized, and resolved in alignment with team processes.
• Coordinate with technical staff, vendors, and collaborators to support system changes, upgrades, outages, and issue resolution.
• Provide backup support for enterprise systems functions, ensuring continuity of service.
• Document application configurations, support procedures, and system dependencies.

• Support operational and application needs through development of reporting and data solutions.
• Design, develop, and maintain Power BI reports and dashboards supporting operational and business needs.
• Write and optimize SQL queries to extract, transform, and analyze data from Oracle, MySQL, and related systems.
• Develop and maintain datasets, data models, and reporting structures to support ongoing analytics and reporting needs.
• Assist in building and maintaining data pipelines and ETL processes supporting reporting and data integration.
• Collaborate with partners to capture reporting requirements and deliver effective BI solutions.
• Ensure data accuracy, consistency, and proper use of data in reporting outputs.

• Provide end‑user support and training related to enterprise systems and BI reporting (AiM, Unifier, Power BI) under the direction of Enterprise Systems team members.
• Develop and maintain user documentation and training materials supporting system usage and reporting.

• Support implementation and maintenance of application and data security controls in coordination with Enterprise Systems staff and campus security resources.
• Assist with maintaining user roles, permissions, and access controls across enterprise systems.
• Participate in ongoing assessment of data security and access practices.
• Ensure systems maintain security in line with campus security policies and procedures.

• Assist in documenting and maintaining procedures related to enterprise systems, data flows, and reporting.
• Ensure assigned work follows campus standards, policies, and applicable regulations.
• Maintain technical and functional…