Sr Data Analyst

African American Talent; Lafayette (CO); On-site; USD 110,000 - 150,000; Full time

Job summary

Insight Global is seeking a Senior Data Analyst for a top medical technology/R&D client. You will build Power BI reporting solutions that improve visibility and drive decision-making across the organization.

The role requires hands-on Power BI, semantic data modeling, DAX, Power Query, and experience with SQL/Snowflake, Git, and Microsoft Power Platform in a regulated environment. Collaboration with SMEs and analytics partners is essential.

Qualifications

• Bachelor’s degree with 4+ years of job-related experience
• 2+ years of Power BI development and data modeling experience
• Experience in a regulated medical device environment
• Strong data visualization and storytelling skills
• Ability to translate complex business questions into actionable reports

Responsibilities

• Design and develop Power BI dashboards and reports for the Surgical PMO Compliance team within R&D
• 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
• Troubleshoot and optimize refresh times, query latency, model size, and overall report performance
• Partner with SMEs and end users to prototype, validate, and refine reporting solutions
• Participate in Git/version-control workflows, branching, pull requests, and peer code reviews
• Leverage SQL and Snowflake to support reporting and data validation needs
• Use Power Automate, Power Apps, and SharePoint Lists for workflow automation and supporting processes
• Manage work through intake, prioritization, sprint planning, and backlog processes
• Drive alignment with stakeholders on KPI definitions, priorities, and delivery plans
• Independently structure ambiguous requirements and recommend solutions
• Continuously improve reporting processes, models, performance, and documentation

Skills

Power BI

Data modeling

DAX

Power Query

SQL

Snowflake

Git

Stakeholder management

UX visualization

Education

Bachelor’s degree

Master’s degree

Tools

Git

Power BI

Power Automate

Power Apps

SharePoint

Snowflake

Job description

Job Description

• Design and develop Power BI dashboards and reports for the Surgical PMO Compliance team within R&D
• 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
• Troubleshoot and optimize refresh times, query latency, model size, and overall report performance
• Partner with SMEs and end users to prototype, validate, and refine reporting solutions
• Participate in Git/version-control workflows, branching, pull requests, and peer code reviews
• Leverage SQL and Snowflake to support reporting and data validation needs
• Use Power Automate, Power Apps, and SharePoint Lists for workflow automation and supporting processes
• Manage work through intake, prioritization, sprint planning, and backlog processes
• Drive alignment with stakeholders on KPI definitions, priorities, and delivery plans
• Independently structure ambiguous requirements and recommend solutions
• Continuously improve reporting processes, models, performance, and documentation

Job Description:Insight Global is seeking a Senior Data Analyst for a top medical technology/R&D client. This individual will support an R&D Surgical Program Management Office Compliance team, with a primary focus on building and enhancing Power BI reporting solutions that improve visibility and decision‑making across the organization. The ideal candidate brings strong hands‑on Power BI development, semantic data modeling, DAX, Power Query, and data visualization experience, while being comfortable leveraging SQL/Snowflake, Git, and Microsoft Power Platform tools as needed. This person will work closely with SMEs and analytics partners to turn complex business requirements into scalable, intuitive reporting solutions while independently driving moderately complex projects in a collaborative sprint/backlog environment.

Skills and Requirements

• Bachelor’s degree with 4+ years of job‑related experience OR Master’s degree 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 data modeling and related technologies such as SQL, Snowflake, and Git/branching
• Medical device industry experience
• Experience working in a regulated environment
• Advanced Power BI visualization, storytelling, and UX skills
• Production experience with star schema/dimensional modeling
• Power BI workspace/app publishing, refresh monitoring, and troubleshooting
• Row‑Level Security (RLS) and secure reporting design knowledge
• Power BI performance tuning, including DAX optimization, model‑size reduction, and aggregations
• Shared dataset and multi‑stakeholder semantic model experience
• Intermediate SQL/Snowflake, including CTEs and window functions
• Experience developing curated views/tables for BI consumption
• Data validation, reconciliation, and end‑to‑end data troubleshooting experience
• Git/version control, branching, pull requests, and code review experience
• Microsoft Power Automate experience with notifications, alerts, refresh workflows, and approvals
• Microsoft Power Apps experience with lightweight data capture, issue tracking, and intake forms
• SharePoint Lists experience
• Experience working within sprint, backlog, and product/team operating models
• Strong stakeholder management and communication skills

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 employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to 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 the recruiting process, please send a request to [e-mail].