Senior Insights & Visualization Analyst

Senior Insights & Visualization Analyst

University of Colorado Anschutz Medical Campus

Department:
Budget, Planning and Campus Strategy

Position #: – Requisition #:38928

Key Responsibilities:

• Build interactive dashboards and insight-focused products in Power BI and/or Tableau that support strategic planning and executive decision‑making.
• Craft clear data stories that highlight context, trends, and implications for senior leaders.
• Write complex SQL queries across enterprise data systems such as Oracle, MS SQL Server, and Snowflake, including tasks like joining large relational tables, building analytical queries (window functions, CTEs, subqueries), optimizing slow queries, and validating results for accuracy.
• Work across diverse institutional content areas—including student and course records, HR, finance, and budget data—to integrate information, ensure consistency, and support cross‑functional analysis.
• Partner with stakeholders to interpret analytical findings, promote data literacy, and refine metrics or definitions.
• Integrate and reconcile data across systems; recommend improvements to data quality, consistency, and governance.
• Document logic, methodology, and data lineage for dashboards and recurring reporting.
• Troubleshoot and resolve complex data issues to ensure accuracy and reliability of delivered information.
• Gather business requirements and translate them into effective data solutions aligned with institutional systems.
• Continuously learn new tools, methods, and best practices for presenting information clearly and creatively.
• Use Python or related tools to support data preparation or automation when beneficial.
• Perform ad‑hoc analysis as requested.

Work Location:

Hybrid (3 days on‑campus, 2 days remote, as needed for in‑person meetings.)

• Medical:
  Multiple plan options
• Dental:
  Multiple plan options
• Additional Insurance:
  Disability, Life, Vision
• Retirement 401(a) Plan:
  Employer contributes 10 % of your gross pay
• Paid Time Off:
  Accruals over the year
• Vacation Days: 22 days/year (maximum accrual 352 hours)
• Sick Days: 15 days/year (unlimited maximum accrual)
• Holiday Days: 15 days/year
• Tuition Benefit:
  Employees have access to this benefit on all CU campuses
• ECO Pass:
  Reduced rate RTD Bus and light rail service

• Bachelor's degree and/or equivalent experience in a relevant subject area (Computer Science, Information Technology, Business Administration, Mathematics, Statistics, Economics, or Data Science). Substitution: a combination of education and related technical/military/paraprofessional experience may be substituted for a bachelor's degree on a year‑for‑year basis.
• At least 2 years of relevant experience creating dashboards or analytical reports in a multi‑system environment.
• Experience using BI tools such as Power BI and/or Tableau to develop data products used in organizational reporting or decision‑making.

• Master's degree and/or equivalent experience in a relevant subject area (Computer Science, Information Technology, Business Administration, Mathematics, Statistics, Economics, or Data Science).
• Experience working with enterprise systems such as People Soft, Campus Solutions, Salesforce, or data warehouse environments.
• Experience with Python, R, SAS, SPSS or similar tools.

• This position is not eligible now or in the future for visa sponsorship.

• Advanced SQL skills, including writing complex queries, joins, and logic to shape and validate data.
• Strong ability to tell stories with data, connecting analysis to real‑world implications and decisions.
• High level of creativity with a strong sense of design, user experience, and formatting precision.
• Proficiency in data analysis and visualization tools like Power BI, Tableau, SQL, and Python.
• Proficiency in statistical concepts and methodologies.
• Ability to present and summarize information clearly using charts, dashboards, narratives, and other data products.
• Advanced analytical thinking and the ability to synthesize information from multiple data sources.
• Attention to detail and a strong commitment to data integrity.
• Strong…