Senior BI Developer

Carmel Partners•Denver, CO

9h•$115,000 - $125,000•Onsite

About The Position

Carmel Partners, a leading real estate investment management specialist, is seeking a Senior Business Intelligence Developer for its Denver, CO office. This role is responsible for designing, developing, and supporting enterprise analytics and reporting solutions within the Microsoft BI ecosystem, with a primary focus on Power BI. The position involves full ownership of the BI development lifecycle, including semantic modeling, DAX development, report and dashboard design, Power BI Service administration, and gateway support. The Senior BI Developer will collaborate with business stakeholders, data engineering, and IT teams to deliver scalable, governed, and high-performing reporting solutions. Experience with Microsoft Fabric is strongly preferred.

Requirements

5+ years of hands-on Power BI development experience, including ownership of enterprise semantic models, datasets, and reports supporting business stakeholders and operational reporting needs.
Advanced expertise in DAX, including time intelligence, calculation groups, variables, advanced filter context manipulation, and performance tuning using tools such as DAX Studio and Performance Analyzer.
Strong semantic modeling expertise, including star schema design, role-playing dimensions, many-to-many relationships, RLS/OLS implementation, and architecture considerations across Import, DirectQuery, Composite, and Direct Lake models.
Strong Power Query (M) and SQL skills, including query folding, parameterization, incremental refresh configuration, data validation, profiling, and source query development against SQL Server, Azure SQL, or Synapse.
Experience developing and supporting enterprise Power BI Service environments, including workspace governance, deployment pipelines, refresh management, capacity administration, sharing/permissions, and tenant-level settings.
Hands-on experience installing, configuring, and troubleshooting on-premises data gateways, including clustering, credential management, connectivity issues, and version upgrades.
Demonstrated ability to design clean, intuitive, and accessible dashboards and reports aligned with corporate branding and executive reporting standards.
Strong troubleshooting and problem-solving skills related to report performance, refresh failures, gateway connectivity, dataset memory constraints, and capacity optimization.
Excellent communication and stakeholder management skills, with the ability to translate business requirements into scalable reporting solutions and explain technical concepts in clear business terms.
Deep intellectual curiosity and the desire to apply excellent technical skills to drive value and shape investment strategy.
Excellent organization and time management skills – able to manage and execute multiple quantitative projects simultaneously.
Exceptional communication, presentation, and interpersonal skills.
Values relationships – thrives in a collaborative team setting as well as working independently.
Demonstrates impeccable integrity and dependable judgment.
Applicants must be authorized to work in the U.S.A.

Nice To Haves

Experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake, Dataflows Gen2, Pipelines)
Experience with Tabular Editor 3
Experience with ALM Toolkit
Experience with Azure DevOps/Git
Experience with paginated reports
Power BI certifications (PL-300, DP-600)

Responsibilities

Design, develop, and maintain enterprise-grade Power BI semantic models using Import, DirectQuery, Composite, and Direct Lake architectures, applying star-schema best practices.
Author, optimize, and troubleshoot complex DAX measures and calculation groups, including time intelligence, semi-additive measures, advanced filter context, and dynamic security patterns.
Build and maintain Power Query (M) transformations, parameterized datasets, reusable dataflows, and incremental refresh strategies.
Implement and manage row-level security (RLS), object-level security (OLS), workspace roles, app audiences, and dataset/report permissions.
Develop reusable semantic models, shared datasets, and reporting templates.
Source and integrate data from SQL Server, Azure SQL, Synapse, Microsoft Fabric, Dataverse, SharePoint, and REST APIs.
Design and deliver intuitive, visually effective dashboards and reports that align with accessibility standards, corporate branding, and executive reporting needs.
Develop paginated reports using Power BI Report Builder for operational, regulatory, and print-ready reporting requirements.
Install, configure, maintain, and troubleshoot on-premises data gateways, including clustering, credential management, version upgrades, and connectivity support.
Administer Power BI Service environments, including workspace management, deployment pipelines, scheduled refreshes, gateway configurations, alerts, and Premium/Fabric capacities.
Troubleshoot and resolve refresh failures, gateway connectivity issues, dataset memory constraints, capacity throttling, timeout errors, and report rendering issues.
Monitor platform health and capacity utilization, proactively tuning workloads and resolving issues.
Support tenant-level governance initiatives, including workspace standards, naming conventions, certified/promoted datasets, audit log reviews, and security best practices.
Participate in on-call support rotations during critical reporting cycles.
Serve as the primary BI partner for assigned business functions, understanding operational processes, KPIs, reporting cadences, and business priorities.
Gather, analyze, and translate business requirements into semantic model designs, measure definitions, and reporting solutions.
Manage and prioritize a BI development backlog across multiple stakeholders, projects, and competing business priorities.
Utilize deployment pipelines and source control tools, including Git and Azure DevOps, to support structured development, testing, deployment, and rollback processes.
Maintain documentation for semantic models, business logic, data lineage, report catalogs, refresh operations, and support procedures.
Coordinate releases, production deployments, and planned maintenance activities with Change Management and business stakeholders.
Support ongoing process improvement initiatives and perform other duties, responsibilities, and special projects as assigned.