Business Intelligence Lead

CenterWell

1d • Remote

About The Position

Become a part of our caring community We are looking for an experienced and collaborative Business Intelligence Lead to join our CenterWell – Primary Care Organization (PCO) Analytics Team. The Business Intelligence Lead operates with a high level of autonomy, guiding business intelligence products from concept through delivery. The Business Intelligence Lead ensures reporting solutions are efficient, scalable, and aligned with organizational standards and user experience principles. This is an individual contributor role.

Requirements

• 5+ years of experience in business intelligence, analytics, or a related field.
• Expertise in Power BI, including data modeling, DAX, report performance optimization, and enterprise deployment patterns.
• Proficiency in SQL, including complex query development, performance tuning, and working with large datasets (Snowflake preferred).
• Demonstrated experience designing intuitive, user-centered dashboards grounded in data visualization and UX best practices.
• Design scalable and maintainable BI solutions for diverse business audiences.
• Ability to work across groups and influence partners without direct authority.
• Experience problem-solving with the ability to translate business questions into analytical solutions.

Nice To Haves

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
• Experience mentoring BI or analytics team members.
• Microsoft PL-300 Certification.
• Experience with additional data visualization tools (Tableau, Qlik, SSRS, or similar).
• Proficiency in Python or another object-oriented programming language for analytics or automation.
• Experience building analytics solutions in healthcare or regulated environments.
• Advanced experience with wireframing and prototyping tools such as Figma to support UX-driven analytics design.

Responsibilities

• Lead the design and development, and ongoing evolution of Power BI reports, dashboards, and semantic models with a focus on usability, clarity, and visual storytelling.
• Define best practices for Power BI data modeling, including star schema design, DAX optimization, and scalable semantic layers.
• Promote data visualization design principles, accessibility standards, and UX guidelines across the BI portfolio.
• Architect efficient, reusable, and scalable BI solutions that support growing data volume and evolving business needs.
• Partner with business leaders and report consumers to understand analytical needs and decision/operational workflows.
• Translate ambiguous or complex requirements into clear analytical designs and prototypes using Figma or other wireframing tools.
• Lead user testing and feedback cycles to improve report usability and adoption.
• Be a trusted advisor to partners by identifying insights, gaps, and opportunities for the BI portfolio.
• Create and improve complex Snowflake SQL queries, ensuring performance, reliability, and maintainability.
• Promote documentation of data models, report logic, design decisions, and technical architecture.
• Ensure production BI assets are reliable, well-governed, and support self-service analytics where needed.
• Mentor and assist junior team members, providing technical guidance on Power BI, SQL, visualization design, and UX.
• Support skill development across the team through design reviews, knowledge sharing, and recommended learning paths.
• Collaborate with data engineering, analytics, and business teams to work together on data definitions, metrics, and delivery timelines.

Benefits

• medical benefits
• dental benefits
• vision benefits
• 401(k) retirement savings plan
• time off (including paid time off, company and personal holidays, volunteer time off, paid parental and caregiver leave)
• short-term disability
• long-term disability
• life insurance
• bonus incentive plan

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed