Power BI Developer
Power BI Developer (Business-Focused Analytics) - No Vendors please, must be a Colorado Resident. We are seeking a Power BI Developer who is equally comfortable with business conversations as they are with technical execution. This role is ideal for someone who thrives in lean teams, can lead working sessions with stakeholders, and knows when to pause, listen, and translate questions into actual requirements—not assumptions.This is not a “heads-down-only” developer role. Success in this position requires strong situational awareness, the ability to read the room, and confidence facilitating meetings, screen-sharing, and consolidating loosely defined ideas into scalable analytics solutions.What Makes This Role DifferentYou’ll work closely with stakeholders who may be exploring possibilities, not always making direct requestsYou’ll help clarify intent before building—avoiding the common trap of “building what was asked instead of what was needed”You’ll validate dashboards and logic using Excel-based modeling, not just Power BI outputsYou’ll reverse engineer existing reports and models to improve performance, clarity, and usabilityKey ResponsibilitiesBusiness Engagement & CollaborationLead and participate in working sessions with business stakeholders, including requirement-gathering meetings and backlog discussionsAsk thoughtful follow-up questions to distinguish between exploratory questions and actual feature requestsTranslate business needs into clear technical requirements and scalable data modelsPresent insights and dashboards to non-technical audiences with clarity and confidencePower BI Development & Data ModelingDesign and build efficient, scalable data models aligned to business requirementsCreate and manage relationships between tables and optimize data structures for performanceDevelop interactive Power BI reports and dashboards using slicers, drill-throughs, and intuitive visualsDAX & Power QueryWrite and optimize DAX formulas, including calculated columns, measures, and custom calculationsAnalyze and refactor existing DAX logic to improve performance and maintainabilityReview and optimize Power Query transformationsData Source ConnectivityConnect Power BI to various data sources (SQL databases, Excel files, and other structured sources)Ensure reliable data extraction, transformation, and refresh processesExcel Modeling & ValidationBuild Excel models to validate dashboard outputs and test business logicUse complex formulas, pivot tables, and analytical techniquesReverse engineer existing Excel workbooks to understand formulas, dependencies, and hidden logicReverse Engineering & OptimizationDeconstruct existing Power BI reports, datasets, and Excel modelsIdentify inefficiencies, redesign logic, and recreate improved solutionsAnalyze existing DAX, Power Query steps, pivot tables, and (where applicable) Excel macrosDocumentationCreate and maintain clear documentation, including:Data dictionariesData flow diagramsProcess maps and reporting logicEnsure documentation supports long-term usability, onboarding, and consistencyPower BI Service & DeploymentPublish and manage reports in the Power BI ServiceConfigure access controls and workspace permissionsSchedule and monitor refreshesOptimize report performance for large or complex datasetsAI & Modern Analytics ToolingLeverage AI tools to improve efficiency in data analysis, documentation, or development workflowsStay curious and adaptable as analytics tooling evolvesRequired Skills & ExperienceStrong Power BI development experience with real-world business stakeholdersProficiency in DAX and data modeling best practicesIntermediate to advanced Excel skills (modeling, formulas, pivot tables, reverse engineering)Experience leading meetings, screen-sharing, and facilitating working sessionsAbility to explain technical concepts clearly to non-technical audiencesProven comfort working in lean, fast-moving teams