Description
Atlanta based candidates only.
No sponsorship available.
About the role
ProCo is hiring a Data Analyst to own clean, reliable data for our Analytics team. You’ll pull data from healthcare systems, clean and reconcile it, segment it, and automate the manual work along the way. It’s a development role with direct coaching from the Director, hands-on exposure to our new data warehouse, and a path to Senior Data Analyst or Business Analyst.
Who we are
ProCo is a growing healthcare organization with 21 clinics and surgery centers across metro Atlanta and 5 service lines. Data flows in from EHR, practice management, billing, payroll and financial systems. We’re investing in analytics, including a new data warehouse being built now, and we’re growing the team that turns that data into one clear picture of the business.
What you’ll do
Extract and consolidate
- Pull data from EHR, practice management, billing, payroll and GL systems using SQL and system exports
- Join and consolidate multi-source data into single, reliable datasets
Clean, match and reconcile
- Find and fix gaps, duplicates, mismatched codes and inconsistent definitions before data reaches a report
- Match provider, payer and patient records across systems so each is counted once
- Reconcile totals across systems (for example, billing vs. GL) and flag what doesn’t tie
Segment and deliver
- Segment data by practice, provider, payer, service line and period
- Maintain the standard datasets behind recurring reports and refresh Power BI dashboards
- Deliver datasets on deadline with a short note on contents and caveats
Document and automate
- Maintain data dictionaries, standard definitions and a query library
- Automate repetitive pulls and cleanup steps, and add quality checks to recurring work
Grow into
- Learn the analysis side from the Director: drivers, variances, practice and provider performance
- Support the data warehouse build: loading sources, mapping fields and testing data
- Present datasets and findings in team meetings
What success looks like at 12 months
- Clean data: core recurring datasets documented, reconciled and trusted by the Director without re-checking
- Automation: at least three manual processes automated
- Delivery: requests delivered accurately and on deadline
- Growth: first analysis assignments completed with the Director, contributing to the warehouse build, and presenting to the team
What you bring
Required
- 1–3 years of hands-on experience in a data analyst, reporting analyst or data role
- Solid SQL: multi-table joins, filtering and aggregations (CTEs and window functions a plus; we’ll teach the rest)
- Advanced Excel: pivot tables, XLOOKUP/INDEX-MATCH, 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 limits
- Bachelor’s degree in information systems, data analytics, statistics, economics, finance, business or a related field
Nice to have
- Power BI, including data modeling
- Python (pandas) or another scripting language
- Exposure to a data warehouse, ETL tools or Git
- Healthcare data: CPT/ICD codes, payer mix, A/R, claims and remittance
- Experience presenting data
Benefits
- Medical, dental and vision insurance
- 401(k)
- Paid time off
Work environment
- Onsite in Marrietta, GA
- Role involves protected health information and requires HIPAA compliance
ProCo LLC is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status or any other characteristic protected by law.
Requirements
Required
- 1–3 years of hands-on experience in a data analyst, reporting analyst or data role
- Solid SQL: multi-table joins, filtering and aggregations (CTEs and window functions a plus; we’ll teach the rest)
- Advanced Excel: pivot tables, XLOOKUP/INDEX-MATCH, 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 limits
- Bachelor’s degree in information systems, data analytics, statistics, economics, finance, business or a related field
Nice to have
- Power BI, including data modeling
- Python (pandas) or another scripting language
- Exposure to a data warehouse, ETL tools or Git
- Healthcare data: CPT/ICD codes, payer mix, A/R, claims and remittance
- Experience presenting data
Skills Required
- 1-3 years of hands-on experience in a data analyst, reporting analyst, or related data role
- Solid SQL skills, including multi-table joins, filtering, and aggregations
- Advanced Excel skills, including pivot tables, XLOOKUP or INDEX-MATCH, and Power Query
- Examples of automating manual processes into repeatable workflows
- Coachability, eagerness to learn, and strong 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
- Power BI experience, including data modeling
- Python with pandas or another scripting language
- Exposure to data warehouses, ETL tools, or Git
- Healthcare data experience, including CPT/ICD codes, payer mix, A/R, claims, or remittance
- Experience presenting data
Similar Jobs
What We Do
ProCo is a medical management company that oversees the daily operations and back-end office workings of healthcare centers across the Southeast.
