Senior Bi Developer Jobs (NOW HIRING)

Job Summary:
Carmel Partners, one of the nation’s leading specialists in real estate investment management, is seeking a Senior Business Intelligence Developer in their Denver, CO office. The Senior BI Developer will be responsible for designing, developing, and supporting enterprise analytics and reporting solutions within the Microsoft BI ecosystem, primarily focusing on Power BI.
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.
Qualifications:
Required:
• 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.
Preferred:
• 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)
Company:
Carmel Partners is a company that provides real estate management services. Founded in 1992, the company is headquartered in San Francisco, USA, with a team of 201-500 employees. The company is currently Growth Stage.