Sr Power BI Analyst

ADP, Inc.

Montvale (NJ)

Hybrid

USD 100,000 - 130,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Health Monitor Network is seeking a Senior Power BI Analyst for a hybrid role based in Montvale, NJ. You will own the dashboards and reporting that power Finance, Operations, Sales, and Marketing decisions.

You should bring 5–7 years in BI, strong Power BI, SQL, and data‑modeling skills, plus a background in dimensional modeling and cloud data warehouses. Collaboration with data engineering and governance is essential.

Qualifications

  • Power BI mastery across DAX, Power Query (M), data modeling, and row‑level security.
  • Advanced SQL development and optimization, BigQuery preferred.
  • Ability to gather requirements, translate questions into metrics, and communicate with non‑technical audiences.
  • Strong data‑visualization judgment and dashboard UX skills.
  • Baseline data architecture understanding to collaborate with data engineering.
  • 5–7 years in BI, Power BI development, analytics, or related field.
  • Bachelor\'s degree in CS/IS/Analytics or equivalent experience.
  • Ability to connect Power BI to a cloud data warehouse (BigQuery preferred).
  • Familiarity with CRM/ERP data (Salesforce, NetSuite) is a plus.

Responsibilities

  • Design, build, and maintain Power BI dashboards end‑to‑end.
  • Own the Power BI semantic model and star schemas for reusable reports.
  • Optimize performance across models, measures, and queries.
  • Translate ambiguous business questions into KPIs and visuals.
  • Tell the data story with actionable insights for stakeholders.
  • Promote trusted, self‑service reporting and well‑documented datasets.
  • Document requirements, metrics, and reporting logic; establish repeatable processes for requests.

Skills

Power BI mastery
Advanced SQL
Stakeholder skills
Data visualization
Dimensional modeling
BI experience
Bachelor's degree
Cross-functional comms
Cloud data warehouse
BigQuery

Education

Bachelor\'s degree or equivalent

Tools

BigQuery
Microsoft Fabric
Power BI
DAX
Power Query (M)
Salesforce
NetSuite

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Sr Power BI Analyst

Full Time 30-39 Hour Montvale, NJ, US

30+ days ago Requisition ID: 1045

Salary Range: $100,000.00 To $130,000.00 Annually

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

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

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Power BI Consultant
Power BI Consultant

BinTech Group • Jersey City (NJ)

On-site
USD 90,000 - 120,000
Power BI Developer (Custom Visualizations, DAX & SQL)
Power BI Developer (Custom Visualizations, DAX & SQL)

Axiom Path • Charlotte (NC)

Hybrid
USD 90,000 - 140,000
Senior Business Analyst
Senior Business Analyst

IGEL Technology • United States

Hybrid
USD 110,000 - 140,000
Senior Power BI Developer — Hybrid NYC, Data Analytics Lead
Senior Power BI Developer — Hybrid NYC, Data Analytics Lead

Compunnel Inc. • New York (NY)

Hybrid
USD 110,000 - 160,000
Senior Power BI Developer
Senior Power BI Developer

Jobgether • Oregon

Hybrid
USD 41,000 - 55,000
Senior Power BI Developer
Senior Power BI Developer

Compunnel Inc. • New York (NY)

Hybrid
USD 110,000 - 160,000
Senior Power BI Developer
Senior Power BI Developer

DCS Corporation • Alexandria (VA)

Remote
USD 100,000 - 135,000
Power BI Developer1
Power BI Developer1

Cooperdyne Tech • United States

Remote
USD 100,000 - 170,000
Competitive salary
Comprehensive health benefits
Paid time off
+2
Power BI Senior Developer
Power BI Senior Developer

Balfour Beatty US • Dallas (TX)

Hybrid
USD 110,000 - 150,000
Power BI Developer
Power BI Developer

Sycamore Staffing Partners • Texas

On-site
USD 90,000 - 150,000