Business Intelligence Report Analyst

Job Summary:

The School of Medicine Dean’s Office has an opening for a full-time Business Intelligence (BI) Report Analyst. This position requires an excellent communicator, a curious and inquisitive temperament, and a strong background in developing enterprise level data solutions. The BI Report Analyst will be responsible for diving deep into department’s operational reporting needs and delivering BI reporting solutions that meet those needs.  This role will collaborate closely with School of Medicine departments to translate business processes and requirements into BI reports that support business operations and strategy.

Key Responsibilities:

• Engage with business stakeholders to analyze reporting needs and requirements to modify existing reports and systems.
• Interpret, define, and document existing reporting datasets and business rules.
• Assist with ad-hoc queries to support ongoing operational business needs.
• Identify opportunities to standardize legacy reports and scale out to a larger School of Medicine audience.
• Develop reporting solutions utilizing MS SQL Server, MS SQL Server Analysis Services, and other data sources using Excel, PowerBI, SQL Server Reporting Services, and other BI platforms as appropriate.
• Migrate legacy reporting solutions built in Excel (and/or MS Access) to SQL Server Reporting Services, PowerBI, and other BI platforms as appropriate.
• Implement role-based security to limit data access when required. 
• Maintain and support all reporting assets and ensure reporting environments are performant and secure.
• Mange access and user security across various reporting platforms.
• Proactively identify opportunities for process improvement to add value or create efficiencies (performance tuning, code reusability, etc.).
• Validate and test output data result accuracy; perform code review, data product user-acceptance testing, and other related testing.
• Engage with School of Medicine Information Services Business Intelligence Developers to understand current BI systems and tools.
• Propose well-defined enhancements to the School of Medicine Information Services Business Intelligence development team to meet business requests for reporting.

Why Join Us:

The University of Colorado Anschutz Medical Campus is a world-class medical destination at the forefront of transformative science, medicine, education and patient care. The campus encompasses the University of Colorado health professional schools, more than 60 centers and institutes, and two nationally ranked independent hospitals - UCHealth University of Colorado Hospital and Children's Hospital Colorado - that treat more than two million adult and pediatric patients each year. Innovative, interconnected and highly collaborative, the University of Colorado Anschutz Medical Campus delivers life-changing treatments, patient care and professional training and conducts world-renowned research fueled by over $650 million in research grants. For more information, visit www.cuanschutz.edu .

Are you looking to work for a world-class medical destination?

Would you love to help team members solve some of their technology problems?

Do you love working in environment that fosters collaboration?

What about an organization that has amazing benefits offering 10 holidays a year along with an exceptional amount of vacation and sick time, exceptional retirement savings plans, work life balance, remote, hybrid or in-person opportunities?

The University of Colorado offers a comprehensive benefits package that includes health insurance, life insurance, retirement plans, tuition benefits, ECO pass, paid time off – vacation, sick, and holidays and more. To see what benefits are available, please visit: https://www.cu.edu/employee-services/benefits-wellness .

Diversity and Equity:

The University of Colorado Anschutz Medical Campus is committed to recruiting and supporting a diverse student body, faculty, and administrative staff. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities, persons within the LGBTQ+ community and all veterans. The University of Colorado is committed to diversity and equality in education and employment.

Qualifications:

Minimum Qualifications:

• A bachelor’s degree in Computer Science, Information Technology, or related field.
  • Substitution: A combination of education and related technical/paraprofessional experience may be substituted for the bachelor’s degree on a year for year basis.
• At least one to two (1-2) years of experience analyzing data in SQL environments and authoring, deploying, and maintaining dashboards.

Applicants must meet minimum qualifications at the time of hire.

Preferred Qualifications:

• 2 years’ experience with Microsoft Excel (Pivot Tables, data connections, advanced excel formulas like VLOOKUP, HLOOKUP, INDEX, MATCH, CUBESET, CUBEVALUE).
• 4 years’ experience analyzing data in SQL environments (Transactional OLTP, Data Warehouses, and Analytical OLAP Databases).
• 4 years’ experience developing SQL ad-hoc queries, stored procedures, and views for reporting needs.
• 4 years’ experience authoring, deploying, and maintaining parameterized reports using SQL Server Reporting Services.
• 2 years’ experience authoring, deploying, and maintaining dashboards using Microsoft PowerBI (or another data visualization tool such as Tableau, Looker, etc).
• Experience developing SQL queries utilizing slowly changing dimensions (Type II) to represent historical data.
• 2 years’ experience querying dimensional models (star and snowflake schema) for reporting needs.
• 2 years’ experience integrating disparate datasets within reporting platforms. 
• 2+ years’ experience querying and manipulating data using PowerQuery.
• 2+ years’ experience developing DAX (or MDX) queries in Microsoft Excel and/or PowerBI.
• 2+ years’ experience implementing role-based security to limit data access when required.

Knowledge, Skills, and Abilities:

• Business / Finance / Healthcare background.
• Strong customer service orientation.
• Detail-oriented.
• Thrives in ambiguity and excels in a fast-paced, dynamic environment.
• Ability to problem solve, communicate clearly and escalate risks / issues as they arise.
• Adept at managing stakeholders, priorities, expectations.
• Effective communication and collaboration.

How to Apply:

For full consideration, please submit the following document(s):

Questions should be directed to: Michelle Dedin at [email protected]

Screening of Applications Begins:

Applications will be accepted until finalists are identified.

Anticipated Pay Range:

The starting salary range (or hiring range ) for this position has been established as $55,804 to $70,983.

The above hiring range represents the University’s good faith and reasonable estimate of the range of possible compensation at the time of posting. This position may be eligible for overtime compensation depending on the level.

Your total compensation goes beyond the number on your paycheck. The University of Colorado provides generous leave, health plans and retirement contributions that add to your bottom line.

Total Compensation Calculator: http://www.cu.edu/node/153125

ADA Statement:

The University will provide reasonable accommodations to applicants with disabilities throughout the employment application process. To request an accommodation pursuant to the Americans with Disabilities Act, please contact the Human Resources ADA Coordinator at [email protected] ​.

Background Check Statement:

The University of Colorado Anschutz Medical Campus is dedicated to ensuring a safe and secure environment for our faculty, staff, students, and visitors. To assist in achieving that goal, we conduct background investigations for all prospective employees.

Vaccination Statement:

The University of Colorado has a requirement for COVID-19 vaccinations and full completion thereof by 9/1/21 or upon start date.  Information regarding this requirement, and exemptions can be found at:

Anschutz: https://www.ucdenver.edu/docs/librariesprovider284/default-document-library/3000-general-admission/3012---covid-19-vaccination-requirement-and-compliance.pdf?sfvrsn=4e9df3ba_2

Unit-Specific Exemptions:

• Anschutz Campus – Accommodations may be granted for medical or religious reasons.

The University of Colorado seeks individuals with demonstrated commitment to creating an inclusive learning and working environment. We value the ability to engage effectively with students, faculty, and staff of diverse backgrounds.