Sr Power BI Developer

About Health Monitor Network

Health Monitor Network is a leading direct-to-patient healthcare marketing company with a 35+ year track record of connecting patients and providers through digital, print, and point-of-care content reaching tens of millions of patients each year. Now backed by private equity and growing through both organic expansion and acquisition, HMN is investing in building a best-in-class People function to power its next stage of growth.

Position Overview

THIS IS A HYBRID ROLE BASED IN MONTVALE, NJ The Senior Power BI Developer owns the dashboards and reporting our business runs on. This is a Power BI–first, stakeholder-facing role: the majority of the work is designing, building, and maintaining Power BI dashboards — and partnering directly with Finance, Operations, Sales, and Marketing to turn ambiguous business questions into clear, trusted, decision-ready analytics.

A baseline understanding of data architecture (how a layered warehouse and dimensional models are structured) is important so you can collaborate effectively with data engineering and design performant, reliable reports. This role is ideal for someone who is a genuine Power BI craftsperson and equally comfortable sitting with a business leader to figure out what they actually need.

Essential Job Functions

Dashboard & Report Development (the core of the role)

• Build and maintain Power BI dashboards — design, develop, and iterate interactive dashboards and reports on the curated reporting layer, using DAX, Power Query (M), and strong data-modeling and visualization practices.
• Own the Power BI semantic model — build and maintain star-schema data models, relationships, measures, and calculation logic that are performant and reusable across reports.
• Optimize performance — tune models, DAX, and queries for speed and reliability; make deliberate Import vs. DirectQuery choices and manage refresh/query cost against BigQuery.

Stakeholder Partnership & Business Intelligence

• Understand the business problem — partner with Finance, Operations, Sales, and Marketing to translate ambiguous questions into well-defined KPIs, metric definitions, and the right visuals — confirming the requirement before building.
• Tell the story — apply data-visualization best practices to turn data into clear, usable insight — not just charts but answers a stakeholder can act on.
• Enable self-service — promote trusted, well-documented reports and datasets, and help business users get value from them independently.
• Document and build repeatable processes — maintain strong, clear documentation of requirements, metric definitions, and reporting logic, and establish repeatable processes and standards for how reporting requests are intake, prioritized, built, and validated.

Publishing, Governance & Report Lifecycle

• Deploy and operate in the Power BI Service — publish and manage workspaces, apps, and scheduled/gateway-managed refreshes; own reports through their full lifecycle including maintenance, troubleshooting, and UAT.
• Apply security and governance — implement row-level security (RLS) and follow governance best practices so the right people see the right data.
• Document — maintain metric definitions, data-model documentation, and report catalogs so reporting is understandable and maintainable.

Collaboration with Data Engineering

• Work the DE / BI seam — the data engineering function owns ingestion, pipelines, and the raw/transformed layers; you own the reporting layer and everything Power BI. Partner on data contracts, required datasets, freshness expectations, and reporting-layer schema so dashboards are built on a trusted foundation.

Required Qualifications

Core must-haves

• Power BI mastery — hands-on expertise across DAX, Power Query (M), data modeling, and row-level security — able to build and maintain dashboards independently, end to end.
• Advanced SQL — writing and optimizing complex queries (BigQuery preferred).
• Stakeholder & requirements skill — proven ability to gather requirements, translate business questions into metrics, and communicate clearly with non-technical audiences.
• Data-visualization judgment — a strong sense for visual best practices, dashboard UX, and data storytelling.
• Baseline data architecture understanding — dimensional modeling (star/snowflake), layered warehouse concepts, and how curated datasets are produced — enough to collaborate with data engineering and design reliable reports.
• 5–7 years in business intelligence, Power BI development, analytics, or a related field.
• Bachelor's degree in Computer Science, Information Systems, Analytics, or a related field — or equivalent practical experience.
• Strong problem-solving, a business-first mindset, and excellent cross-functional communication.
• Ability to connect Power BI directly to a cloud data warehouse (BigQuery preferred), not just flat files.

Preferred Qualifications

• Certifications — Microsoft Certified: Power BI Data Analyst Associate (PL-300); Fabric Analytics Engineer Associate (DP-600) a plus.
• Microsoft Fabric — familiarity with Fabric, semantic models, and Copilot / AI-assisted analytics features.
• Power BI Service administration — deployment pipelines, workspace governance, gateway configuration, and capacity/refresh management.
• Domain fit — healthcare, Pharma/OTC, agency, or marketing-analytics experience; familiarity with CRM/ERP data such as Salesforce and NetSuite.
• Light scripting — some Python or scripting for data prep or automation is helpful (but pipeline development is owned by data engineering).
• AI tooling — experience using AI/LLM platforms to accelerate analytics work (e.g., Copilot, Claude).

Tech Stack

Business Intelligence: PowerBI (Desktop & Service), DAX, Power Query (M), RLS; Tableau exposure welcome

Data & Warehouse: BigQuery (curated reporting layer), advanced SQL

Source-System Context: Salesforce (CRM), NetSuite (ERP), Google Analytics

Collaboration & Dev Tools: GitHub, Jira, Microsoft Teams