Orthodontic Partners · 9 hours ago
Analytics Engineer
Grand Rapids, MI
Full-time
Onsite
Entry Level
1+ years expOrthodontic Partners is a fast-growing national orthodontic service organization that provides various support services to partner doctors. The Analytics Engineer role is designed for an early-career professional to build and improve data pipelines, analytical datasets, and reporting-ready data models, working closely with data engineering and analytics teams.
Health CareMedicalPersonal Health
Responsibilities
Write and maintain SQL transformations used to clean, standardize, and model data for reporting, analytics, and self-service use cases
Assist in managing database objects such as tables, views, schemas, and transformations used by reporting and analytics tools
Help build and maintain structured data layers (e.g., raw, cleaned, and reporting layers)
Work with the Data Engineer to onboard new data sources using a modern analytics stack
Create and maintain curated datasets and reporting tables consumed by Power BI and other internal tools
Perform data validation and reconciliation to ensure accuracy and reliability
Assist in developing data quality checks, monitoring, and alerting
Troubleshoot data issues and support root cause analysis
Document data pipelines, transformations, business logic, and data lineage
Contribute to experimentation and adoption of AI-driven tools or models to enhance analytics, data preparation, and insight generation
Qualification
Required
1–3 years of relevant experience in data analytics, business intelligence, data engineering, or a related role
Bachelor's Degree or equivalent experience in computer science, information systems, engineering, mathematics, business, or a related field
Experience working with SQL and relational databases
Exposure to reporting or analytics tools such as Power BI, Tableau, or similar platforms
Foundational SQL skills for querying, transforming, and validating data
Basic understanding of data modeling concepts for reporting and analytics
Enthusiasm and ability to learn cloud-based data platforms and modern analytics tools
Strong attention to detail and commitment to data accuracy
Analytical mindset with the ability to ask good questions and investigate data issues
Clear communication skills and comfort working with both technical and non-technical stakeholders
Preferred
Exposure to ETL/ELT concepts or analytics transformation frameworks
Familiarity with cloud-based data platforms (Azure preferred)
Experience with data ingestion or orchestration tools
Interest in data quality, automation, and scalable analytics
Curiosity about AI or advanced analytics techniques
Benefits
Monthly bonus opportunities
Medical/Rx
Dental
Vision coverage
Retirement plan (401-k) with a percentage match
Flexible spending accounts
Health savings accounts
Employee assistance program
Several other benefit options
Company
Orthodontic Partners
Orthodontic Partners provides orthodontic care, including traditional braces and aligners, to children, teens and adults.
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
unknownKey Investors
Friedman Fleischer & Lowe (FFL)
2019-11-15Private Equity
Leadership Team
Jeff Kozlowski
CCO Orthodontic Partners
Recent News
2023-05-13
2022-08-02
2022-05-24
Company data provided by crunchbase