Business Intelligence Developer

Join SALT Dental Partners and be part of a dynamic team dedicated to revolutionizing the dental industry through innovative marketing strategies and exceptional patient experiences. Since our doors opened in 2019, our mission has been to help specialty dental providers grow their practices. SALT is creating a vast network of like-minded dental specialists throughout the country. At SALT, we provide comprehensive support services, allowing dental specialists to focus on delivering exceptional care.

The Business Intelligence (BI) Developer is responsible for transforming enterprise data into meaningful, actionable insights that support strategic and operational decision-making across SALT Dental Partners. This position designs, develops, and maintains dashboards, scorecards, semantic models, and reporting solutions for executive leadership and business functions including Operations, Finance, Revenue Cycle Management, Clinical Leadership, and Information Technology.

This role sits at the intersection of data, technology, and business performance, partnering with stakeholders to translate business questions into scalable analytics products. The ideal candidate combines strong Power BI development expertise, data modeling skills, and business acumen with a disciplined commitment to data quality, usability, governance, and measurable outcomes.

• Design, develop, test, deploy, and maintain enterprise dashboards, reports, and scorecards using Microsoft Power BI.
• Build executive, operational, financial, clinical, and revenue cycle reporting solutions that enable timely and actionable decision-making.
• Create reusable semantic models, datasets, report templates, and visualization standards that support consistent enterprise reporting.
• Develop self-service analytics capabilities while maintaining appropriate governance and control.

• Design and maintain dimensional data models that support enterprise reporting and analytics requirements.
• Develop DAX measures, calculated columns, KPIs, business logic, and analytical metrics.
• Translate complex business requirements into clear, scalable, and maintainable analytics solutions.
• Partner with the Data Engineer to align source data, transformations, data models, and reporting requirements.

• Collaborate with department leaders and subject matter experts to understand reporting needs, business objectives, and success measures.
• Facilitate requirements-gathering sessions and convert business questions into technical and analytical specifications.
• Present insights, trends, risks, and opportunities in a clear manner appropriate for technical and nontechnical audiences.
• Serve as a trusted partner for reporting, visualization, KPI definition, and analytics best practices.

• Validate report accuracy, completeness, consistency, and reconciliation across source systems and analytics products.
• Document report definitions, calculations, data sources, dependencies, refresh schedules, and ownership.
• Support enterprise data governance, data stewardship, metadata, lineage, and standardized KPI initiatives.
• Ensure reporting solutions comply with HIPAA, privacy requirements, and organizational security standards.

• Optimize Power BI datasets, semantic models, DAX calculations, refresh processes, and report performance.
• Monitor analytics solution health, usage, adoption, and stakeholder feedback.
• Troubleshoot reporting defects and complete root cause analysis in partnership with technical teams.
• Provide user training, documentation, and ongoing support for approved analytics solutions.
• Stay current on…