Data Analyst

AICA Orthopedics, P.C.•Marietta, GA

16d•Onsite

About The Position

ProCo is hiring a Data Analyst to own clean, reliable data for its Analytics team. The role extracts data from healthcare systems, cleans and reconciles it, segments it, and automates manual work. It is a development role with direct coaching from the Director, hands-on exposure to a new data warehouse, and a path to Senior Data Analyst or Business Analyst. ProCo is a growing healthcare organization with 21 clinics and surgery centers across metro Atlanta and five service lines. Data comes from EHR, practice management, billing, payroll, and financial systems. The organization is investing in analytics and building a new data warehouse. The role is onsite in Marietta, Georgia, and involves protected health information requiring HIPAA compliance. Applicants must be based in Atlanta; sponsorship is not available.

Requirements

1–3 years of hands-on experience in a data analyst, reporting analyst, or data role.
Solid SQL skills, including multi-table joins, filtering, and aggregations; CTEs and window functions are a plus.
Advanced Excel skills, including pivot tables, XLOOKUP or INDEX-MATCH, and Power Query.
An automation mindset, with examples of turning a manual process into a repeatable one.
Coachable and eager to learn, with high attention to detail.
Clear written and verbal communication about data and its limitations.
Bachelor’s degree in information systems, data analytics, statistics, economics, finance, business, or a related field.
Must be based in Atlanta; sponsorship is not available.
HIPAA compliance is required for work involving protected health information.

Nice To Haves

Power BI, including data modeling.
Python (pandas) or another scripting language.
Exposure to a data warehouse, ETL tools, or Git.
Healthcare data experience, including CPT/ICD codes, payer mix, A/R, claims, and remittance.
Experience presenting data.

Responsibilities

Pull data from EHR, practice management, billing, payroll, and GL systems using SQL and system exports.
Join and consolidate data from multiple sources into reliable datasets.
Identify and fix data gaps, duplicates, mismatched codes, and inconsistent definitions before data reaches reports.
Match provider, payer, and patient records across systems so each is counted once.
Reconcile totals across systems, such as billing versus the general ledger, and flag discrepancies.
Segment data by practice, provider, payer, service line, and period.
Maintain standard datasets behind recurring reports and refresh Power BI dashboards.
Deliver datasets on deadline with a short note describing their contents and caveats.
Maintain data dictionaries, standard definitions, and a query library.
Automate repetitive data pulls and cleanup steps, and add quality checks to recurring work.
Learn analysis methods from the Director, including drivers, variances, and practice and provider performance.
Support the data warehouse build by loading sources, mapping fields, and testing data.
Present datasets and findings in team meetings.