Senior BI Developer

Work at Carmel Partners•Denver, CO

8h•Onsite

About The Position

Carmel Partners, one of the nation’s leading specialists in real estate investment management, with expertise in the investment, development, and construction of multi-family real estate, is seeking a Senior Business Intelligence Developer in our Denver, CO Office. The Senior BI Developer is responsible for designing, developing, and supporting enterprise analytics and reporting solutions within the Microsoft BI ecosystem, with a primary focus on Power BI. This role owns the full BI development lifecycle, including semantic modeling, Data Analysis Expressions (DAX) development, report and dashboard design, Power BI Service administration, and gateway support. The position partners closely 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 to ensure scalability, reusability, and clear business semantics.
Author, optimize, and troubleshoot complex DAX measures and calculation groups, including time intelligence, semi-additive measures, advanced filter context, and dynamic security patterns, using tools such as DAX Studio and Performance Analyzer.
Build and maintain Power Query (M) transformations, parameterized datasets, reusable dataflows, and incremental refresh strategies to support large-scale reporting environments.
Implement and manage row-level security (RLS), object-level security (OLS), workspace roles, app audiences, and dataset/report permissions in alignment with governance standards.
Develop reusable semantic models, shared datasets, and reporting templates to improve consistency, reduce duplication, and support enterprise reporting standards.
Source and integrate data from SQL Server, Azure SQL, Synapse, Microsoft Fabric, Dataverse, SharePoint, and REST APIs, collaborating closely with data engineering teams on upstream data models and pipeline design.
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 to ensure platform reliability and performance.
Monitor platform health and capacity utilization, proactively tuning workloads and resolving issues before business impact occurs.
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, including month-end and quarter-end close periods.
Serve as the primary BI partner for assigned business functions, developing a strong understanding of operational processes, KPIs, reporting cadences, and business priorities.
Gather, analyze, and translate business requirements into semantic model designs, measure definitions, and reporting solutions that balance usability, governance, and performance.
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.