Sr Data Analyst

Nativeamericantalent; Lafayette (CO); On-site; USD 90,000 - 120,000; Full time

Job summary

Insight Global is seeking a Senior Data Analyst to support an R&D Surgical PMO. You will build and enhance Power BI reporting solutions to improve visibility and decision-making.

Strong hands-on BI development, semantic modeling, DAX, Power Query, and platform skills are required, including SQL/Snowflake, Git, and Power Platform tools. You’ll collaborate with SMEs to turn complex requirements into scalable dashboards, manage sprint work, and ensure data quality across reports in a regulated

Qualifications

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

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 reporting.
• Build reusable semantic models using dimensional/star schema practices.
• Develop and optimize DAX measures and Power Query transformations.
• Create effective drill-down paths, filters, tooltips, and report interactions.
• Establish visualization standards and documentation.
• Troubleshoot refresh times, latency, model size, and performance.
• Partner with SMEs and end users to prototype, validate, and refine reporting.
• Participate in Git workflows, branching, PRs, and code reviews.
• Leverage SQL and Snowflake to support reporting and data validation.
• Use Power Automate, Power Apps, and SharePoint Lists for automation.
• Manage work through intake, sprint planning, and backlog processes.
• Drive alignment with stakeholders on KPI definitions and delivery plans.
• Independently structure ambiguous requirements and propose solutions.
• Continuously improve reporting processes, models, and documentation.

Skills

Power BI development

DAX

Power Query (M)

SQL

Snowflake

Git

Power Automate

Power Apps

SharePoint Lists

Data visualization

Stakeholder management

Education

Bachelor’s degree with 4+ years of job-related experience

Master’s degree with 2+ years of job-related experience

Tools

SQL

Snowflake

Git/branching

CTEs and window functions

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].