IT Senior Business Intelligence Developer

Job Summary:

The School of Medicine Information Services team has an opening for a full-time Information Technology Senior Professional Business Intelligence Developer. This position will assist in the design, development, testing and maintenance of performance-optimized Business Intelligence (BI) solutions for the School of Medicine. This position requires an excellent communicator, a curious and inquisitive temperament, and a strong background in developing enterprise level data solutions. The BI Developer will be responsible for implementing and maintaining numerous BI solutions for a diverse set of stakeholders within the School of Medicine. This role will work closely with School of Medicine data owners to translate business processes and requirements into BI tools that support business operations and strategy.

Key Responsibilities:

Business Intelligence (BI) Tools and Reporting - 40%

• Create business intelligence tools and reports, such as physical data models and dimensional analyses.
• Author, deploy, and support end-user reports, dashboards, and tools built in PowerBI, SQL Server Reporting Services, Excel, and others.
• Complete full lifecycle development for business intelligence (BI) reports and applications.
• Analyze user needs and requirements to modify or enhance existing reports, data models, and tools.
• Validate and test outputs for accuracy; perform code review, conduct data product user-acceptance testing, and other related testing.

SQL Server Analysis Services (SSAS) - 20%

• Assist in the development, deployment, and maintenance of SQL Server Analysis Services tabular models.
• Configure data sources, load and modify tables/partitions, create measures, relationships, and model roles to apply row-level-security.
• Assist in authoring novel measures using DAX query language.

Data Warehousing Concepts and Technologies- 20%

• Provide hands-on participation with common analytics and data warehousing concepts & technologies such as data marts, star schemas, facts and dimensions.
• Assist with development and maintenance of ETL integration processes by monitoring daily imports, ODBC connections and event/error management.
• Troubleshoot and optimize ETL pipelines, SQL queries, and ETL jobs for optimal system performance.

Data Architecture and Warehousing- 10%

• Participate in the design, development, and analysis of data architecture, warehousing, and reporting methodologies.
• Design, develop, deploy, and maintain MS SQL databases within School of Medicine Data Warehouse.

Process Improvement & Documentation- 5%

• Proactively identify opportunities for process improvement to add value or create efficiencies (performance tuning, code reusability, etc.).
• Create, update and maintain technical documentation for all data sources, business rules, and data processes.

End User Support - 5%

• Provide direct support to end users of analytics products, including handling support tickets, bug reports, access requests, and general education.

Work Location:

Remote - this role is eligible to work remotely, but the employee must be in the United States.

Why Join Us:

Are you passionate about leveraging technology to advance health science education and research? At the School of Medicine Information Services, we are dedicated to making a significant impact through innovative technology solutions. Our team provides a wide range of services, including custom development, data collection, analytics, consulting, technology support, security and compliance, web design, and much more.

As a member of our team, you'll collaborate with top-tier professionals to support clinical, research, and educational initiatives. You'll have the opportunity to work on cutting-edge projects, enhance your skills, and contribute to a mission-driven organization that values customer-centric service and technological excellence.

If you're ready to be part of a forward-thinking team that is transforming the future of healthcare through technology, we invite you to apply and join us in making a difference!

Why work for the University?

We have AMAZING benefits and offer exceptional amounts of holiday, vacation and sick leave! The University of Colorado offers an excellent benefits package including:

• 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/year (maximum accrual 352 hours)
• Sick Days: 15/year (unlimited maximum accrual)
• Holiday Days: 10/year
• Tuition Benefit: Employees have access to this benefit on all CU campuses
• ECO Pass: Reduced rate RTD Bus and light rail service

There are many additional perks & programs with the CU Advantage.

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, ethnically minoritized individuals, persons with disabilities, persons within the LGBTQ community and all veterans. In addition, the Anschutz Campus has also been recognized as an Age-Friendly University. 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.
• At least 2 years professional level experience as a business intelligence developer, software developer, programmer or related occupation which includes experience working with SQL queries to extract data from relational databases (SQL Server and Oracle) in addition to creating stored procedures, views, and user-defined functions.
  • A combination of education and related technical/paraprofessional experience may be substituted for the bachelor's degree on a year for year basis.

Applicants must meet minimum qualifications at the time of hire.

Preferred Qualifications:

• 2 years' experience with PowerBI, Tableau or other similar data visualization tools.
• Bachelor's degree in finance or scientific field and/or experience working with finance or higher education administration.
• 4 years' experience developing BI solutions built on the Microsoft SQL Server Business Intelligence stack: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
• 4 years' experience implementing analytical data models within a data warehouse environment (star, snowflake, etc.).
• 2 years' experience with PowerBI, Tableau or other similar data visualization tools.
• Experience with Microsoft SQL Server Analysis Services Tabular Model development (as opposed to Multi-Dimensional Model development)
• Experience implementing Kimball Group dimensional modeling techniques
• Experience implementing data-driven role-based row-level security within PowerBI and SQL Server Analysis Services Tabular models.
• Experience with Microsoft Power Query Language (M) and DAX (Data Analysis Expressions)
• Experience with Microsoft Azure ETL tools such as Azure Data Factory, Azure Functions, Azure Blob Storage
• Experience with version control systems such as Git
• Experience with code repositories and collaboration platforms such as GitHub

Knowledge, Skills and Abilities:

• Ability to convey technical information to technical and non-technical users.
• Understanding best practices for data reporting and data visualization.
• Professional, service-oriented, meticulous, and detail oriented. Readily takes ownership and responsibility for work.
• Inquisitive, self-starter with the ability to work independently while also contributing to team efforts.
• Ability to prioritize multiple projects and requirements while meeting deadlines.
• Ability to thrive in ambiguous environments.
• Ability to create and maintain business requirements and other technical documentation.

How to Apply:

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

1. Curriculum vitae / Resume

2. Three to five professional references, including name, address, phone number (mobile number if appropriate), and email address

Questions should be directed to: Michelle Dedin at michelle.dedin@cuanschutz.edu

Screening of Applications Begins:

Immediately and continues until February 6, 2024. If this option is used, the posting will come down on the date indicated. The hiring department will need to notify their Talent Acquisition Consultant if the role needs to be reposted.

Anticipated Pay Range:

The starting salary range (or hiring range) for this position has been established as HIRING RANGE: $80,000 - $100,000

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

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:

CU Anschutz strongly encourages vaccination against the COVID-19 virus and other vaccine preventable diseases. If you work, visit, or volunteer in healthcare facilities or clinics operated by our affiliated hospital or clinical partners or by CU Anschutz, you will be required to comply with the vaccination and medical surveillance policies of the facilities or clinics where you work, visit, or volunteer, respectively. In addition, if you work in certain research areas or perform certain safety sensitive job duties, you must enroll in the occupational health medical surveillance program.