Description
University of Colorado | CU Anschutz Medical Campus

Office of the Vice Chancellor of Health Affairs

Senior IT Professionals – Business Intelligence Developer

Position #00002927– Requisition #20534

* Applications are accepted electronically ONLY at www.cu.edu/cu-careers *

The University of Colorado Anschutz Medical Campus 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.

The Office of the Vice Chancellor of Health Affairs has openings for full-time University Staff (unclassified) Business Intelligence Developer positions.

The University of Colorado Anschutz Medical Campus is a public education, clinical and research facility serving 4,500 students, and a world-class medical destination at the forefront of life-changing science, medicine, and healthcare. CU Anschutz offers more than 42 highly rated degree programs through 6 schools and colleges, and receives over $500 million in research awards each year. We are the single largest health professions education provider in Colorado, awarding nearly 1,450 degrees annually. Powered by our award-winning faculty, renowned researchers and a reputation for academic excellence, the CU Anschutz Medical Campus drives innovation from the classroom to the laboratory to the delivery of unparalleled patient care. Read CU Anschutz Quick Facts here.

Nature of Work

Senior Professionals are responsible for exercising discretion, analytical skill, personal accountability and responsibility in a wide range of areas including academic, administrative, managerial and student services functions. Work involves creating, integrating, applying and sharing knowledge directly related to a professional field.  Work is performed fully independently.

Examples of Work Preformed

• Design and develop reports, dashboards, data extracts, and visualizations across a variety of healthcare and biomedical domains
• Assist with the design of the dimensional models behind reporting platforms
• Work with a team throughout all phases of software development lifecycle
• Complete full lifecycle development for business intelligence (BI) reports and applications. Analyze user needs and requirements to modify existing reports
• In a university setting, develop SQL queries from clinical databases
• Work with university faculty to analyze and define business requirements
• Develop efficient SQL queries and design algorithms to extract data from cloud-based data warehouses like Google BigQuery, and/or relational databases like SQL Server
• Format result datasets to follow standard data input processes for reporting platforms
• Validate and test output result accuracy; perform code review, data product user-acceptance testing, and other related testing
• Profile and understand enterprise data warehouses in order to answer research-based questions.

Salary and Benefits:

The salary range (or hiring range) for this position has been established at $74,526 - $100,000

The salary of the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training.

The above salary range (or hiring range) represents the University’s good faith and reasonable estimate of the range of possible compensation at the time of posting.

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.

Benefits: https://www.cu.edu/employee-services/benefits

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

Diversity and Equity:

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 hr.adacoordinator@ucdenver.edu.

The University of Colorado Denver | 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 and all veterans. The University of Colorado is committed to diversity and equality in education and employment.

The University of Colorado Denver | 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.

Qualifications
Minimum Qualifications

• MS degree in Computer Science, Financial Mathematics, Computer Information Systems, or related quantitative field
• 2 years experience as a business analyst, business intelligence developer, software developer, programmer, or related occupation, which must include some experience with developing SQL queries to extract data from relational databases (SQL Server and Oracle); SQL and Transact-SQL; designing, developing and validating BI outputs using Tableau; troubleshooting and resolving bugs related to data accuracy, usability, and performance issues; working efficiently with large clinical data warehouses; data structure, and data manipulation techniques.
• Requires 1 year of experience working with EMR data like Epic Clarity
• Completion of a background investigation also required.

Job Category: Information Technology
Primary Location: Aurora
Schedule: Full-time
Posting Date: Mar 16, 2021
Unposting Date: Ongoing