Senior Power BI Developer

Senior Power BI Developer

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 Job Summary: 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.

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 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 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: 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.

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.