Sr Data Analyst

Required Skills & Experience

• 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

Nice to Have Skills & Experience

• 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

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.