Senior Business Intelligence Analyst

Position Overview

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.

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.

This is a hybrid position with 3 days onsite per week in Woodcliff Lake, NJ.

Essential Job Functions

Dashboard & Report Development (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.

Qualifications

• 5 to 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.
• Hands on Power BI expertise across DAX, Power Query (M), data modeling, and row level security, with the ability to build and maintain dashboards independently end to end.
• Advanced SQL, including writing and optimizing complex queries and connecting Power BI directly to a cloud data warehouse rather than flat files (BigQuery preferred).
• Proven ability to gather requirements, translate business questions into metrics, and communicate clearly with nontechnical audiences and cross functional partners, backed by strong problem solving and a business first mindset.
• Strong data visualization judgment, including visual best practices, dashboard UX, and data storytelling.
• Working knowledge of data architecture (star and snowflake dimensional modeling, layered warehouse concepts, and how curated datasets are produced) sufficient to collaborate with data engineering and design reliable reports.

Preferred Qualifications

• Microsoft Certified Power BI Data Analyst Associate (PL 300).
• Power BI Service administration, including deployment pipelines, workspace governance, gateway configuration, and capacity and refresh management.
• Experience in healthcare, Pharma/OTC, agency, or marketing analytics.
• Experience with CRM/ERP data such as Salesforce and NetSuite.
• Light Python or scripting for data prep or automation.
• Experience using AI/LLM platforms such as Copilot or Claude to accelerate analytics work.

Benefits

• Responsible unlimited PTO, 13 paid holidays, plus the week between Christmas and New Year’s off, and one paid volunteer day
• Full medical benefits
• 401(k) match with vesting from day one