Business Intelligence Engineer - Military Veterans Encouraged To Apply

🌍 Remote, USA 🎯 Full-time 🕐 Posted Recently

Job Description

About the job

Reports to: Sr Manager – BI Platform & Governance

Location: Hybrid (Malvern, PA or East Windsor, NJ – 3 days in-office/2 days work from home) or Remote (based on your proximity to our office locations)

Job Type: Full-Time

Salary: Commensurate with experience

Discretionary bonus eligible

HMP Global is a leading healthcare event and education company, with a dominant position in several therapeutic areas including Oncology, Psychiatry & Behavioral Health, Cardiovascular, Wound Care and Public Safety. With a mission to improve patient care, we deliver information and education to healthcare professionals through 400+ global, regional, and local events and reach over 4 million users monthly through digital networks and social channels.

As a BI Engineer, you will contribute to Power BI dashboard development and delivery across multiple business domains at HMP Global. This role focuses on building high-quality, well-modeled dashboards that deliver clear insights and support data-driven decision-making.

You will work closely with BI Engineers, Analytics Engineers, and business stakeholders to translate requirements into scalable Power BI solutions. This position is ideal for someone who has strong foundational Power BI experience and wants to deepen their expertise in data modeling, DAX optimization, and governed BI development within a modern Snowflake + dbt environment.

This role emphasizes disciplined development practices, performance awareness, and continuous growth in both technical and design capabilities.

Core Responsibilities

Develop and maintain Power BI dashboards from design through testing and deployment
Build dashboards that clearly communicate insights, trends, and business KPIs
Apply established storytelling and visualization best practices
Ensure dashboards are intuitive, consistent, and aligned to standardized KPI definitions
Implement filters, dynamic visuals, drill-through functionality, and contextual cues appropriately
Optimize dashboards for usability and performance
Create and maintain technical and business user documentation

Partner with stakeholders to gather reporting requirements
Translate business questions into structured dashboard specifications
Participate in iterative development cycles and incorporate feedback
Clearly communicate assumptions, limitations, and data definitions
Escalate ambiguity or architectural concerns to the BI Platform Manager

Develop and maintain Power BI semantic models using curated Snowflake data marts
Apply star and snowflake schema modeling principles under architectural guidance
Create calculated columns and measures using DAX
Implement standardized time intelligence and KPI calculations
Validate dashboard outputs against source data
Collaborate with Analytics Engineering to ensure dbt models support requirements

Develop intermediate DAX measures using CALCULATE, FILTER, variables, and time intelligence functions
Refactor measures for clarity and efficiency
Identify potential performance issues and escalate when needed
Follow established best practices for context management and filter behavior
Reduce unnecessary model bloat by selecting appropriate fields and granularity

Support CI/CD deployment processes across development and production environments
Participate in structured QA validation prior to release
Create and maintain documentation for dashboards and datasets

Follow standardized naming conventions and design templates
Use certified datasets when available to avoid duplication
Adhere to documentation and publishing protocols
Participate in code reviews and peer feedback sessions
Support workspace organization and access control adherence

Technical Requirements

2–4 years of Power BI development experience
Experience communicating technical topics to both technical and non-technical audiences
Strong understanding of data modeling fundamentals (fact/dimension design)
Intermediate DAX proficiency (CALCULATE, FILTER, ALL, variables, time intelligence)
Solid SQL skills
Experience connecting Power BI to Snowflake or similar cloud data warehouse
Familiarity with version control concepts
Understanding of Dev/Test/Prod deployment workflows
Familiarity with integrating AI into day-to-day work to increase efficiency