Senior Power BI & Data Modeling Analyst

Insight Global; Lafayette (CO); On-site; USD 110,000 - 150,000; Full time

Job summary

Insight Global is seeking a Senior Data Analyst to build and enhance Power BI reporting solutions for an R&D Surgical PMO Compliance team. You will translate KPI definitions into decision-focused dashboards, develop semantic models, and optimize DAX and Power Query, collaborating with SMEs and analytics partners to deliver scalable reporting.

The role demands hands-on Power BI development, data visualization excellence, and experience with SQL/Snowflake, Git, and Microsoft Power Platform tools

Qualifications

• Bachelor’s degree with 4+ years of job-related experience or Master’s with 2+ years of job-related experience.
• 2+ years of Power BI development and data modeling experience.
• Strong Power BI dashboard/report development skills.
• Experience developing reusable semantic models and applying star schema/dimensional modeling principles.
• DAX and Power Query (M) experience.
• Experience with SQL, Snowflake, and Git/branching.
• Medical device industry experience and working in a regulated environment.
• Advanced Power BI visualization, storytelling, and UX skills.

Responsibilities

• Design and develop Power BI dashboards and reports for the Surgical PMO Compliance team.
• Translate business questions and KPI definitions into intuitive, decision-focused reporting.
• Build reusable semantic models utilizing dimensional/star schema best practices.
• Develop and optimize DAX measures and Power Query transformations.
• Create effective drill-down paths, filters, tooltips, and report interactions.
• Establish visualization, accessibility, naming, and documentation standards.

Skills

Power BI

Data modeling

DAX

Power Query

SQL

Snowflake

Git

Stakeholder mgmt

Education

Bachelor’s degree

Master’s degree

Tools

Power BI

SQL

Snowflake

Git

Power Automate

Power Apps

SharePoint Lists

Job description

Insight Global is seeking a Senior Data Analyst to build and enhance Power BI reporting solutions for an R&D Surgical PMO Compliance team. You will translate KPI definitions into decision-focused dashboards, develop semantic models, and optimize DAX and Power Query, collaborating with SMEs and analytics partners to deliver scalable reporting.

The role demands hands-on Power BI development, data visualization excellence, and experience with SQL/Snowflake, Git, and Microsoft Power Platform tools