Reporting Specialist I

Reporting Specialist I (Crystal Reports Wizard / SQL Sorcerer)

Location: Little Rock, AR (Lyon College School of Dental Medicine)
Type: Full-time | Exempt
Component: Enterprise Applications

Do you enjoy turning chaotic requests like “Can you pull a report of every procedure performed on Wednesdays by third-years in Clinic B… but only when the moon is waxing?” into clean, accurate reporting and dashboards?

Do you feel an unnatural sense of satisfaction when a query returns the correct row count on the first try?

If so… welcome. We’ve been expecting you.

Your Mission (Should You Choose to Accept It):

As the Reporting Specialist I, you’ll build and maintain reporting solutions that support clinical operations, academic leadership, and CODA accreditation compliance for the Lyon College School of Dental Medicine.

You’ll live at the intersection of:

• axiUm workflows
• Crystal Reports
• SQL data extraction
• and the sacred art of making data behave long enough to be audited.

What You’ll Actually Do (aka The Quest Log):

• Design, build, test, and deploy Crystal Reports used by clinical, academic, and administrative teams.
• Maintain a report catalog with naming conventions, version tracking, owners, and change logs (yes, we love documentation).
• Optimize reports so they run faster than “why is this taking so long?” can be spoken.
• Develop expertise in axiUm data structures and workflows (patient flow, procedures, billing, appointments, provider productivity… all the fun stuff).
• Produce and validate recurring CODA compliance reports with traceability and repeatable logic (so the auditors will never see you sweat).
• Support users who have forgotten what parameters are (again).
• Maintain reporting calendars, data dictionaries, and metric definitions so the organization has a true source-of-truth.
• Ensure all work respects HIPAA/FERPA, role-based access controls, and proper handling of protected data.
• Collaborate with stakeholders across clinic leadership, finance/insurance, compliance, and Institutional Research.

What We’re Looking For (Your Character Build):

Required

• Associate’s or Bachelor’s degree (or equivalent experience).
• 2 years of enterprise reporting experience (Crystal preferred).
• SQL query writing and troubleshooting skills.
  
  
• Ability to translate operational and accreditation needs into precise report specifications.
• Documentation discipline and attention to detail (the true superpower).
• Strong interpersonal skills and the ability to work effectively across faculty, staff, students, and clinical teams.

Bonus Points

• Experience with axiUm
• CODA accreditation reporting experience
• Familiarity with dental clinic workflows and coding concepts (CDT/ICD, billing, insurance)
• Power BI/Tableau experience

Why This Role Matters

What you build directly supports:

• clinical operations
• student success
• accreditation readiness
  …and ensures leadership has accurate information when it really counts.

If you like high-impact work where accuracy matters and your reports don’t just “look pretty,” we’d love to meet you.

📍 Apply now — and bring your favorite query.
(We won’t judge. Much.)

About Lyon College
Lyon College is a selective private liberal arts college affiliated with the Presbyterian Church (U.S.A.) in the historic town of Batesville, Arkansas. Home to more than 660 students from 30 states and 18 countries, the College is renowned for its inclusive and nurturing academic community. Batesville, with a population of 11,000, was named the Best City to Live in Arkansas by USA Today. It offers a safe, vibrant environment and is a regional hub for commercial, medical, and social activities.

Why Lyon?
At Lyon, we prioritize excellent teaching, inclusive environments, and the persistence and success of our students and faculty. We support innovative teaching, meaningful research, and professional development in a close-knit academic community. Our liberal arts foundation encourages students to think critically about their place in the world and explore diverse perspectives.

Application Process
Interested candidates should submit a cover letter, curriculum vitae, and contact information for three professional references to Human Resources, P.O. Box 2317, Batesville, AR 72503-2317, or electronically at https://lyon.bamboohr.com/careers. Review of applications will begin immediately and continue until the position is filled.

Equal Opportunity Employer
Lyon College does not discriminate based on race, color, religion, gender, age, disability, sexual orientation, or national origin. We comply with all federal and state laws regarding equal employment opportunities. Learn more about Lyon College at www.lyon.edu. Join us at Lyon College and be the difference in shaping the future of curious and dedicated students!