Senior Power BI Developer

University of Colorado Anschutz; Aurora (CO); Hybrid; USD 90,000 - 121,000; Full time

Job summary

The University of Colorado Anschutz Medical Campus is seeking a Senior Power BI Developer to own complex BI reports, semantic models, and governance for enterprise analytics. You will work with stakeholders, data engineers, and project managers to deliver scalable cloud-based analytics using Power BI, DAX, M, and Fabric.

Hybrid work is available (three days on campus) with responsibilities spanning design, deployment pipelines, security, and performance optimization across Azure, GCP, and

Qualifications

• Bachelor's degree in computer science, information systems, data analytics, engineering, or related field.
• 2+ years of BI development, analytics engineering, semantic modeling, and data warehousing.

Responsibilities

• Design, develop, and support analytics solutions within cloud-based BI platforms.
• Architect semantic models and governed analytical assets for consistent reporting.
• Partner with Cloud and Data Engineers to integrate datasets across Azure and Google Cloud and optimize performance.

Skills

Power BI

DAX

Power Query (M)

Semantic modeling

Cloud analytics

Education

Bachelor's degree in CS/IS/Engineering

Tools

Microsoft Fabric

Power BI Service

Azure DevOps

Git

PBIP

Job description

University of Colorado Anschutz

Department: School of Medicine, Office of the Dean, IT Shared Services

Job Title: Senior Power BI Developer

Position #: 00853579 - Requisition #: 41372

The Senior Business Intelligence Developer independently designs and owns complex, high-visibility BI reports and solutions, and the semantic models that support them. The position leads technical discovery, designs governed semantic models, develops advanced DAX calculations and Power Query scripts, implements security and deployment processes, optimizes solution performance, and follows team standards for Power BI development. The role partners with stakeholders, project managers, data owners, analysts, and Data Engineers to deliver scalable analytical products. The ideal candidate will have extensive reporting and semantic modeling experience, with enough knowledge of data engineering to effectively collaborate with data engineers.

Key Responsibilities:

Power BI Solution Ownership (30%)

• Design, develop, and support analytics solutions within cloud-based business intelligence and data platforms, including Microsoft Azure and Google Cloud Platform (GCP).
• Architect cloud-native reporting and analytics solutions that align with enterprise architecture, security, governance, and performance standards.
• Leverage Microsoft Fabric, Power BI Service, Azure and Google Cloud services, and related cloud technologies to deliver enterprise reporting, self-service analytics, and data exploration capabilities.
• Support solution deployment through cloud-based environments and deployment pipelines.

Semantic Modeling and Advanced Analytics (30%)

• Design and optimize semantic models that support cloud-scale analytics workloads.
• Develop governed analytical assets that enable consistent reporting across cloud-based data platforms.
• Collaborate with Cloud and Data Engineers to align semantic model design with enterprise cloud architecture and data platform standards.

Cloud Analytics Platform, Data Integration, and Performance (30%)

• Partner with Cloud and Data Engineers to integrate curated datasets from cloud data warehouses, lakehouses, and enterprise data platforms across Azure, Google Cloud, and other supported environments.
• Contribute to the design, implementation, and continuous improvement of cloud-based analytics services and solutions.
• Evaluate cloud data architecture, connectivity methods, refresh strategies, and platform performance to ensure reliable business intelligence delivery.
• Monitor and optimize cloud resource utilization, semantic model performance, query efficiency, refresh operations, and capacity management.
• Contribute to cloud governance, security, deployment, monitoring, and operational best practices.
• Participate in cloud solution design reviews and recommend improvements to scalability, resiliency, and maintainability.
• Support enterprise adoption of modern cloud analytics capabilities and emerging technologies.

Requirements, Documentation & Technical Collaboration (10%)

• Provide technical leadership and guidance on cloud analytics technologies, platform capabilities, governance, and architectural best practices.
• Serve as a subject matter expert for cloud-based business intelligence solutions and enterprise reporting platforms.
• Advise leadership on cloud analytics strategy, platform optimization, and sustainable support models.

This description is a summary of the general level of work and is not intended to be all-inclusive. Duties and responsibilities may evolve based on business need and the approved organizational design. We reserve the right to add or delete duties and responsibilities at the discretion of the supervisor and/or hiring authority.

Work Location:

Hybrid - this role is eligible for a hybrid schedule of three (3) days per week on campus and as needed for in-person meetings.

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. For more information, visit www.cuanschutz.edu.

The School of Medicine (SOM) Office of the Dean Information Services team supports a wide range of digital, data, application, infrastructure, compliance, web, and end-user technology services across departments. This role is part of the Data team and focuses on business intelligence, semantic modeling, reporting, and analytical solutions.

Why work for the University?

We have AMAZING benefits and offerexceptional 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: 15/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.

Qualifications:

Minimum Qualifications:

• Bachelor's degree in computer science, information systems, data analytics, engineering, or a related field.
  • 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.
• Two (2) years of progressively responsible experience with BI development, analytics engineering, semantic modeling, and data warehousing.

Applicants must meet minimum qualifications at the time of hire.

Preferred Qualifications:

• Advanced experience with Power BI Desktop and Power BI Service, including SQL, DAX, Power Query (M), semantic modeling, and dimensional data modeling.
• Experience with advanced BI architecture and administration, including deployment pipelines, dataflows, gateways, row-level and object-level security (RLS/OLS), calculation groups, composite models, and performance optimization.
• Experience with Microsoft Fabric, SSAS Tabular, Azure DevOps, Git, PBIP, CI/CD practices, automated testing, and release management.
• Experience independently leading complex BI solutions through requirements gathering, design, development, testing, deployment, and production support; including establishing standards, conducting code reviews, and mentoring technical staff.
• Experience working with regulated or complex data environments such as higher education, healthcare, research, finance, or similar industries; experience in a university environment preferred.

Conditions of Employment:

• Applicants must be legally authorized to work in the United States without requiring sponsorship. We are unable to provide work visa sponsorship or employment authorization for this position now or in the future.

Knowledge, Skills and Abilities:

• Knowledge of business intelligence architecture, data governance, data quality, security, privacy, and maintainable development practices.
• Knowledge of Agile delivery methodologies and the software development lifecycle.
• Knowledge of reporting, analytics, and data visualization best practices.
• Strong analytical and problem-solving skills with the ability to evaluate complex business and technical requirements.
• Effective written and verbal communication skills, including the ability to present technical concepts to nontechnical audiences.
• Skill in consulting on technical approaches, evaluating design alternatives, and communicating recommendations to stakeholders and project teams.
• Skill in prioritizing work, managing multiple commitments, and delivering results within established timelines.
• Ability to build collaborative relationships and work effectively with cross-functional teams and stakeholders.
• Ability to exercise sound technical judgment and make independent decisions within established guidelines.
• Ability to maintain a high level of accountability, attention to detail, and commitment to continuous improvement.
• Ability to explain complex technical trade-offs and influence decision-making across varying levels of the organization.

Employment type:

Full-time

Anticipated Pay Range:

The starting salary range (or hiring range) for this position has been established as $89,926 to $120,501.

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

Equal Employment Opportunity Statement:

CU is an Equal Opportunity Employer and complies with all applicable federal, state, and local laws governing nondiscrimination in employment. We are committed to creating a workplace where all individuals are treated with respect and dignity, and we encourage individuals from all backgrounds to apply, including protected veterans and individuals with disabilities.

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 [e-mail].

Background Check Statement:

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