BI Developer

Hajoca

Whitemarsh Township (Montgomery County)

Remote

USD 100,000 - 135,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, dental, vision, prescription
401(k) retirement plan
Paid time off
Wellness program

Job summary

Hajoca Corporation is seeking a BI Developer to own end-to-end BI lifecycle from data modeling to dashboards. You will work with Analysts to establish a single source of truth, ensure data security, and govern Fabric-powered reports and dashboards.

The role is remote within the United States and requires strong DAX, SQL, and Fabric expertise. Responsibilities include building semantic models, optimizing performance, and maintaining governance and security across Power BI workspaces.

Qualifications

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

Responsibilities

  • Build and maintain scalable semantic models, calculated tables, and transformations on top of Microsoft Fabric.
  • Design complex data models with multiple sources and advanced relationships.
  • Build DAX measures, calculated columns, and logic for high-priority reports.
  • Create standard and moderate-complexity reports and dashboards from specs.
  • Optimize model performance and leverage Direct Lake mode where applicable.
  • Manage workspace access, security, and deployment pipelines.
  • Maintain semantic models under version control and manage production issues.

Skills

BI development
Power BI
DAX
Data modeling
Row-level security
SQL
Fabric ecosystem

Education

Bachelor's Degree

Tools

Microsoft Fabric
Power BI Service

Job description

Hajoca Corporation is one of the country’s largest privately-held wholesale distributors of plumbing, heating & cooling, and industrial supplies. Founded in 1858, Hajoca is a company based on the principles of “Service, Integrity, Reliability,” and on relationships of trust and support with teammates, customers, and suppliers. Throughout its history, Hajoca has played an active role in shaping advances in plumbing. However, we attribute our success to two simple truths; a unique business philosophy and talented people. Hajoca is all about the people, who give us our advantage, and who will guide us successfully into the future.

Hajoca has over 400 locations nationwide, called Profit Centers; and at the foundation of our family of businesses is a National Support Center (NSC) where Centers of Excellence are dedicated to enabling the success of our Profit Centers.

The Data & Analytics team in our National Support Center (NSC) is looking for a BI Developer. This is a remote position. Applicants may be based anywhere within the US.

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.

The benefits of working with us:

Our culture is well-suited for exceptional people who use their talents to drive business and want to share in the financial success their efforts yield. In addition to a competitive starting wage, we offer a Profit-Sharing Program that provides each team member with an opportunity to earn a direct share of the profits on an annual basis. In addition to our generous compensation package, Hajoca also offers:
Full-time benefits (for team members working 30 or more hours per week):

  • Medical, dental, vision, and prescription coverage
  • Accident, Hospital Indemnity, and critical care coverage
  • Life insurance and Long Term Disability
  • Pre-tax accounts for healthcare, dependent care, and commuter benefits
  • Paid vacation, holidays, and sick time (sick time also offered to PT team members as required by state law)
  • Paid pregnancy and parental leave
  • Paid day of community service

Full-time and part-time benefits:

  • 401(k)
  • Retirement cash account with company contributions
  • Targeted training programs focused on your personal and professional growth
  • Company wellness program
  • Employee discounts
  • College tuition benefits

*Please note that benefit offerings may differ for teammates employed through an intern program.
EEOC Statement

Hajoca Corporation is an Equal Opportunity Employer (Equal Opportunity Employer/Veterans/Disabled).

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity/expression, national origin, age, veteran status, disability, or any other protected category pursuant to federal, state or local laws and will not be discriminated against on the basis of any such categories/status. Hajoca is committed to providing reasonable accommodations for qualified individuals with disabilities including, but not limited to, during the application process. Please let us know if you need assistance or an accommodation due to a disability.

Background Screening Statement

We are a drug free workplace. Employment is contingent upon pre‑employment drug screening, and successful completion of a criminal background investigation subject to any federal, state and local laws.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BI Developer
BI Developer

Tosca Services, LLC (US) • Atlanta (GA)

Hybrid
USD 90,000 - 130,000
Health insurance
401(k) matching
Paid time off
+8
Senior BI Developer: Power BI, Snowflake & Modeling
Senior BI Developer: Power BI, Snowflake & Modeling

Tosca Services, LLC (US) • Atlanta (GA)

Hybrid
USD 90,000 - 130,000
Health insurance
401(k) matching
Paid time off
+8
Remote BI Developer | Power BI, Fabric & Data Modeling
Remote BI Developer | Power BI, Fabric & Data Modeling

Hajoca • Whitemarsh Township

Remote
USD 100,000 - 135,000
Medical, dental, vision, prescription
401(k) retirement plan
Paid time off
+1
Senior Power BI Developer
Senior Power BI Developer

KANINI Software Solutions PTE Ltd. • Nashville (TN)

On-site
USD 120,000 - 160,000
Senior Power BI Architect: Scalable Models & Fast Reports
Senior Power BI Architect: Scalable Models & Fast Reports

KANINI Software Solutions PTE Ltd. • Nashville (TN)

Hybrid
USD 120,000 - 160,000
Senior Analytics Engineer (PowerBi and Fabric)
Senior Analytics Engineer (PowerBi and Fabric)

Orion180 Insurance Services, LLC • Irving (TX)

On-site
USD 120,000 - 180,000
Medical, dental, vision
401k
Paid holidays
+1
BI Developer
BI Developer

JMT • Washington, Tacoma (WA)

Hybrid
USD 85,000 - 95,000
ESOP
Health insurance
Paid time off
+4
BI Engineer
BI Engineer

Corporate Strategy Division • Chicago (IL)

On-site
USD 76,000 - 139,000
Senior BI Developer
Senior BI Developer

SunSource Company • United States

On-site
USD 100,000 - 130,000
BI Developer
BI Developer

LA CANTERA RESORT & SPA • Scottsdale (AZ)

On-site
USD 90,000 - 130,000