Data Analyst

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