Job Details

IT Business Systems Analyst - Data & Reporting

Position Number: 7267146
Location: Boulder, CO
Position Type: Computing - Database Administration

IT Business Systems Analyst - Data & Reporting

Requisition Number: 73041
Location: Boulder Colorado
Employment Type: University Staff
Schedule: Full Time
Posting Close Date: 30-Jun-2026
Date Posted:

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), along with the 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 Enterprise Systems work unit within I&R IT services include design, configuration, and implementation of new systems; consultation with users to identify appropriate solutions; and ongoing maintenance, administration of enterprise-class business applications (AssetWorks AiM, Go, ReADY, Oracle Unifier, Meridian) used in the daily operations of I&R, Facilities Management, and Design & Construction groups within I&R. The department is also responsible for database administration (Oracle, Microsoft SQL, MySQL, PostgreSQL) of databases and data warehouses serving the department and its systems, including automation, data feeds, and Business Intelligence (BI) and reporting.

This role is an individual contributor within the Enterprise Systems work unit, responsible for supporting the day-to-day operation of enterprise business applications and delivering data and reporting solutions supporting Facilities Management and Capital Projects operations, including troubleshooting, configuration, and vendor coordination. This role implements and takes ownership of assigned application support, operational, and data-related work, including user support, system coordination, issue resolution, and development of Power BI reporting and data analysis solutions. The position is a key contributor for both system support and data-driven decision-making, ensuring enterprise systems are effectively used and reporting and analytics needs are met in a reliable and maintainable way. Data and reporting responsibilities are closely aligned with operational and application support priorities. This role includes hands-on operational work (tickets, user requests, issue resolution).
CU is an Equal Opportunity Employer and complies with all applicable federal, state, and local laws governing nondiscrimination in employment. We are committed to creating a workplace where all individuals are treated with respect and dignity, and we encourage individuals from all backgrounds to apply, including protected veterans and individuals with disabilities.

Who We Are

The I&R Office areas of responsibility include long-range capital planning, architecture, design and construction, the operation and maintenance of all campus facilities and utilities, transportation services, workplace accident prevention and the creation of a safe working environment for campus employees, environmental health and safety, campus logistics, and efforts around sustainability and resiliency. Beyond creating a safe and secure environment, the department is embarking on several projects that are key to the strategic vision of the campus including: crafting a clear and comprehensive framework and methodology for campus master planning, developing strategies and tactics to improve campus sustainability and resiliency, and dynamically working within the campus and with our community partners to positively impact humanity.

What Your Key Responsibilities Will Be

Enterprise Application Support & Operations

Provide daily application support for enterprise systems (e.g., AssetWorks 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.

Business Intelligence & Data Development

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.

Training and User Support

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.

Security Management

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.

Policy Compliance & Documentation

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 documentation including data mappings, report definitions, and operational procedures.

What You Should Know

This is a primarily in-person position. Limited hybrid work may be available after onboarding, but is not guaranteed. This role has an anticipated work schedule of Monday - Friday during regular business hours.
Due to budgetary constraints, we are unable to offer visa sponsorship at this time.

What We Can Offer

The salary range for this position is $82,000 - $90,000 annually.

Benefits

At the University of Colorado Boulder, we are committed to supporting the holistic health and well-being of our employees. Our comprehensive benefits package includes medical, dental, and retirement plans; generous paid time off; tuition assistance for you and your dependents; and an ECO Pass for local transit. As one of Boulder County's largest employers, CU Boulder offers an inspiring academic community and access to world-class outdoor recreation. Explore additional perks and programs through the CU Advantage program.

Be Statements

Be engaged. Be unique. Be Boulder.

What We Require

Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.
3 years of experience supporting enterprise applications or systems in a professional IT environment.
Experience developing BI/reporting solutions using Power BI (DAX, Power Query, report formatting), or equivalent tools.
Demonstrated experience writing and optimizing complex SQL queries (joins, aggregations, sub-queries) against production relational databases (Oracle, MySQL, or similar).
Experience working with data from enterprise, or operational systems (e.g., ERP, EAM, or similar).
Experience working in a complex, multi-system environment with competing priorities and operational support responsibilities.

What You Will Need

Proficiency in data visualization tools (e.g., Power BI, Tableau) and querying databases with SQL.
Proficient in PL/SQL for Oracle, and advanced SQL for MySQL.
Proficient in scripting languages like Python, or JavaScript for automation.
Proficiency in SQL for creating queries, stored procedures, and database management.
Knowledge of data warehousing and ETL processes.
Familiarity with Oracle, AWS, SQL or other cloud-based databases.
Familiarity with Microsoft tools like Excel.
Ability to communicate complex data insights in a clear and actionable way.
Superb communication skills for collaboration across technical and non-technical teams.
Excellent problem-solving skills to fix data and application issues.
Thorough approach, ensuring data accuracy and quality with a focus on delivering high-quality visualizations.

Special Instructions

To apply, please submit the following materials:

A current resume.
Cover Letter: In 1-2 paragraphs, please briefly describe your interest in this role and why it fits your experience. Please include the following:

Your experience supporting specific enterprise or operational systems (not just reporting or analytics)
Your comfort with hands-on support work (user requests, troubleshooting, system operations)

System Support Experience Write-Up: Please describe a system or application you have hands-on support experience with. Please be specific - generic or high-level responses will not be considered competitive. Please include the following:

The name and purpose of the system
The types of work you personally performed (e.g., user support, configuration, troubleshooting, reporting, integrations)
A specific issue you encountered and how you resolved it
Your level of responsibility (independent, team-based, vendor-supported, etc.)
How you worked with users, stakeholders, or vendors to understand the issue, communicate status, and implement a solution

We may request references at a later time.

Please apply by June 30, 2026 for consideration.

Note: Application materials will not be accepted via email. For consideration, please apply through CU Boulder Jobs.

In compliance with the Colorado Job Application Fairness Act, in any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information.

To apply, visit https://jobs.colorado.edu/jobs/JobDetail/IT-Business-Systems-Analyst-Data-Reporting/73041