Business Intelligence Engineer - Military Veterans Encouraged To Apply

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 Power BI Development & Visualization

• 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

Requirements

Gathering & Stakeholder Support

• 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

Data Modeling & Snowflake Alignment

• 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

DAX Development & Performance Optimization

• 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

CI/CD & Development Process

• 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

BI Governance & Standardization

• 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 Required

• 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

Preferred

• Exposure to dbt-based data modeling environments
• Experience with CI/CD pipelines for BI deployments
• Familiarity with performance tuning techniques in Power BI and external tools
• Experience implementing and maintaining Row-Level Security (RLS)
• Understanding of KPI standardization and governed BI frameworks

Please follow HMP Global on LinkedIn for news and updates Job Type: Full-time Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Retirement plan
• Vision insurance

Compensation

Package:

• Bonus opportunities
• Yearly pay

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Work Location: Hybrid remote in Malvern, PA 19355 Apply tot his job Apply To this Job