Business Intelligence Developer
Orthodontic Partners' Service Center
710 Kenmoor Ave SE, Suite 105, Grand Rapids, Michigan
Apply Now

Orthodontic Partners is a national Orthodontic Support Organization which acquires orthodontic practices and provides partner doctors with a full range of administrative, marketing, HR, financial support services. This enables partner doctors to maintain their clinical autonomy as well as the identity of their practice, while freeing them to focus on high quality and highly efficient patient care. Founded by Dr. Jamie Reynolds and Dr Jeff Kozlowski, two clinical experts in orthodontic efficiency, and led by Chip Hurlburt an experienced CEO, the organization is backed by FFL Partners, a long-standing healthcare investor. The founding doctors are also entrepreneurs. Both co-founded OrthoFi, a company that provides proprietary software and services to help make orthodontics more affordable. Orthodontic Partners seeks to revolutionize Orthodontics industry by making orthodontic care more convenient, affordable, faster and easier for patients.

Summary of Position:

The Business Intelligence Developer is responsible for developing, deploying and maintaining business intelligence interfaces thus providing the organization with the data needed to operate the business and support our practices’ efforts to provide excellent patient care. This role will interact with existing connections to key data sources, ensuring accurate data is available to users through tools such as dashboard tools. The position will work to establish connections to new data sources, validating the underlying data and making it available for use by end-users.

Essential Job Functions:

· Understand needs of key users, identify sources of data, develop connections, validates data, and build data models to facilitate appropriate types of reporting for the given need (i.e., ad hoc, daily automated reports, dashboards, etc.).

· Provide analytics that can turn data into critical information for leadership visibility and external key stakeholders.

· Translate and document business needs into technical solutions.

Knowledge, Skills and Abilities:

· Proficient understanding of SQL for data retrieval and strong ETL/data modeling skills.

· Demonstrated ability to ensure the right information is identified at the right time and at the appropriate level for reporting purposes.

· Be accountable for the accuracy of the data presented to BI users through the execution of validation processes and testing.

· Must be highly analytical and possess strong interpersonal skills.


· 2-5 years of relevant experience required

· Required Bachelor’s Degree or equivalent in computer science, information systems, software development, mathematics, engineering, business, liberal arts or other related field.

· Familiarity with at least one commonly used programming language.

· Data visualization experience in common business intelligence tools (PowerBI, Tableau, D3.js).

· Experience with SQL

Preferred Qualifications

· Familiarity with modern source / version control tools, i.e., git.

· Experience with scripting languages such as R and Python.

· Experience with cloud platforms such as AWS and Snowflake.

First 90 Days

· Determine priority metrics across the organization and develop a simple, intuitive, and useful dashboard for departmental needs.

Orthodontic Partners is an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status.

Back to Careers Page
Have any recommendations?