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. Weve been expecting you.

Your Mission (Should You Choose to Accept It):

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

Youll 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 Youll 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 Were Looking For (Your Character Build):

• Associates or Bachelors 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 dont just look pretty wed love to meet you.

Apply now and bring your favorite query.
(We wont 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 11000 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 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 . Join us at Lyon College and be the difference in shaping the future of curious and dedicated students!

Required Experience:

Manager