Business Intelligence Developer
Description
Company Overview
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.
Position Summary
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.
Key Responsibilities
Business Intelligence Development
- 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.
Data Modeling & Analytics
- 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.
Stakeholder Engagement & Business Partnership
- 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.
Data Quality & Governance
- 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.
Performance Optimization & Support
- 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.
Market & Technology Intelligence
- Stay current on developments in Power BI, Microsoft Fabric, data visualization, healthcare analytics, and self-service business intelligence.
- Evaluate new analytics capabilities and recommend practical enhancements to the enterprise reporting ecosystem.
Requirements
- Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Business Analytics, Statistics, or a related field; equivalent professional experience may be considered.
- 3+ years of business intelligence, analytics, or enterprise reporting experience.
- 3+ years of hands-on Microsoft Power BI development experience, including DAX, Power Query, semantic models, and report publishing.
- Strong knowledge of SQL, relational databases, data warehousing, and dimensional modeling principles.
- Demonstrated experience creating executive dashboards, operational scorecards, and standardized KPI reporting.
- Experience gathering requirements and translating business needs into clear technical solutions.
- Strong analytical, troubleshooting, data validation, and problem-solving skills.
- Ability to explain technical and analytical concepts to nontechnical stakeholders.
- Experience with Microsoft Fabric, Azure data services, SQL Server, Snowflake, or Databricks is preferred.
- Experience in healthcare, dentistry, a DSO, multi-site operations, revenue cycle, finance, or regulated industries is preferred.
- Strong knowledge of HIPAA, privacy, security, and responsible data-handling practices.
- Detail oriented and comfortable working in a fast-paced environment.
- Excellent oral and written communication and strong interpersonal skills.
- Desire and ability to learn new skills and be a team player.
- Ability to act with integrity, professionalism, and confidentiality.
Physical Requirements
- The following physical demands would apply to this job up to 40% of the time: Ability to lift, carry, or pull or push 25 lbs.
Benefits
- Competitive salary
- Comprehensive benefits package (medical, dental, vision)
- Retirement Plan (401k with Company Match, IRA)
- Life Insurance (Basic, Voluntary & AD&D)
- Paid Time Off (Vacation, Sick & Public Holidays)
- Opportunities for professional development and growth
- Flexible remote work environment
Salt Dental Partners is an Equal Opportunity Employer. This job description is intended to describe the general nature and level of work being performed and is not an exhaustive list of all responsibilities and duties.