Power BI Engineer

Insight Global; Waltham (MA); On-site; USD 71,635,000 - 99,187,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

HSA

FSA

401K

Paid time off

Paid sick leave

Job summary

Insight Global is seeking a Power BI Engineer to join its data team in a hands-on role focused on building robust dashboards and data models. You will collaborate with business users, analysts, and data engineers to translate requirements into scalable BI solutions, while ensuring governance and performance.

The position reports to the Senior Director of Data Engineering. The role emphasizes BI development, dashboard creation, and data modeling across the analytics stack, with responsibilities

Qualifications

• Minimum 5 years of Power BI development experience.
• Strong proficiency in DAX, Power Query (M), and SQL
• Experience with relational databases and data modeling
• Familiarity with Azure data services (e.g., Synapse, Data Lake)
• Bachelor’s degree in computer science, Information Systems, or a related field
• Solid understanding of data governance, performance tuning, and visualization best practices
• Experience in the pharmaceutical industry
• Background in R&D dashboard development
• Ability to lead requirements workshops, demos, and training sessions with non-technical users

Responsibilities

• Design and develop Power BI dashboards and reports
• Create data models using Power BI Desktop, DAX, and Power Query
• Collaborate with stakeholders to gather requirements and define KPIs
• Manage data connections and transformations, and optimize performance
• Implement row-level security and ensure adherence to data governance standards
• Schedule and publish reports to Power BI Service and manage workspaces
• Troubleshoot data issues and provide support to end-users
• Maintain documentation for dashboards and data processes

Skills

Power BI development

DAX

Power Query

SQL

Azure data services

Relational databases

Data governance

Visualization best practices

R&D dashboard development

Stakeholder workshops

Education

Bachelor’s degree in computer science, Information Systems, or related field

Tools

Azure Synapse

Data Lake

SQL Server

Power BI Desktop

Job description

Job Description

A growing biopharma company is seeking a Power BI Engineer to join their data team. The team includes developers, analysts, and engineers, and this role reports directly to the Senior Director of Data Engineering.

The role is divided as follows:

• 50% Power BI development
• 30% Dashboard creation
• 20% Data modeling

You will work closely with business users, analysts, and data engineers to gather requirements, define KPIs, and deliver impactful data visualizations.

Key Responsibilities:

• Design and develop Power BI dashboards and reports
• Create data models using Power BI Desktop, DAX, and Power Query
• Collaborate with stakeholders to gather requirements and define KPIs
• Manage data connections and transformations, and optimize performance
• Implement row-level security and ensure adherence to data governance standards
• Schedule and publish reports to Power BI Service and manage workspaces
• Troubleshoot data issues and provide support to end-users
• Maintain documentation for dashboards and data processes

Compensation:

$50/hour to $60/hour

Exact compensation may vary based on several factors, including skills, experience, and education.

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401K retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• Minimum 5 years of Power BI development experience
• Strong proficiency in DAX, Power Query (M), and SQL
• Experience with relational databases and data modeling
• Familiarity with Azure data services (e.g., Synapse, Data Lake)
• Bachelor’s degree in computer science, Information Systems, or a related field
• Solid understanding of data governance, performance tuning, and visualization best practices
• Experience in the pharmaceutical industry
• Background in R&D dashboard development
• Ability to lead requirements workshops, demos, and training sessions with non-technical users