Orthodontic Partners logoOrthodontic Partners logo

Analytics Engineer

Orthodontic PartnersGrand Rapids, MI
On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Experience Level

Entry Level

Qualifications

• Proficiency in SQL and experience with data transformation processes.• Familiarity with data engineering concepts and analytics tools.• Strong analytical skills and attention to detail.• Ability to work collaboratively in a team environment.• Excellent problem-solving skills.

About the job

Orthodontic Partners (OP), founded by leading orthodontic professionals and located in Grand Rapids, MI, is an innovative and rapidly expanding national orthodontic service organization. We provide our partner doctors with comprehensive administrative, marketing, HR, and financial support services. Our mission is to redefine the orthodontic partnership model by merging top-tier business and clinical expertise, fostering insights that empower our partners, teams, and patients. We take pride in our world-class network of partners who share our values of collaboration, excellence, growth, and trust. With over 30 premier orthodontic practices across nearly 70 locations in 15 states, we are just beginning our journey. Join us as we transform the orthodontics landscape, making care more accessible, affordable, and efficient for patients.

Position Summary:

The Analytics Engineer acts as a vital connector between data engineering and analytics. This role focuses on constructing and enhancing data pipelines, analytical datasets, and reporting-ready data models. Ideal for an early-career professional eager to advance in the realms of data engineering and analytics, this position emphasizes SQL-driven data transformation, ensuring pipeline reliability, and developing analytics-ready data structures.

This position collaborates closely with the Data Engineer, BI Developer, and BI Manager to incorporate new data sources, structure data for reporting and analytics, and enhance the reliability, performance, and documentation of the analytics platform. Over time, we anticipate this role will evolve to include greater ownership of production datasets, data quality monitoring, and optimization of pipelines and semantic modeling.

Key Responsibilities:

• Develop and maintain SQL transformations to clean, standardize, and structure data for reporting, analytics, and self-service applications.
• Support the management of database objects such as tables, views, schemas, and transformations for reporting and analytics tools.
• Contribute to the creation and maintenance of structured data layers (e.g., raw, cleaned, reporting layers).
• Collaborate with the Data Engineer to onboard new data sources utilizing a modern analytics stack.
• Create and maintain curated datasets and reporting tables for Power BI and other internal tools.
• Execute data validation and reconciliation to guarantee accuracy and reliability.
• Aid in the development of data quality checks, monitoring, and alerts.
• Address data issues and facilitate root cause analysis.

About Orthodontic Partners

Orthodontic Partners is a pioneering orthodontic service organization dedicated to improving patient care and supporting orthodontic practices across the nation. With a commitment to collaboration and excellence, we empower our partners through innovative solutions and a robust support network.

Similar jobs

Browse all companies, explore by city & role, or SEO search pages.

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.