Advanced Analytics Analyst - Exempt

Data Analyst / Bi Developer (Power Bi)

Join our dynamic team as a data analyst / bi developer (power bi) where you will play a crucial role in supporting the surgical transformation & program management office (tpmo) process excellence team within the r&d function. This virtual position, based in mn, offers the flexibility to work remotely while contributing to projects that enhance decision-making and execution across r&d and adjacent business processes.

Responsibilities

• Publish and maintain power bi dashboards, reports, and semantic models supporting a wide range of r&d and adjacent business processes.
• Standardize kpi and metric definitions in partnership with stakeholders; document definitions and ensure consistent implementation across reporting assets.
• Develop and maintain core semantic data models (e.g., shared datasets) serving multiple stakeholders and business domains; apply best practices for star schema / dimensional modeling.
• Build and optimize dax measures and power query (m) transformations; apply repeatable patterns to improve maintainability and reduce rework.
• Improve report and dataflow performance, reduce manual reporting effort, and enhance reliability through troubleshooting and tuning.
• Support workspace/app refresh monitoring, troubleshooting, and production support activities.
• Interface primarily with process excellence reporting & analytics team members on technical and report development tasks; operate effectively in a team development environment.
• May work directly with domain smes to define metrics, validate results, and resolve data issues; perform data validation and reconciliation as needed.
• Act as a curious, self-starting learner who engages the broader data analyst community to understand data availability and access across pan-organizational data sources.
• Participate in collaborative development practices, including basic version control and peer review workflows.
• Other responsibilities, as required and assigned.

Qualifications

Must Haves

• bachelor's degree with 2 years of job-related experience or master's degree with 0 years of job-related experience.
• 2 years of data modeling and power bi development experience.

Nice To Haves

• demonstrated experience working in a medical device or regulated environment.
• experience partnering with stakeholders to translate requirements into analytics deliverables.
• ability to learn and adapt to changes in technology, processes, or requirements.
• solid collaboration and communication skills.
• proven ability to multi-task and shift priorities effectively.
• excellent interpersonal skills for communicating with stakeholders under deadline pressure.

Technical Skills

Power Bi / Bi Engineering

• experience applying star schema / dimensional modeling in production semantic models.
• working knowledge of report publishing/maintenance practices.
• familiarity with rls concepts and secure design patterns.
• basic performance tuning experience.
• experience with shared dataset management and multi-stakeholder semantic model design.

Intermediate Sql / Snowflake

• familiarity with ctes and window functions.
• experience building or partnering on curated views/tables designed for bi consumption.
• experience writing data validation and reconciliation queries.

Microsoft Power Platform

• power automate for scheduled notifications, refresh/alert workflows, and approvals.
• power apps for lightweight data capture, issue tracking, and intake forms.
• sharepoint lists familiarity.