BI Developer

Rh Showroom; Pennsylvania; On-site; USD 90,000 - 130,000; Full time

Job summary

Rh Showroom seeks a BI Developer to own end-to-end BI lifecycle, building semantic models in Microsoft Fabric and delivering trusted Power BI dashboards. You will collaborate with Analysts to establish a single source of truth, manage workspace governance, and ensure data security across the organization.

Requires 4+ years in BI development with Power BI, DAX, data modeling, SQL, and Fabric ecosystem expertise.

Qualifications

• 4+ years in BI development with hands-on Power BI, DAX, data modeling and security.
• Experience implementing row-level security in BI reports.
• Direct hands-on with the Microsoft Fabric ecosystem (Data Factory, Notebooks, Lakehouse).

Responsibilities

• Build and maintain semantic models, calculated tables, and transformations on Microsoft Fabric.
• Design complex data models with multiple sources and advanced relationships.
• Develop DAX measures, calculated columns, and logic for high-complexity reports.
• Create standard/moderate dashboards from approved specs with established visuals standards.
• Optimize model performance, including refresh times and Direct Lake mode where applicable.
• Coordinate with IT on upstream Fabric changes and governance.

Skills

Power BI

DAX

Data modeling

SQL

Education

Bachelor's Degree

Tools

Microsoft Fabric

Job description

Are you skilled at building semantic models and translating complex data into reports people trust? Do you know how to manage permissions and access across a growing library of dashboards? Are you detail-oriented, deadline-driven, and comfortable owning a build from data model through finished report? If so, then we’d like you to join our dedicated team as a BI Developer.

About the Role:

As a BI Developer, you will own the end-to-end business intelligence lifecycle, optimizing how data moves from our Microsoft Fabric environment into high-performing Power BI semantic models and dashboards. You will work closely with Analysts to establish a "single source of truth," manage workspace governance, and ensure data security across the organization.

You will:

• Build and maintain scalable semantic models, calculated tables, and transformations on top of our Microsoft Fabric (OneLake, Lakehouses, and Warehouses), based on specifications from our team of Analysts.

• Design complex data models involving multiple sources, advanced relationships, and non-standard calculation logic.

• Build advanced DAX measures, calculated columns, and complex calculation logic for high-priority or high-complexity reports.

• Build standard and moderate-complexity reports and dashboards from approved specs, applying our established visual and formatting standards.

• Optimize model performance, including query speed, refresh times dataset size, and leveraging Fabric’s Direct Lake mode where applicable.

• Update existing models as source data or business rules change, coordinating with our IT Engineering team when upstream Fabric pipeline or delta table schema changes are involved.

• Define and maintain row-level security (RLS) and object-level security (OLS) across semantic models and datasets.
• Manage workspace-level access provisioning, capacities, and permissions in the Fabric / Power BI service.
• Enforce naming conventions, visual layout standards, and folder/workspace structure standards.
• Maintain semantic models under version control utilizing Fabric Git integration and a dev-to-test-to-production promotion process.
• Handle report refresh issues, manage semantic model health, and perform routine production troubleshooting.
• Implement enhancement requests, minor logic changes, and resolve complex build or performance defects during user acceptance testing (UAT).

• Successfully complete required safety and compliance training programs as assigned.
• Perform other reasonably related duties as assigned by immediate supervisor and other management as requested.

About You:

• Bachelor's Degree or the equivalent combination of education, professional training, or work experience.
• 4+ years' experience in BI development, with hands‑on Power BI experience including DAX, data modeling, and row-level security.
• Direct hands‑on experience with the Microsoft Fabric ecosystem (Data Factory pipelines, Notebooks, Lakehouse management).

Our ideal candidate will also:

• Possess strong SQL skills, with direct experience querying cloud data platforms, lakehouses, or data warehouses.
• Have experience managing Power BI/Fabric workspace administration, user permissions, and deployment pipelines.
• Experience with Microsoft Fabric Adaptive Query Optimization (FAQO) for improving semantic model performance and managing query execution across Power BI datasets.
• Have a proven ability to diagnose performance bottlenecks and refresh failures in production BI environments.

Additional Nice-to-Haves / Growth Opportunities include:

• Experience with advanced external development tools such as Tabular Editor and DAX Studio.
• Experience with Power BI Project files (PBIP) and Git-based version control workflows.

• Web Integration & Application Scripting (Growth & Adaptability): Possess a basic understanding of, or a strong interest in learning, how to connect front‑end and back‑end web applications (such as React, .NET and Node.js) with the Power BI REST API. Over time, you will learn to manage and support scripts that query data and apply dynamic filtering from the BI environment. This is an excellent growth opportunity for a data professional looking to expand their full‑stack and API integration skills.
• Customer service oriented, professional, organized, and focused on attaining team goals.

• Able to prioritize work and multi-task across concurrent report builds and enhancement requests.
• Strong oral and written communication skills to convey technical concepts clearly to business stakeholders.
• Strong attention to detail and the ability to meet deadlines.