Senior BI Developer

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

A place for you

Here at Carmel, we don't just invest in buildings, we invest in careers. If you don't meet all of the qualifications listed for this role, we encourage you to monitor our career page for upcoming opportunities. We're committed to assembling diverse teams with exceptional talent, and we strongly encourage individuals from a wide range of backgrounds to apply. Everyone's career journey is unique, so let's explore how you could be a great fit for our team!

What you'll do

Semantic Modeling & DAX Development

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

Power BI Service & Gateway Administration

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

Delivery, Collaboration & Continuous Improvement

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

What you'll bring

• 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.
• Experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake, Dataflows Gen2, Pipelines), Tabular Editor 3, ALM Toolkit, Azure DevOps/Git, paginated reports, and Power BI certifications (PL-300, DP-600) preferred.

Who you are

• 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

Compensation and Benefits

Compensation and benefits play a key role in your choice of employer, and our goal is to invest in you and your experience here. You'll find competitive compensation and a comprehensive benefits package at Carmel.

Base compensation range $115K to $125K. Total compensation for this role also includes a bonus incentive in addition to the base salary. The Company reserves the right to ultimately pay more or less than the posted range and to offer additional benefits and other compensation, depending on circumstances unrelated to an applicant's sex or other protected status under local, state, or federal law.

Choose Carmel

At Carmel Partners, our mission is to create exceptional multifamily communities that enrich lives and neighborhoods.

Founded in 1996, Carmel is one of the nation's leading specialists in real estate investment management, focusing on U.S. multifamily development and construction, renovation, and debt investments. Through its vertically integrated platform, Carmel seeks to achieve superior risk-adjusted returns across market cycles by investing in relatively supply-constrained, high-barrier-to-entry markets in the United States.

Visa Sponsorship: Carmel Partners is currently unable to sponsor or assume sponsorship of an employment visa for this role. We require that applicants be authorized to work in the U.S.A.

Inclusion Statement

We are committed to equitable hiring and promotion practices. We lead with integrity and believe in building a diverse and inclusive workplace, rooted in a culture of mutual respect. By welcoming varied backgrounds, perspectives, and ideas, we cultivate engagement and a sense of belonging that creates community within, so Carmel can build communities that thrive.

Carmel Partners is an Equal Opportunity Employer, committed to providing employees with a work environment free of discrimination and harassment. Employment decisions are based on business needs, job requirements and individual qualifications without regard to race, color, religion or belief, gender, gender identity, gender expression, sexual orientation, pregnancy and reproductive decisions, family or parental status, national origin, age, disability, veteran status, or any other status protected under local, state, or federal laws.

Notice to Third-party Agencies: Carmel Partners does not have any standing offers to pay any referral compensation or recruitment fees for any open positions. Unless there is a signed agreement providing otherwise, Carmel Partners will not pay any compensation to any employment Firm, staffing agency, recruiter, or other third party for any resumes or candidate profiles provided, even if the individual is hired by Carmel Partners. In the event a recruiter or third-party agency/Firm submits a resume or candidate profile without a signed active agreement, Carmel Partners explicitly reserves the right to pursue, and hire said candidate without any notice or financial obligation to the recruiter or agency/Firm. Carmel Partners reserves the right to retain, use, transfer and distribute any resumes and candidate profiles that are submitted, including those submitted to hiring managers.