Sr Data Analyst
insight globalLafayette, CO
Sr Data Analyst
insight globalLafayette, CO
2 days ago
Industries
Custom Computer Programming ServicesGeneral Medical and Surgical HospitalsResearch and Development in BiotechnologyAbout the role
Senior 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.
Matching similar jobs
JOB OVERVIEW
Experience level
Lead
Location
Lafayette, CO
Occupation
Data Warehousing Specialists
Industry
Custom Computer Programming Services
Posted
2 days ago
Tired of running searches?
Rank the roles you'd take once, and matches like these arrive on their own.
CREATE PROFILE (opens in a new tab)