Staff Business Intelligence Developer

This is a fully remote position, open to applicants in California.

📋 Description

• Design, develop, test, publish, and maintain Power BI dashboards and reports tailored for executive and operational audiences across various university functional areas.

• Create and sustain reusable semantic models utilizing certified Snowflake data assets.

• Write, optimize, and troubleshoot DAX, SQL, and data model logic effectively.

• Implement security protocols in Power BI, including row-level security and workspace permissions.

• Ensure that BI products are accurate, performant, accessible, well-documented, and aligned with stakeholder requirements.

• Lead the transition of BI from legacy and uncertified sources to certified Snowflake data assets.

• Validate outputs against approved definitions, prior-state reports, and expectations from business owners.

• Identify reports, measures, and models that need to be rebuilt, retired, consolidated, or replaced.

• Collaborate with the Innovation team to convert business needs into reporting requirements, semantic models, and dashboards.

• Clarify metrics, definitions, filters, and decision points in consultation with stakeholders.

• Communicate report logic, data limitations, and quality concerns effectively to both technical and non-technical audiences.

• Establish best practices for Power BI development, semantic modeling, DAX, SQL, documentation, and report lifecycle management.

• Review BI work for accuracy, usability, maintainability, and performance.

• Mentor team members and enhance internal BI capabilities as the team expands.

⛳️ Requirements

• Bachelor’s degree.

• Over 5 years of practical experience in developing enterprise Power BI dashboards, reports, and semantic models.

• Proficient in advanced Power BI skills, including data modeling, DAX, performance optimization, report publishing, workspace management, and dashboard design.

• Strong SQL skills encompassing joins, aggregations, CTEs, window functions, troubleshooting, and dataset validation.

• Hands-on experience in building BI solutions on Snowflake or a similar cloud data warehouse.

• Solid understanding of BI data modeling concepts, such as star schemas, fact and dimension tables, measures, and reusable semantic layers.

• Experience in implementing Power BI security, including row-level security and management of workspace access.

• Ability to assess whether reporting needs are best addressed through Power BI, semantic models, reporting views, certified datasets, or upstream data engineering.

• Strong visual design judgment for both executive and operational dashboards.

• Capacity to validate reporting outputs, identify data quality issues, and communicate discrepancies clearly.

• Good judgment regarding data privacy and role-based access.

• Preferred: analytics experience in the higher education sector.

• Preferred: direct experience with Snowflake in a Power BI reporting context.

• Preferred: knowledge of Power BI Service administration, including deployment pipelines, dataflows, and workspace governance.

• Preferred: familiarity with Workday Student, Blackboard, or Slate CRM.

• Preferred: understanding of data governance, metric certification, metadata, lineage, and data quality practices.

• Preferred: experience mentoring analysts, BI developers, or business users.

• Preferred: Microsoft Certified: Power BI Data Analyst Associate (PL-300) or equivalent certification.

🏝️ Benefits

• Remote work arrangement.

• Occasional travel to the main campus as needed.

• Opportunity for growth into a player-coach leadership role.

• Mentorship and internal BI capacity-building opportunities.