Sr Power BI Developer

Company Overview

For over 40 years, Health Monitor has been a nationally recognized, targeted healthcare marketing platform for the Pharma/OTC industry. Our in-house, award-winning content studio creates bespoke healthcare education that fosters more productive patient-physician dialogues at every point of care — we call it #TheHealthMonitorDifference. We have the largest proprietary physician office network in the industry, with over 250,000 offices and more than 450,000 healthcare professionals engaging with our omnichannel educational products. Health Monitor delivers premium point-of-care content that empowers patients and HCPs with trusted information to achieve the best health outcomes while driving impactful ROI for brands.

Learn more at healthmonitornetwork.com and follow us on LinkedIn, X, YouTube and Instagram.

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.

You'll work on top of a curated BigQuery reporting layer maintained by our data engineering function, so you can focus on the semantic model, the metrics, the visuals, and the business conversation — not on building pipelines. 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.

Plus

• 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)
• 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: Power BI (Desktop & Service), DAX, Power Query (M)

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

Source-System Context: Salesforce (CRM), NetSuite (ERP), digital/campaign analytics

Collaboration & Dev Tools: GitHub, Jira, Microsoft Teams

Key Performance Indicators (KPIs)

• Dashboard adoption and stakeholder satisfaction across Finance, Ops, Sales, and Marketing.
• Turnaround time from business question to delivered, trusted metric.
• Report/refresh reliability and dashboard performance.
• Growth in trusted self-service reporting.

ADA – Physical Demands (Office Position)

While performing the duties of this job, the employee is frequently required to sit; use hands to finger, handle, or feel objects, tools, or controls; talk and hear. The employee frequently uses a computer keyboard and views computer monitors for extended periods. Specific vision abilities required by this job include close vision and the ability to adjust focus.

Candidates must be legally authorized to work in the United States. This position is not eligible for visa sponsorship.