Jobs UNIVERSITY OF COLORADO BOULDER

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.

Enterprise Applications Support and Reporting

• Design, develop and maintain business intelligence solutions using Power BI.
• Collaborate with partners to understand data needs and deliver actionable insights.
• Support enterprise business applications, resolving issues, and planning and testing implementation updates.
• Develop and maintain interactive dashboards and reports using Power BI to visualize key business data and metrics.
• Write and optimize advanced SQL queries to extract, transform, and load data from various sources into databases or reporting tools.
• Use SQL to extract, transform, and analyze data from Oracle and MySQL sources for business reporting.
• Develop and maintain integrations and optimizations between business applications (e.g., CRMs, ERPs) to streamline workflows and enhance productivity.
• Develop and maintain integrations using ETL pipelines and automate data flows between systems, using Oracle SQL tools and MySQL frameworks.
• Standard report generation and maintenance using application (BIRT) and BI (Power BI) tools connecting to Oracle and MySQL databases.
• Ensure data accuracy, consistency, and security while adhering to campus and industry standards.
• Diagnose and resolve application/database-related issues, ensuring data integrity while minimizing downtime.
• Participate in formal and informal training and conference sessions to improve technical knowledge and skills.

Training and Support

• Working with Enterprise Systems staff, providing guidance and support related to the Enterprise Systems (AiM, Unifier, Power BI reporting).
• Train business application and BI reporting users as needed, including hands-on training and explanations of procedures and concepts necessary to properly use the applications.

Security Management

• Working with staff, campus, and vendor security experts, continuously analyze and implement appropriate security measures to protect enterprise applications and data.
• Collaborate with staff to maintain application security access roles and privileges based on need to access specific modules and functions of the applications.
• Work with staff on continuously assessing security risks and access controls.
• Working with campus, staff, and industry standards, stay abreast of potential security threats and vulnerabilities coordinating with colleagues to make appropriate changes as needed.

Policy Compliance Development

• Collaborate with others to document and maintain standardized policies and procedures related to the Enterprise Systems operations.
• Ensure compliance with relevant campus and industry regulations and standards.

Application Document Creation

• Create and maintain existing and new documentation to support applications and application maintenance work, including ETL source to target mappings, design, data flow diagrams, narratives, code review logs, validation results, execution logs, and profiling results.
• Create other training documentation related to BI reporting, system maintenance, and business applications.

• Due to budgetary constraints, we are unable to offer visa sponsorship at this time.
• This position is expected to work in a hybrid work format, with 2 days required to be in-person per week. This role works an anticipated schedule of Monday - Friday during regular business hours.

The salary range for this role is $80,376 - $90,448 annually.

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field OR equivalent combination of education and experience may substitute.
• 3 years working with data analysis, BI tools (Power BI and SQL) in a professional environment.

• Ability to build partnerships across campus and collaborate well with people of varying technical knowledge.
• Good communication skills, both orally and written.
• Ability to be personable and have strong social skills.
• Able to a lead other team members and help them grow their expertise.